DBA Data[Home] [Help]

APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_REQEXPRESS_LINES_ALL

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

2898: p_default_lang_tlp_id IN PO_ATTRIBUTE_VALUES_TLP.attribute_values_tlp_id%TYPE DEFAULT NULL,
2899: p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,
2900: p_default_lang_tlp_id_list IN PO_TBL_NUMBER DEFAULT NULL,
2901: p_po_line_id_list IN PO_TBL_NUMBER DEFAULT NULL,
2902: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
2903: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,
2904: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
2905: )
2906: IS

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

2899: p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,
2900: p_default_lang_tlp_id_list IN PO_TBL_NUMBER DEFAULT NULL,
2901: p_po_line_id_list IN PO_TBL_NUMBER DEFAULT NULL,
2902: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
2903: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,
2904: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
2905: )
2906: IS
2907: d_mod CONSTANT VARCHAR2(100) := D_create_translations;

Line 3433: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,

3429: PROCEDURE create_default_attr_tlp
3430: (
3431: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
3432: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3433: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3434: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3435: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3436: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3437: p_org_id IN PO_LINES_ALL.org_id%TYPE,

Line 3434: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,

3430: (
3431: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
3432: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3433: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3434: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3435: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3436: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3437: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3438: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,

Line 3599: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,

3595: PROCEDURE create_default_attributes
3596: (
3597: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
3598: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3599: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3600: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3601: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3602: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3603: p_org_id IN PO_LINES_ALL.org_id%TYPE,

Line 3600: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,

3596: (
3597: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
3598: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3599: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3600: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3601: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3602: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3603: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3604: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE

Line 4789: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,

4785: PROCEDURE update_attributes
4786: (
4787: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
4788: p_po_line_id IN PO_LINES.po_line_id%TYPE,
4789: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
4790: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
4791: p_org_id IN PO_LINES_ALL.org_id%TYPE,
4792: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
4793: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,

Line 4790: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,

4786: (
4787: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
4788: p_po_line_id IN PO_LINES.po_line_id%TYPE,
4789: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
4790: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
4791: p_org_id IN PO_LINES_ALL.org_id%TYPE,
4792: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
4793: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
4794: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE

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

6239: PROCEDURE delete_attributes
6240: (
6241: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
6242: p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,
6243: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
6244: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,
6245: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
6246: )
6247: IS

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

6240: (
6241: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
6242: p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,
6243: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
6244: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,
6245: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
6246: )
6247: IS
6248: d_mod CONSTANT VARCHAR2(100) := D_delete_attributes;