DBA Data[Home] [Help]

APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_LINES_ALL

Line 29: p_org_id IN PO_LINES_ALL.org_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: (

Line 38: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

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: );

Line 39: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

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:

Line 40: p_org_id IN PO_LINES_ALL.org_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

Line 46: p_inventory_item_id IN PO_LINES_ALL.item_id%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,

Line 47: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

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,

Line 48: p_org_id IN PO_LINES_ALL.org_id%TYPE,

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,

Line 59: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

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,

Line 60: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

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

Line 61: p_org_id IN PO_LINES_ALL.org_id%TYPE,

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: );

Line 69: p_org_id IN PO_LINES_ALL.org_id%TYPE,

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,

Line 70: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

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,

Line 92: p_org_id IN PO_LINES_ALL.org_id%TYPE,

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: );

Line 93: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

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:

Line 116: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL

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: (

Line 128: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

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: );

Line 137: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

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

Line 148: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

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: