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