[Home] [Help]
PACKAGE BODY: APPS.GML_OP_CNTR_HDR_PKG
Source
1 PACKAGE BODY gml_op_cntr_hdr_pkg AS
2 /* $Header: GMLOMCNB.pls 120.1 2006/09/15 19:33:33 plowe noship $ */
3
4 --This will be called in op_cntr_dtl_details procedure to insert mtl_organization_id based on whse_code
5 --for column pricing attribute value from
6
7 FUNCTION get_organization(pwhse_code VARCHAR2) RETURN NUMBER IS
8 begin
9 null;
10 END get_organization;
11
12 --This procedure will get the uom_code from mtl_units_of_measure_vl.
13
14 FUNCTION get_uom_code(pprice_uom VARCHAR2) RETURN VARCHAR2 IS
15 begin
16 null;
17 END get_uom_code;
18
19 --This procedure will validate the item_id in mtl_system_items table before inserting into the
20 --column product attribute value
21 -- PK Bug 4372804 Replaced IN clause with join and removed distinct
22
23 FUNCTION get_item(pitem_id NUMBER) RETURN NUMBER IS
24 begin
25 null;
26 END get_item;
27
28
29 PROCEDURE op_cntr_hdr IS
30
31 begin
32 null;
33 END op_cntr_hdr;
34
35
36 PROCEDURE op_cntr_dtl(plist_header_id NUMBER, pcontract_id NUMBER,
37 pcurrency_code VARCHAR2,pcontract_no VARCHAR2,pcontract_desc VARCHAR2) IS
38 begin
39 null;
40 END op_cntr_dtl;
41
42 PROCEDURE op_prce_eff(plist_header_id NUMBER,pcontract_id NUMBER,pcontract_no VARCHAR2,
43 pdate_created DATE,pdate_modified DATE) IS
44 begin
45 null;
46 END op_prce_eff;
47
48 PROCEDURE op_cntr_dtl_details(pqc_grade VARCHAR2, pwhse_code VARCHAR2,
49 pfrtbill_mthd VARCHAR2, pattr_grp_no NUMBER, pitem_id NUMBER,
50 pprice_uom VARCHAR2, plist_line_id NUMBER,
51 plist_header_id NUMBER,
52 plist_line_type_code VARCHAR2) IS
53
54 begin
55 null;
56 END op_cntr_dtl_details;
57
58 PROCEDURE op_cntr_brk(plist_header_id NUMBER, pprice_id NUMBER,
59 pprice_type NUMBER,pbase_price NUMBER,
60 pitem_id NUMBER,pprice_uom VARCHAR2,
61 plist_line_id NUMBER) IS
62 begin
63 null;
64 END op_cntr_brk;
65
66 PROCEDURE op_cntr_brk_values (pprice_id NUMBER, pqty_breakpoint NUMBER,
67 plist_line_id NUMBER,plist_header_id NUMBER, pitem_id NUMBER,
68 pprice_uom VARCHAR2) IS
69 begin
70 null;
71 END op_cntr_brk_values;
72
73 PROCEDURE qp_rltd_modifiers(pblist_line_id NUMBER,plist_line_id NUMBER) is
74 begin
75 null;
76 END qp_rltd_modifiers;
77
78 PROCEDURE op_oe_agreement(plist_header_id NUMBER,pcontract_no VARCHAR2,
79 pdate_created DATE,pdate_modified DATE,
80 pcust_no VARCHAR2,pstart_date DATE,
81 pend_date DATE,psite_use_id NUMBER,ppreference NUMBER,porgn_code VARCHAR2) IS
82 begin
83 null;
84 END op_oe_agreement;
85
86 PROCEDURE op_chrg_mst (pbreak_type NUMBER,pprice_type NUMBER,
87 pprice_id NUMBER,pbase_price NUMBER,
88 pprice_uom VARCHAR2,pitem_id NUMBER,pcurrency_code VARCHAR2,
89 pcontract_no VARCHAR2,pcontract_desc VARCHAR2, olist_header_id NUMBER) IS
90 begin
91 null;
92 END op_chrg_mst;
93
94 PROCEDURE op_chrg_dtl (plist_header_id NUMBER,pbreak_type NUMBER,pprice_type NUMBER,
95 pprice_id NUMBER,pbase_price NUMBER,pprice_uom VARCHAR2,
96 pitem_id NUMBER) IS
97 begin
98 null;
99
100 END op_chrg_dtl;
101
102 PROCEDURE op_chrg_brk(plist_header_id NUMBER,pprice_type NUMBER,plist_line_id NUMBER,
103 pbreak_type NUMBER,pitem_id NUMBER,
104 pprice_id NUMBER,pbase_price NUMBER,pprice_uom VARCHAR2) IS
105 begin
106 null;
107 END op_chrg_brk;
108
109 PROCEDURE op_chrg_brk_values(pvalue_breakpoint NUMBER, plist_line_id NUMBER,
110 plist_header_id NUMBER, pitem_id NUMBER,pprice_id NUMBER,pprice_uom VARCHAR2) is
111 begin
112 null;
113 END op_chrg_brk_values;
114
115 PROCEDURE qp_chrg_rltd_modifiers (pblist_line_id NUMBER,plist_line_id NUMBER) IS
116 begin
117 null;
118 END qp_chrg_rltd_modifiers;
119
120 PROCEDURE handle_error_messages(psession_id NUMBER, ppackage_name VARCHAR2, pprocedure_name VARCHAR2, pmessage VARCHAR2) IS
121 PRAGMA AUTONOMOUS_TRANSACTION;
122
123 begin
124 null;
125 END handle_error_messages;
126
127 END gml_op_cntr_hdr_pkg;