PACKAGE: APPS.GML_OP_CNTR_HDR_PKG

Source

1 PACKAGE gml_op_cntr_hdr_pkg AUTHID CURRENT_USER AS
2 /* $Header: GMLOMCNS.pls 120.1 2006/09/15 19:33:10 plowe noship $ */
3 
4 
5   FUNCTION get_organization(pwhse_code VARCHAR2) RETURN NUMBER;
6   PRAGMA RESTRICT_REFERENCES(get_organization,WNDS);
7 
8   FUNCTION get_uom_code(pprice_uom VARCHAR2) RETURN VARCHAR2;
9   PRAGMA RESTRICT_REFERENCES(get_uom_code,WNDS);
10 
11   FUNCTION get_item(pitem_id NUMBER) RETURN NUMBER;
12   PRAGMA RESTRICT_REFERENCES(get_item,WNDS);
13 
14 
15   --To insert the records from op_cntr_hdr table.
16   PROCEDURE op_cntr_hdr;
17 
18   --To insert the contract detail records from op_cntr_dtl table for the op_cntr_hdr(contract_id).
19   PROCEDURE op_cntr_dtl(plist_header_id NUMBER, pcontract_id NUMBER,
20                         pcurrency_code VARCHAR2,pcontract_no VARCHAR2,pcontract_desc VARCHAR2);
21 
22   --To insert the effectivity detail records from op_prce_eff table for the op_cntr_hdr(contract_id).
23   PROCEDURE op_prce_eff(plist_header_id NUMBER,pcontract_id NUMBER,pcontract_no VARCHAR2,
24                         pdate_created DATE,pdate_modified DATE);
25   --To insert the contract detail records(whse_code,frtbill_mthd,qc_grade)
26   --from op_cntr_dtl table for the op_cntr_hdr.
27   PROCEDURE op_cntr_dtl_details(pqc_grade VARCHAR2,pwhse_code VARCHAR2,pfrtbill_mthd VARCHAR2, pattr_grp_no NUMBER,
28                                 pitem_id NUMBER,pprice_uom VARCHAR2,plist_line_Id NUMBER, plist_header_id NUMBER,
29                                 plist_line_type_code VARCHAR2);
30   --To insert the contract break records from op_cntr_brk table for the op_cntr_dtl(price_id).
31   PROCEDURE op_cntr_brk(plist_header_id NUMBER, pprice_id NUMBER,pprice_type NUMBER,
32                         pbase_price NUMBER,pitem_id NUMBER,pprice_uom VARCHAR2,plist_line_id NUMBER);
33   --To insert the contract break values from op_cntr_brk table.
34   PROCEDURE op_cntr_brk_values(pprice_id NUMBER,pqty_breakpoint NUMBER,plist_line_id NUMBER,plist_header_id NUMBER,
35                                pitem_id NUMBER,pprice_uom VARCHAR2);
36   --To get the contract break records from qp_list_lines_v.
37   PROCEDURE qp_rltd_modifiers(pblist_line_id NUMBER,plist_line_id  NUMBER);
38   --To create agreements for the effectivities in op_prce_eff.
39   PROCEDURE op_oe_agreement(plist_header_id NUMBER,pcontract_no VARCHAR2,pdate_created DATE,
40                             pdate_modified DATE,pcust_no VARCHAR2,pstart_date DATE,
41                             pend_date DATE,psite_use_id NUMBER,ppreference NUMBER,porgn_code VARCHAR2);
42   PROCEDURE op_chrg_mst(pbreak_type NUMBER,pprice_type NUMBER,
43                         pprice_id NUMBER,pbase_price NUMBER,
44                         pprice_uom VARCHAR2,pitem_id NUMBER,pcurrency_code VARCHAR2,
45                         pcontract_no VARCHAR2,pcontract_desc VARCHAR2, olist_header_id NUMBER);
46   PROCEDURE op_chrg_dtl(plist_header_id NUMBER,pbreak_type NUMBER,pprice_type NUMBER,
47                         pprice_id NUMBER,pbase_price NUMBER,pprice_uom VARCHAR2, pitem_id NUMBER);
48   PROCEDURE op_chrg_brk(plist_header_id NUMBER,pprice_type NUMBER,plist_line_id NUMBER,
49                         pbreak_type NUMBER,pitem_id NUMBER,	pprice_id NUMBER,pbase_price NUMBER,pprice_uom VARCHAR2);
50   PROCEDURE op_chrg_brk_values(pvalue_breakpoint NUMBER, plist_line_id NUMBER,
51                                plist_header_id NUMBER, pitem_id NUMBER,pprice_id NUMBER,pprice_uom VARCHAR2);
52   PROCEDURE qp_chrg_rltd_modifiers(pblist_line_id NUMBER,plist_line_id NUMBER);
53   PROCEDURE handle_error_messages(psession_id NUMBER, ppackage_name VARCHAR2,
54                                   pprocedure_name VARCHAR2, pmessage VARCHAR2);
55 END gml_op_cntr_hdr_pkg;