Posted By

wh0emPah on 04/02/10


Tagged


Versions (?)

ee


 / Published in: PL/SQL
 

  1. PACKAGE P5_summit_pkg AS
  2. e_no_fk_constraint EXCEPTION;
  3. PRAGMA EXCEPTION_INIT(e_no_fk_constraint,-2291);
  4.  
  5. TYPE type_coll_onaf_orders IS
  6. t_onafgewerkte_orders type_coll_onaf_orders;
  7.  
  8. CURSOR C_Overzicht_P_WH IS
  9. SELECT PRODUCT_ID,
  10. (SELECT NAME FROM S_PRODUCT WHERE ID= PRODUCT_ID) NAME, WAREHOUSE_ID,
  11. (SELECT CITY FROM S_WAREHOUSE WHERE ID=WAREHOUSE_ID)
  12. FROM S_INVENTORY
  13. ORDER BY WAREHOUSE_ID, NAME;
  14.  
  15.  
  16. PROCEDURE P1_1_VOEG_KLANT_TOE
  17. (
  18. p_id IN S_CUSTOMER.ID%TYPE,
  19. p_name IN S_CUSTOMER.NAME%TYPE,
  20. p_phone IN S_CUSTOMER.PHONE%TYPE,
  21. p_address IN S_CUSTOMER.ADDRESS%TYPE,
  22. p_city IN S_CUSTOMER.CITY%TYPE,
  23. p_state IN S_CUSTOMER.STATE%TYPE,
  24. p_country IN S_CUSTOMER.COUNTRY%TYPE,
  25. p_zipcode IN S_CUSTOMER.ZIP_CODE%TYPE
  26. );
  27.  
  28. PROCEDURE P1_2_VOEG_ORDER_TOE
  29. (
  30. P_ID IN S_ORD.ID%TYPE
  31. , P_CUSTOMERID IN S_ORD.CUSTOMER_ID%TYPE
  32. , P_SALES_REP_ID IN S_ORD.SALES_REP_ID%TYPE
  33. , P_DATE_ORDERED IN S_ORD.DATE_ORDERED%TYPE
  34. , P_PAYMENT_TYPE IN S_ORD.PAYMENT_TYPE%TYPE
  35. );
  36.  
  37. PROCEDURE P1_3_VOEG_ORDERLIJN_TOE
  38. (
  39. P_ORD_ID IN S_ITEM.ORD_ID%TYPE
  40. , P_PRODUCT_ID IN S_ITEM.PRODUCT_ID%TYPE
  41. , P_PRICE IN S_ITEM.PRICE%TYPE
  42. , P_QUANTITY IN S_ITEM.QUANTITY%TYPE
  43. );
  44.  
  45. PROCEDURE P2_2_HOOGSTE_VOORRAADWAARDE;
  46. PROCEDURE P4_4_VERWIJDER_MEDEWERKER(
  47. MED_ID IN S_EMP.ID%TYPE);
  48. PROCEDURE P4_4_VERWIJDER_MEDEWERKER(
  49. P_LAST_NAME IN S_EMP.LAST_NAME%TYPE,
  50. P_FIRST_NAME IN S_EMP.FIRST_NAME%TYPE);
  51.  
  52.  
  53.  
  54. PROCEDURE VERWIJDER_ORDER
  55. (p_ordid IN s_ord.id%TYPE);
  56.  
  57. FUNCTION P1_5_TOTAALBEDRAG_ORDERS
  58. (P_PERSONEELSNUMMER IN PLS_INTEGER)RETURN NUMBER;
  59.  
  60. FUNCTION P1_7_KLEINSTE_VOORRAAD RETURN NUMBER;
  61.  
  62. END P5_summit_pkg;

Report this snippet  

You need to login to post a comment.