DBA Data[Home] [Help]

APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_REQEXPRESS_LINES_ALL

Line 27: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,

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:

Line 28: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%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

Line 36: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,

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,

Line 37: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,

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

Line 90: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,

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,

Line 91: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,

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

Line 114: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,

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:

Line 115: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,

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