[Home] [Help]
PACKAGE: APPS.PO_ATTRIBUTE_VALUES_PVT
Source
1 PACKAGE PO_ATTRIBUTE_VALUES_PVT AS
2 /* $Header: PO_ATTRIBUTE_VALUES_PVT.pls 120.12.12010000.3 2008/09/22 18:11:17 rohbansa ship $ */
3
4 g_pkg_name CONSTANT VARCHAR2(30) := 'PO_ATTRIBUTE_VALUES_PVT';
5
6 g_ATTR_VALUES_NULL_ID CONSTANT NUMBER := -2;
7
8 PROCEDURE handle_attributes
9 (
10 p_interface_header_id IN NUMBER
11 , p_po_header_id IN NUMBER DEFAULT NULL
12 , p_language IN VARCHAR2 DEFAULT NULL
13 );
14
15 PROCEDURE transfer_intf_item_attribs
16 (
17 p_interface_header_id IN NUMBER
18 );
19
20 PROCEDURE create_translations
21 (
22 p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
23 p_default_lang_tlp_id IN PO_ATTRIBUTE_VALUES_TLP.attribute_values_tlp_id%TYPE DEFAULT NULL,
24 p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,
25 p_default_lang_tlp_id_list IN PO_TBL_NUMBER DEFAULT NULL,
26 p_po_line_id_list IN PO_TBL_NUMBER DEFAULT NULL,
27 p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
28 p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,
29 p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
30 );
31
32 PROCEDURE create_default_attributes
33 (
34 p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
35 p_po_line_id IN PO_LINES.po_line_id%TYPE,
36 p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
37 p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
38 p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
39 p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
40 p_org_id IN PO_LINES_ALL.org_id%TYPE,
41 p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
42 );
43
44 PROCEDURE create_attributes_tlp_MI
45 (
46 p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
47 p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
48 p_org_id IN PO_LINES_ALL.org_id%TYPE,
49 p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
50 p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
51 p_long_description IN PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE,
52 p_organization_id IN NUMBER,
53 p_master_organization_id IN NUMBER
54 );
55
56
57 PROCEDURE create_default_attributes_MI
58 (
59 p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
60 p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
61 p_org_id IN PO_LINES_ALL.org_id%TYPE,
62 p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
63 p_organization_id IN NUMBER,
64 p_master_organization_id IN NUMBER
65 );
66
67 PROCEDURE update_attributes_MI
68 (
69 p_org_id IN PO_LINES_ALL.org_id%TYPE,
70 p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
71 p_inventory_item_id IN PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE,
72 p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
73 p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
74 p_long_description IN PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE,
75 p_organization_id IN NUMBER,
76 p_master_organization_id IN NUMBER
77 );
78
79
80 PROCEDURE gen_draft_line_translations
81 (
82 p_draft_id IN NUMBER
83 , p_doc_type IN VARCHAR2
84 );
85
86 PROCEDURE update_attributes
87 (
88 p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
89 p_po_line_id IN PO_LINES.po_line_id%TYPE,
90 p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
91 p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
92 p_org_id IN PO_LINES_ALL.org_id%TYPE,
93 p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
94 p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
95 p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
96 );
97
98 PROCEDURE copy_attributes
99 (
100 p_orig_po_line_id IN PO_LINES.po_line_id%TYPE
101 , p_new_po_line_id IN PO_LINES.po_line_id%TYPE
102 );
103
104 PROCEDURE get_ip_category_id
105 (
106 p_po_category_id IN NUMBER
107 , x_ip_category_id OUT NOCOPY NUMBER
108 );
109
110 PROCEDURE delete_attributes
111 (
112 p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
113 p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,
114 p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
115 p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,
116 p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
117 );
118
119 PROCEDURE delete_attributes_for_header
120 (
121 p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION'
122 p_po_header_id IN PO_LINES.po_header_id%TYPE
123 );
124
125 --Bug 7039409: Added new procedure
126 PROCEDURE get_item_attributes_values
127 (
128 p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
129 p_manufacturer_part_num OUT NOCOPY PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE,
130 p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,
131 p_lead_time OUT NOCOPY PO_ATTRIBUTE_VALUES.lead_time%TYPE
132 );
133
134 --Bug 7387487: Added new procedure
135 PROCEDURE get_item_attributes_values
136 (
137 p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
138 p_manufacturer_part_num OUT NOCOPY PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE,
139 p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,
140 p_lead_time OUT NOCOPY PO_ATTRIBUTE_VALUES.lead_time%TYPE,
141 p_manufacturer_id OUT NOCOPY po_requisition_lines_All.MANUFACTURER_ID%TYPE
142 ) ;
143
144
145 --Bug 7039409: Added new procedure
146 PROCEDURE get_item_attributes_tlp_values
147 (
148 p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
149 p_lang IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
150 p_long_description OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE
151 );
152
153
154
155 FUNCTION get_base_lang
156 RETURN VARCHAR2;
157
158 END;