DBA Data[Home] [Help]

APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_ATTRIBUTE_VALUES_TLP

Line 23: p_default_lang_tlp_id IN PO_ATTRIBUTE_VALUES_TLP.attribute_values_tlp_id%TYPE DEFAULT NULL,

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,

Line 41: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%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: (

Line 49: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,

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

Line 50: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,

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

Line 51: p_long_description IN PO_ATTRIBUTE_VALUES_TLP.long_description%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:

Line 62: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,

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:

Line 71: p_inventory_item_id IN PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE,

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,

Line 72: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,

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

Line 73: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,

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

Line 74: p_long_description IN PO_ATTRIBUTE_VALUES_TLP.long_description%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:

Line 94: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%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

Line 95: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%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: (

Line 130: p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,

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

Line 139: p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,

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:

Line 149: p_lang IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,

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:

Line 150: p_long_description OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE

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: