1: PACKAGE BODY PO_ATTRIBUTE_VALUES_PVT AS
2: /* $Header: PO_ATTRIBUTE_VALUES_PVT.plb 120.44.12020000.3 2013/02/10 16:49:47 vegajula ship $ */
3:
4: -- The module base for this package.
5: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_ATTRIBUTE_VALUES_PVT');
6:
7: -- The module base for the subprogram.
8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
4: -- The module base for this package.
5: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_ATTRIBUTE_VALUES_PVT');
6:
7: -- The module base for the subprogram.
8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
5: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_ATTRIBUTE_VALUES_PVT');
6:
7: -- The module base for the subprogram.
8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
6:
7: -- The module base for the subprogram.
8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
7: -- The module base for the subprogram.
8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
8: D_handle_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'handle_attributes');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
9: D_set_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
10: D_set_attribute_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'set_attribute_values_tlp');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
11: D_transfer_intf_item_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'transfer_intf_item_attribs');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
12: D_get_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_translations');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
13: D_get_tlp_ids_for_lines CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_tlp_ids_for_lines');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
14: D_create_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_translations');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
15: D_create_default_attr_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attr_tlp');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
16: D_create_attributes_tlp_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_attributes_tlp_MI');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
17: D_create_default_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
18: D_create_default_attributes_MI CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'create_default_attributes_MI');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
19: D_gen_draft_line_translations CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'gen_draft_line_translations');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');
20: D_wipeout_category_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'wipeout_category_attributes');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');
28: D_get_item_attributes_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_tlp_values');
21: D_update_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'update_attributes');
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');
28: D_get_item_attributes_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_tlp_values');
29:
22: D_copy_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'copy_attributes');
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');
28: D_get_item_attributes_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_tlp_values');
29:
30: TYPE PO_TBL_VARCHAR4 IS TABLE OF VARCHAR2(4) INDEX BY pls_integer;
23: D_get_ip_category_id CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_ip_category_id');
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');
28: D_get_item_attributes_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_tlp_values');
29:
30: TYPE PO_TBL_VARCHAR4 IS TABLE OF VARCHAR2(4) INDEX BY pls_integer;
31: TYPE PO_TBL_VARCHAR480 IS TABLE OF VARCHAR2(480) INDEX BY pls_integer;
24: D_delete_attributes CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes');
25: D_delete_attributes_for_header CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'delete_attributes_for_header');
26: D_get_base_lang CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_base_lang');
27: D_get_item_attributes_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_values');
28: D_get_item_attributes_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_item_attributes_tlp_values');
29:
30: TYPE PO_TBL_VARCHAR4 IS TABLE OF VARCHAR2(4) INDEX BY pls_integer;
31: TYPE PO_TBL_VARCHAR480 IS TABLE OF VARCHAR2(480) INDEX BY pls_integer;
32:
245:
246: BEGIN
247: l_progress := '010';
248:
249: IF PO_LOG.d_proc THEN
250: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
251: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
252: PO_LOG.proc_begin(d_mod,'p_language',p_language);
253: END IF;
246: BEGIN
247: l_progress := '010';
248:
249: IF PO_LOG.d_proc THEN
250: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
251: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
252: PO_LOG.proc_begin(d_mod,'p_language',p_language);
253: END IF;
254:
247: l_progress := '010';
248:
249: IF PO_LOG.d_proc THEN
250: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
251: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
252: PO_LOG.proc_begin(d_mod,'p_language',p_language);
253: END IF;
254:
255: -- If language is not passed in assume language of user session
248:
249: IF PO_LOG.d_proc THEN
250: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
251: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
252: PO_LOG.proc_begin(d_mod,'p_language',p_language);
253: END IF;
254:
255: -- If language is not passed in assume language of user session
256: IF (p_language IS NULL) THEN
266: FETCH descriptors_csr
267: BULK COLLECT INTO l_base_descriptors;
268: ClOSE descriptors_csr;
269:
270: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_base_descriptors.COUNT='||l_base_descriptors.COUNT); END IF;
271:
272: l_progress := '030';
273: -- fetch all translatable base descriptors information
274: -- base descriptors have rt_category_id as 0. Hence pass in 0
276: FETCH descriptors_tlp_csr
277: BULK COLLECT INTO l_base_descriptors_tlp;
278: ClOSE descriptors_tlp_csr;
279:
280: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_base_descriptors_tlp.COUNT='||l_base_descriptors_tlp.COUNT); END IF;
281:
282: l_progress := '040';
283: -- if a specific PO header id is not passed in then
284: -- Sourcing is in the req to negotiation flow
296: BULK COLLECT INTO l_attr_values;
297: CLOSE attr_values_csr;
298: END IF;
299:
300: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_attr_values.COUNT='||l_attr_values.COUNT); END IF;
301:
302: l_progress := '070';
303: --for each attribute value record for this header loop through
304: --and fetch base and category descriptor name, value and other
330: FETCH descriptors_csr
331: BULK COLLECT INTO l_cat_descriptors;
332: ClOSE descriptors_csr;
333:
334: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_cat_descriptors.COUNT='||l_cat_descriptors.COUNT); END IF;
335:
336: l_progress := '130';
337: FOR j IN 1..l_cat_descriptors.COUNT --category descriptors
338: LOOP
348: END LOOP; --category descriptors
349: END IF; --for each ip_category
350: END LOOP; --attribute values
351:
352: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'After set_attribute_values in loop'); END IF;
353:
354: l_progress := '160';
355: -- if a specific PO header id is not passed in then
356: -- Sourcing is in the req to negotiation flow
368: BULK COLLECT INTO l_attr_values_tlp;
369: CLOSE attr_values_tlp_csr;
370: END IF;
371:
372: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_attr_values_tlp.COUNT='||l_attr_values_tlp.COUNT); END IF;
373:
374: l_progress := '190';
375: --for each attribute value tlp record for this header loop through
376: --and fetch base and category descriptor name, tlp value and other
401: FETCH descriptors_tlp_csr
402: BULK COLLECT INTO l_cat_descriptors_tlp;
403: ClOSE descriptors_tlp_csr;
404:
405: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'l_cat_descriptors_tlp.COUNT='||l_cat_descriptors_tlp.COUNT); END IF;
406:
407: l_progress := '250';
408: FOR j IN 1..l_cat_descriptors_tlp.COUNT --category descriptors tlp
409: LOOP
418: END LOOP; --category descriptors tlp
419: END IF; --for each ip_category
420: END LOOP; --attribute values tlp
421:
422: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'After set_attribute_values_tlp in loop'); END IF;
423:
424: l_progress := '280';
425: --insert data into pon_attributes_interface
426: FORALL i IN 1..l_pon_attributes.COUNT
425: --insert data into pon_attributes_interface
426: FORALL i IN 1..l_pon_attributes.COUNT
427: INSERT INTO PON_ATTRIBUTES_INTERFACE VALUES l_pon_attributes(i);
428:
429: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PON_ATTRIBUTES_INTERFACE='||SQL%rowcount); END IF;
430:
431: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
432: EXCEPTION
433: WHEN OTHERS THEN
427: INSERT INTO PON_ATTRIBUTES_INTERFACE VALUES l_pon_attributes(i);
428:
429: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PON_ATTRIBUTES_INTERFACE='||SQL%rowcount); END IF;
430:
431: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
432: EXCEPTION
433: WHEN OTHERS THEN
434: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
435: RAISE;
430:
431: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
432: EXCEPTION
433: WHEN OTHERS THEN
434: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
435: RAISE;
436: END handle_attributes;
437:
438: --------------------------------------------------------------------------------
471: l_progress VARCHAR2(4);
472: BEGIN
473: l_progress := '010';
474:
475: IF PO_LOG.d_proc THEN
476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
472: BEGIN
473: l_progress := '010';
474:
475: IF PO_LOG.d_proc THEN
476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
473: l_progress := '010';
474:
475: IF PO_LOG.d_proc THEN
476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);
474:
475: IF PO_LOG.d_proc THEN
476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);
482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);
475: IF PO_LOG.d_proc THEN
476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);
482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);
483: END IF;
476: PO_LOG.proc_begin(d_mod,'x_attr_values.interface_line_number',x_attr_values.interface_line_number);
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);
482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);
483: END IF;
484:
477: PO_LOG.proc_begin(d_mod,'x_descriptors.sequence',x_descriptors.sequence);
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);
482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);
483: END IF;
484:
485: --move data from descriptors and attribute values into x_pon_attributes
478: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_name',x_descriptors.attribute_name);
479: PO_LOG.proc_begin(d_mod,'x_descriptors.rt_category_id',x_descriptors.rt_category_id);
480: PO_LOG.proc_begin(d_mod,'x_descriptors.attribute_id',x_descriptors.attribute_id);
481: PO_LOG.proc_begin(d_mod,'x_descriptors.type',x_descriptors.type);
482: PO_LOG.proc_begin(d_mod,'x_descriptors.stored_in_column',x_descriptors.stored_in_column);
483: END IF;
484:
485: --move data from descriptors and attribute values into x_pon_attributes
486: x_pon_attributes.interface_line_number := x_attr_values.interface_line_number;
498: ELSIF (x_descriptors.type = 1) THEN
499: x_pon_attributes.datatype := 'NUM';
500: END IF;
501:
502: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.datatype='||x_pon_attributes.datatype); END IF;
503:
504: l_progress := '030';
505: IF (x_descriptors.stored_in_column = 'ATTACHMENT_URL') THEN
506: x_pon_attributes.value := x_attr_values.ATTACHMENT_URL;
1153: ELSIF (x_descriptors.stored_in_column = 'UNSPSC') THEN
1154: x_pon_attributes.value := x_attr_values.UNSPSC;
1155: END IF;
1156:
1157: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.value='||x_pon_attributes.value); END IF;
1158:
1159: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1160: EXCEPTION
1161: WHEN OTHERS THEN
1155: END IF;
1156:
1157: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.value='||x_pon_attributes.value); END IF;
1158:
1159: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
1163: RAISE;
1158:
1159: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
1163: RAISE;
1164: END set_attribute_values;
1165:
1166: --------------------------------------------------------------------------------
1199: l_progress VARCHAR2(4);
1200: BEGIN
1201: l_progress := '010';
1202:
1203: IF PO_LOG.d_proc THEN
1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1200: BEGIN
1201: l_progress := '010';
1202:
1203: IF PO_LOG.d_proc THEN
1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1201: l_progress := '010';
1202:
1203: IF PO_LOG.d_proc THEN
1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);
1202:
1203: IF PO_LOG.d_proc THEN
1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);
1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);
1203: IF PO_LOG.d_proc THEN
1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);
1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);
1211: END IF;
1204: PO_LOG.proc_begin(d_mod,'x_attr_values_tlp.interface_line_number',x_attr_values_tlp.interface_line_number);
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);
1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);
1211: END IF;
1212:
1205: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.sequence',x_descriptors_tlp.sequence);
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);
1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);
1211: END IF;
1212:
1213: --move data from descriptors and attribute values into x_pon_attributes
1206: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_name',x_descriptors_tlp.attribute_name);
1207: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.rt_category_id',x_descriptors_tlp.rt_category_id);
1208: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.attribute_id',x_descriptors_tlp.attribute_id);
1209: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.type',x_descriptors_tlp.type);
1210: PO_LOG.proc_begin(d_mod,'x_descriptors_tlp.stored_in_column',x_descriptors_tlp.stored_in_column);
1211: END IF;
1212:
1213: --move data from descriptors and attribute values into x_pon_attributes
1214: x_pon_attributes.interface_line_number := x_attr_values_tlp.interface_line_number;
1225: ELSIF (x_descriptors_tlp.type = 1) THEN
1226: x_pon_attributes.datatype := 'NUM';
1227: END IF;
1228:
1229: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.datatype='||x_pon_attributes.datatype); END IF;
1230:
1231: l_progress := '030';
1232: IF (x_descriptors_tlp.stored_in_column = 'ALIAS') THEN
1233: x_pon_attributes.value := x_attr_values_tlp.ALIAS;
1574: ELSIF (x_descriptors_tlp.stored_in_column = 'TL_TEXT_CAT_ATTRIBUTE9') THEN
1575: x_pon_attributes.value := x_attr_values_tlp.TL_TEXT_CAT_ATTRIBUTE9;
1576: END IF;
1577:
1578: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.value='||x_pon_attributes.value); END IF;
1579:
1580: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1576: END IF;
1577:
1578: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_pon_attributes.value='||x_pon_attributes.value); END IF;
1579:
1580: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
1584: RAISE;
1579:
1580: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
1584: RAISE;
1585: END set_attribute_values_tlp;
1586:
1587: --------------------------------------------------------------------------------
1615: l_progress VARCHAR2(4);
1616: BEGIN
1617: l_progress := '010';
1618:
1619: IF PO_LOG.d_proc THEN
1620: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
1621: END IF;
1622:
1623: l_progress := '020';
1616: BEGIN
1617: l_progress := '010';
1618:
1619: IF PO_LOG.d_proc THEN
1620: PO_LOG.proc_begin(d_mod,'p_interface_header_id',p_interface_header_id);
1621: END IF;
1622:
1623: l_progress := '020';
1624: INSERT INTO PO_ATTRIBUTE_VALUES (
2277: 'AUTOCREATE_BACKEND_FOR_SOURCING'
2278: FROM PO_ATTR_VALUES_INTERFACE
2279: WHERE interface_header_id = p_interface_header_id;
2280:
2281: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PO_ATTRIBUTE_VALUES table='||SQL%rowcount); END IF;
2282:
2283: l_progress := '030';
2284: --insert tlp records from interface table
2285: INSERT INTO PO_ATTRIBUTE_VALUES_TLP (
2632: 'AUTOCREATE_BACKEND_FOR_SOURCING'
2633: FROM PO_ATTR_VALUES_TLP_INTERFACE
2634: WHERE interface_header_id = p_interface_header_id;
2635:
2636: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PO_ATTRIBUTE_VALUES_TLP table='||SQL%rowcount); END IF;
2637:
2638: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2639: EXCEPTION
2640: WHEN OTHERS THEN
2634: WHERE interface_header_id = p_interface_header_id;
2635:
2636: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in PO_ATTRIBUTE_VALUES_TLP table='||SQL%rowcount); END IF;
2637:
2638: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2639: EXCEPTION
2640: WHEN OTHERS THEN
2641: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
2642: RAISE;
2637:
2638: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2639: EXCEPTION
2640: WHEN OTHERS THEN
2641: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception:'||SQLCODE || SQLERRM); END IF;
2642: RAISE;
2643: END transfer_intf_item_attribs;
2644:
2645: --------------------------------------------------------------------------------
2688: l_onetime_item_all_languages FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
2689: BEGIN
2690: l_progress := '010';
2691:
2692: IF PO_LOG.d_proc THEN
2693: PO_LOG.proc_begin(d_mod,'p_attr_values_tlp_id_list',p_attr_values_tlp_id_list);
2694: END IF;
2695:
2696: -- Get the profile value for "POR: Load One-Time Items in All Languages"
2689: BEGIN
2690: l_progress := '010';
2691:
2692: IF PO_LOG.d_proc THEN
2693: PO_LOG.proc_begin(d_mod,'p_attr_values_tlp_id_list',p_attr_values_tlp_id_list);
2694: END IF;
2695:
2696: -- Get the profile value for "POR: Load One-Time Items in All Languages"
2697: l_onetime_item_all_languages := NVL(FND_PROFILE.value('POR_LOAD_ONETIME_ITEM_ALL_LANG'), 'N');
2694: END IF;
2695:
2696: -- Get the profile value for "POR: Load One-Time Items in All Languages"
2697: l_onetime_item_all_languages := NVL(FND_PROFILE.value('POR_LOAD_ONETIME_ITEM_ALL_LANG'), 'N');
2698: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Profile POR_LOAD_ONETIME_ITEM_ALL_LANG='||l_onetime_item_all_languages); END IF;
2699:
2700: -- SQL What: Pick a new key from session GT sequence .
2701: -- SQL Why : To get tlp_id's
2702: -- SQL Join: none
2763: x_tlp_new_descriptions_list,
2764: x_tlp_language_list,
2765: x_tlp_long_descriptions_list; -- Bug7039409: Get tlp_long_description
2766:
2767: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows deleted from GT table='||SQL%rowcount); END IF;
2768:
2769: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2770: EXCEPTION
2771: WHEN OTHERS THEN
2765: x_tlp_long_descriptions_list; -- Bug7039409: Get tlp_long_description
2766:
2767: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows deleted from GT table='||SQL%rowcount); END IF;
2768:
2769: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2770: EXCEPTION
2771: WHEN OTHERS THEN
2772: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
2773: RAISE;
2768:
2769: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2770: EXCEPTION
2771: WHEN OTHERS THEN
2772: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
2773: RAISE;
2774: END get_translations;
2775:
2776: --------------------------------------------------------------------------------
2809: l_key PO_SESSION_GT.key%TYPE;
2810: BEGIN
2811: l_progress := '010';
2812:
2813: IF PO_LOG.d_proc THEN
2814: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2815: END IF;
2816:
2817: -- SQL What: Pick a new key from session GT sequence .
2810: BEGIN
2811: l_progress := '010';
2812:
2813: IF PO_LOG.d_proc THEN
2814: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2815: END IF;
2816:
2817: -- SQL What: Pick a new key from session GT sequence .
2818: -- SQL Why : To get tlp_id's
2848: WHERE key = l_key
2849: RETURNING num1
2850: BULK COLLECT INTO x_tlp_id_list; -- OUT parameter
2851:
2852: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows deleted from GT table='||SQL%rowcount); END IF;
2853:
2854: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2855: EXCEPTION
2856: WHEN OTHERS THEN
2850: BULK COLLECT INTO x_tlp_id_list; -- OUT parameter
2851:
2852: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows deleted from GT table='||SQL%rowcount); END IF;
2853:
2854: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2855: EXCEPTION
2856: WHEN OTHERS THEN
2857: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
2858: RAISE;
2853:
2854: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
2855: EXCEPTION
2856: WHEN OTHERS THEN
2857: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
2858: RAISE;
2859: END get_tlp_ids_for_lines;
2860:
2861: --------------------------------------------------------------------------------
2918: l_default_lang_tlp_id_list PO_TBL_NUMBER := PO_TBL_NUMBER();
2919: BEGIN
2920: l_progress := '010';
2921:
2922: IF PO_LOG.d_proc THEN
2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2919: BEGIN
2920: l_progress := '010';
2921:
2922: IF PO_LOG.d_proc THEN
2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2920: l_progress := '010';
2921:
2922: IF PO_LOG.d_proc THEN
2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2921:
2922: IF PO_LOG.d_proc THEN
2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
2922: IF PO_LOG.d_proc THEN
2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
2930: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
2923: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
2930: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
2931: END IF;
2924: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id',p_default_lang_tlp_id);
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
2930: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
2931: END IF;
2932:
2925: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
2930: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
2931: END IF;
2932:
2933: -- Wrap single po_line_id into the list collection
2926: PO_LOG.proc_begin(d_mod,'p_default_lang_tlp_id_list',p_default_lang_tlp_id_list);
2927: PO_LOG.proc_begin(d_mod,'p_po_line_id_list',p_po_line_id_list);
2928: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
2929: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
2930: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
2931: END IF;
2932:
2933: -- Wrap single po_line_id into the list collection
2934: IF (p_po_line_id IS NOT NULL) THEN
2967: -- transfer program). In those cases, query up the record here
2968: IF (l_default_lang_tlp_id_list IS NULL OR
2969: (l_default_lang_tlp_id_list.COUNT = 0)) THEN
2970:
2971: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Getting TLP IDs from the document(s)...'); END IF;
2972:
2973: IF (p_doc_type IN ('BLANKET', 'QUOTATION') ) THEN
2974: l_progress := '040';
2975: get_tlp_ids_for_lines
2990: AND org_id = p_org_id
2991: AND p_req_template_line_num <> g_NOT_REQUIRED_ID
2992: AND language = g_base_language;
2993:
2994: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP IDs fetched for ReqTemplate='||l_attr_values_tlp_id_list.COUNT); END IF;
2995: END IF;
2996: ELSE -- l_default_lang_tlp_id_list IS NOT NULL
2997: l_progress := '060';
2998: -- Copy the list into a local array
3390: AND TLP2.org_id = TLP1.org_id
3391: AND TLP2.language = l_tlp_language_list(i));
3392:
3393: l_progress := '090';
3394: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted into TLP table='||SQL%rowcount); END IF;
3395:
3396: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3397: EXCEPTION
3398: WHEN OTHERS THEN
3392:
3393: l_progress := '090';
3394: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted into TLP table='||SQL%rowcount); END IF;
3395:
3396: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3397: EXCEPTION
3398: WHEN OTHERS THEN
3399: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3400: RAISE;
3395:
3396: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3397: EXCEPTION
3398: WHEN OTHERS THEN
3399: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3400: RAISE;
3401: END create_translations;
3402:
3403: --------------------------------------------------------------------------------
3448: l_long_description PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE;
3449: BEGIN
3450: l_progress := '010';
3451:
3452: IF PO_LOG.d_proc THEN
3453: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3454: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3456: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3449: BEGIN
3450: l_progress := '010';
3451:
3452: IF PO_LOG.d_proc THEN
3453: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3454: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3456: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3457: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3450: l_progress := '010';
3451:
3452: IF PO_LOG.d_proc THEN
3453: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3454: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3456: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3457: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3458: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3451:
3452: IF PO_LOG.d_proc THEN
3453: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3454: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3456: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3457: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3458: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3459: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3452: IF PO_LOG.d_proc THEN
3453: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3454: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3456: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3457: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3458: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3459: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3460: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3453: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3454: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3456: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3457: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3458: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3459: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3460: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3461: PO_LOG.proc_begin(d_mod,'p_manufacturer',p_manufacturer);
3454: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3455: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3456: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3457: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3458: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3459: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3460: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3461: PO_LOG.proc_begin(d_mod,'p_manufacturer',p_manufacturer);
3462: END IF;
3455: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3456: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3457: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3458: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3459: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3460: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3461: PO_LOG.proc_begin(d_mod,'p_manufacturer',p_manufacturer);
3462: END IF;
3463:
3456: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3457: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3458: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3459: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3460: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3461: PO_LOG.proc_begin(d_mod,'p_manufacturer',p_manufacturer);
3462: END IF;
3463:
3464: IF (p_po_line_id IS NOT NULL) THEN
3457: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3458: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3459: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3460: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3461: PO_LOG.proc_begin(d_mod,'p_manufacturer',p_manufacturer);
3462: END IF;
3463:
3464: IF (p_po_line_id IS NOT NULL) THEN
3465: l_progress := '020';
3549: AND TLP2.org_id = p_org_id
3550: AND TLP2.language = l_default_lang);
3551:
3552: l_progress := '060';
3553: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in TLP table='||SQL%rowcount); END IF;
3554:
3555: create_translations
3556: (
3557: p_doc_type => p_doc_type,
3560: p_req_template_line_num => p_req_template_line_num,
3561: p_org_id => p_org_id
3562: );
3563:
3564: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3565: EXCEPTION
3566: WHEN OTHERS THEN
3567: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3568: RAISE;
3563:
3564: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3565: EXCEPTION
3566: WHEN OTHERS THEN
3567: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3568: RAISE;
3569: END create_default_attr_tlp;
3570:
3571: --------------------------------------------------------------------------------
3614: l_lead_time PO_ATTRIBUTE_VALUES.lead_time%TYPE;
3615: BEGIN
3616: l_progress := '010';
3617:
3618: IF PO_LOG.d_proc THEN
3619: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3620: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3622: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3615: BEGIN
3616: l_progress := '010';
3617:
3618: IF PO_LOG.d_proc THEN
3619: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3620: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3622: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3623: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3616: l_progress := '010';
3617:
3618: IF PO_LOG.d_proc THEN
3619: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3620: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3622: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3623: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3624: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3617:
3618: IF PO_LOG.d_proc THEN
3619: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3620: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3622: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3623: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3624: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3625: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3618: IF PO_LOG.d_proc THEN
3619: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3620: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3622: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3623: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3624: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3625: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3626: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3619: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3620: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3622: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3623: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3624: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3625: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3626: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3627: END IF;
3620: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
3621: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3622: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3623: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3624: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3625: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3626: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3627: END IF;
3628:
3621: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
3622: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3623: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3624: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3625: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3626: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3627: END IF;
3628:
3629: l_progress := '020';
3622: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
3623: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3624: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3625: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3626: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3627: END IF;
3628:
3629: l_progress := '020';
3630: IF (p_po_line_id IS NOT NULL) THEN
3644: END IF;
3645:
3646: -- Do not create Attr/TLP if the doc type is not BLANKET or QUOTATION
3647: IF (l_type_lookup_code NOT IN ('BLANKET', 'QUOTATION')) THEN
3648: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Returning without creating Attr/TLP. Doc type='||l_type_lookup_code); END IF;
3649: RETURN;
3650: END IF;
3651: END IF;
3652:
3715: AND POATR.req_template_line_num = p_req_template_line_num
3716: AND POATR.org_id = p_org_id);
3717:
3718: l_progress := '050';
3719: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in ATR table='||SQL%rowcount); END IF;
3720:
3721: create_default_attr_tlp
3722: (
3723: p_doc_type => p_doc_type,
3730: p_description => p_description,
3731: p_manufacturer => l_manufacturer -- Bug7039409: Added new param
3732: );
3733:
3734: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3735: EXCEPTION
3736: WHEN OTHERS THEN
3737: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3738: RAISE;
3733:
3734: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3735: EXCEPTION
3736: WHEN OTHERS THEN
3737: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3738: RAISE;
3739: END create_default_attributes;
3740:
3741: PROCEDURE create_default_attributes_MI
3755: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3756: BEGIN
3757: l_progress := '010';
3758:
3759: IF PO_LOG.d_proc THEN
3760: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3761: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3762: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3763: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3756: BEGIN
3757: l_progress := '010';
3758:
3759: IF PO_LOG.d_proc THEN
3760: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3761: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3762: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3763: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3764: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
3757: l_progress := '010';
3758:
3759: IF PO_LOG.d_proc THEN
3760: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3761: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3762: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3763: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3764: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
3765: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
3758:
3759: IF PO_LOG.d_proc THEN
3760: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3761: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3762: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3763: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3764: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
3765: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
3766: END IF;
3759: IF PO_LOG.d_proc THEN
3760: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3761: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3762: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3763: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3764: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
3765: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
3766: END IF;
3767:
3760: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3761: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3762: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3763: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3764: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
3765: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
3766: END IF;
3767:
3768: l_progress := '020';
3761: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3762: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3763: PO_LOG.proc_begin(d_mod,'p_description',p_description);
3764: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
3765: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
3766: END IF;
3767:
3768: l_progress := '020';
3769:
3796: AND ORGANIZATION_ID = p_organization_id;
3797:
3798:
3799:
3800: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,' MANUFACTURER_PART_NUM='||l_manufacturer_part_num||' Lead_Time ='||l_proc_lead_time); END IF;
3801:
3802:
3803: l_progress := '030';
3804: -- SQL What: Insert a new row for Attribute values
3857: AND POATR.req_template_name = '-2'
3858: AND POATR.req_template_line_num = -2);
3859:
3860: l_progress := '040';
3861: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in ATR table='||SQL%rowcount); END IF;
3862:
3863: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3864: EXCEPTION
3865: WHEN OTHERS THEN
3859:
3860: l_progress := '040';
3861: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in ATR table='||SQL%rowcount); END IF;
3862:
3863: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3864: EXCEPTION
3865: WHEN OTHERS THEN
3866: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3867: RAISE;
3862:
3863: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
3864: EXCEPTION
3865: WHEN OTHERS THEN
3866: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
3867: RAISE;
3868: END create_default_attributes_MI;
3869:
3870: -- this is for master items
3883:
3884: BEGIN
3885: l_progress := '010';
3886:
3887: IF PO_LOG.d_proc THEN
3888: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3889: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3890: PO_LOG.proc_begin(d_mod,'p_language',p_language);
3891: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3884: BEGIN
3885: l_progress := '010';
3886:
3887: IF PO_LOG.d_proc THEN
3888: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3889: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3890: PO_LOG.proc_begin(d_mod,'p_language',p_language);
3891: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3892: END IF;
3885: l_progress := '010';
3886:
3887: IF PO_LOG.d_proc THEN
3888: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3889: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3890: PO_LOG.proc_begin(d_mod,'p_language',p_language);
3891: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3892: END IF;
3893:
3886:
3887: IF PO_LOG.d_proc THEN
3888: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3889: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3890: PO_LOG.proc_begin(d_mod,'p_language',p_language);
3891: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3892: END IF;
3893:
3894: l_progress := '020';
3887: IF PO_LOG.d_proc THEN
3888: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
3889: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
3890: PO_LOG.proc_begin(d_mod,'p_language',p_language);
3891: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
3892: END IF;
3893:
3894: l_progress := '020';
3895: -- SQL What: Wipeout category based attributes from AttributeValues table
4013: AND req_template_line_num = -2
4014: AND inventory_item_id = p_inventory_item_id
4015: AND org_id = p_org_id;
4016:
4017: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows wiped out='||SQL%rowcount); END IF;
4018:
4019: l_progress := '030';
4020: -- SQL What: Wipeout category based attributes from TLP table for all Langs
4021: -- SQL Why : Because the category was changed
4089: AND inventory_item_id = p_inventory_item_id
4090: AND org_id = p_org_id;
4091:
4092:
4093: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows wiped out='||SQL%rowcount); END IF;
4094:
4095: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4096: EXCEPTION
4097: WHEN OTHERS THEN
4091:
4092:
4093: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows wiped out='||SQL%rowcount); END IF;
4094:
4095: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4096: EXCEPTION
4097: WHEN OTHERS THEN
4098: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4099: RAISE;
4094:
4095: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4096: EXCEPTION
4097: WHEN OTHERS THEN
4098: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4099: RAISE;
4100: END wipeout_category_attributes_MI;
4101:
4102: -- update attributes for master items
4130: BEGIN
4131: l_progress := '010';
4132:
4133:
4134: IF PO_LOG.d_proc THEN
4135: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4136: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4137: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4138: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4131: l_progress := '010';
4132:
4133:
4134: IF PO_LOG.d_proc THEN
4135: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4136: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4137: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4138: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4139: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4132:
4133:
4134: IF PO_LOG.d_proc THEN
4135: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4136: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4137: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4138: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4139: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4140: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4133:
4134: IF PO_LOG.d_proc THEN
4135: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4136: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4137: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4138: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4139: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4140: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4141: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
4134: IF PO_LOG.d_proc THEN
4135: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4136: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4137: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4138: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4139: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4140: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4141: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
4142: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
4135: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
4136: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4137: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4138: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4139: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4140: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4141: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
4142: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
4143: END IF;
4136: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4137: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4138: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4139: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4140: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4141: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
4142: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
4143: END IF;
4144:
4137: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4138: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4139: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4140: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4141: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
4142: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
4143: END IF;
4144:
4145: l_progress := '020';
4138: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4139: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4140: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
4141: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
4142: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
4143: END IF;
4144:
4145: l_progress := '020';
4146: -- SQL What: Check if ip_category_id has changed
4161:
4162: EXCEPTION
4163: WHEN No_Data_Found THEN
4164: l_progress := '021';
4165: IF PO_LOG.d_stmt THEN
4166: PO_LOG.stmt(d_mod,l_progress,'EXCEPTION calling create attributes p_inventory_item_id='||p_inventory_item_id||' p_org_id= '||p_org_id);
4167: END IF;
4168: create_default_attributes_MI
4169: (
4162: EXCEPTION
4163: WHEN No_Data_Found THEN
4164: l_progress := '021';
4165: IF PO_LOG.d_stmt THEN
4166: PO_LOG.stmt(d_mod,l_progress,'EXCEPTION calling create attributes p_inventory_item_id='||p_inventory_item_id||' p_org_id= '||p_org_id);
4167: END IF;
4168: create_default_attributes_MI
4169: (
4170: p_ip_category_id => p_ip_category_id,
4212:
4213:
4214:
4215:
4216: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,' MANUFACTURER_PART_NUM='||l_manufacturer_part_num||' LEAD_TIME= '||l_proc_lead_time); END IF;
4217: l_progress := '070';
4218:
4219:
4220:
4219:
4220:
4221: IF (p_ip_category_id <> l_orig_ip_category_id) THEN
4222: l_progress := '060';
4223: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IPF_CATEGORY_ID has changed: p_ip_category_id='||p_ip_category_id||', l_orig_ip_category_id='||l_orig_ip_category_id); END IF;
4224:
4225: wipeout_category_attributes_MI
4226: (
4227: p_org_id => p_org_id,
4231: p_item_description => p_item_description
4232: );
4233:
4234: ELSE
4235: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IP_CATEGORY_ID has not changed.'); END IF;
4236: END IF;
4237:
4238: l_progress := '070';
4239:
4261: AND inventory_item_id = p_inventory_item_id
4262: AND org_id = p_org_id;
4263:
4264:
4265: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows updated='||SQL%rowcount); END IF;
4266:
4267:
4268:
4269: l_progress := '085';
4295: l_rec_tlp_for_lang:='';
4296: END;
4297:
4298: IF (l_rec_tlp_for_lang IS NULL OR l_rec_tlp_for_lang = '' ) THEN
4299: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'no records hence insert into PO_ATTRIBUTE_VALUES_TLP ' ); END IF;
4300: l_progress := '090';
4301:
4302: INSERT INTO PO_ATTRIBUTE_VALUES_TLP TLP
4303: (
4347: d_mod -- last_updated_program
4348: FROM dual;
4349:
4350: ELSE
4351: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,' records present hence update PO_ATTRIBUTE_VALUES_TLP ' || l_rec_tlp_for_lang); END IF;
4352: l_progress := '095';
4353: SELECT description,Nvl(LONG_DESCRIPTION,''),Nvl(MANUFACTURER,'')
4354: INTO l_orig_item_description,l_orig_long_desc,l_orig_manufacturer
4355: FROM PO_ATTRIBUTE_VALUES_TLP
4397: AND inventory_item_id = p_inventory_item_id
4398: AND org_id = p_org_id
4399: AND language = p_language;
4400:
4401: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows updated='||SQL%rowcount); END IF;
4402: END IF;
4403:
4404: END IF;
4405:
4405:
4406:
4407: l_progress := '100';
4408:
4409: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4410: EXCEPTION
4411: WHEN OTHERS THEN
4412: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4413: RAISE;
4408:
4409: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4410: EXCEPTION
4411: WHEN OTHERS THEN
4412: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4413: RAISE;
4414: END update_attributes_MI;
4415:
4416:
4460: l_tlp_id_list PO_TBL_NUMBER;
4461: BEGIN
4462: l_progress := '010';
4463:
4464: IF PO_LOG.d_proc THEN
4465: PO_LOG.proc_begin(d_mod,'p_draft_id',p_draft_id);
4466: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
4467: END IF;
4468:
4461: BEGIN
4462: l_progress := '010';
4463:
4464: IF PO_LOG.d_proc THEN
4465: PO_LOG.proc_begin(d_mod,'p_draft_id',p_draft_id);
4466: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
4467: END IF;
4468:
4469: IF (p_doc_type IN ('BLANKET', 'QUOTATION')) THEN
4462: l_progress := '010';
4463:
4464: IF PO_LOG.d_proc THEN
4465: PO_LOG.proc_begin(d_mod,'p_draft_id',p_draft_id);
4466: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
4467: END IF;
4468:
4469: IF (p_doc_type IN ('BLANKET', 'QUOTATION')) THEN
4470:
4492: p_default_lang_tlp_id_list => l_tlp_id_list,
4493: p_po_line_id_list => l_po_line_id_list
4494: );
4495: ELSE
4496: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc type='||p_doc_type||'. No translations created.'); END IF;
4497: END IF; -- IF (p_doc_type IN ('BLANKET', 'QUOTATION'))
4498:
4499: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4500: EXCEPTION
4495: ELSE
4496: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc type='||p_doc_type||'. No translations created.'); END IF;
4497: END IF; -- IF (p_doc_type IN ('BLANKET', 'QUOTATION'))
4498:
4499: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4500: EXCEPTION
4501: WHEN OTHERS THEN
4502: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4503: RAISE;
4498:
4499: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4500: EXCEPTION
4501: WHEN OTHERS THEN
4502: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4503: RAISE;
4504: END gen_draft_line_translations;
4505:
4506: --------------------------------------------------------------------------------
4542:
4543: BEGIN
4544: l_progress := '010';
4545:
4546: IF PO_LOG.d_proc THEN
4547: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4548: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4549: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4550: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4543: BEGIN
4544: l_progress := '010';
4545:
4546: IF PO_LOG.d_proc THEN
4547: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4548: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4549: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4550: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4551: END IF;
4544: l_progress := '010';
4545:
4546: IF PO_LOG.d_proc THEN
4547: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4548: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4549: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4550: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4551: END IF;
4552:
4545:
4546: IF PO_LOG.d_proc THEN
4547: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4548: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4549: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4550: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4551: END IF;
4552:
4553: l_progress := '020';
4546: IF PO_LOG.d_proc THEN
4547: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4548: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4549: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4550: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4551: END IF;
4552:
4553: l_progress := '020';
4554: -- SQL What: Wipeout category based attributes from AttributeValues table
4671: AND req_template_name = NVL(p_req_template_name, '-2')
4672: AND req_template_line_num = NVL(p_req_template_line_num, -2)
4673: AND org_id = p_org_id;
4674:
4675: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows wiped out='||SQL%rowcount); END IF;
4676:
4677: l_progress := '030';
4678: -- SQL What: Wipeout category based attributes from TLP table for all Langs
4679: -- SQL Why : Because the category was changed
4745: AND req_template_name = NVL(p_req_template_name, '-2')
4746: AND req_template_line_num = NVL(p_req_template_line_num, -2)
4747: AND org_id = p_org_id;
4748:
4749: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows wiped out='||SQL%rowcount); END IF;
4750:
4751: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4752: EXCEPTION
4753: WHEN OTHERS THEN
4747: AND org_id = p_org_id;
4748:
4749: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows wiped out='||SQL%rowcount); END IF;
4750:
4751: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4752: EXCEPTION
4753: WHEN OTHERS THEN
4754: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4755: RAISE;
4750:
4751: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4752: EXCEPTION
4753: WHEN OTHERS THEN
4754: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4755: RAISE;
4756: END wipeout_category_attributes;
4757:
4758:
4807: l_inventory_item_id PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE;
4808: BEGIN
4809: l_progress := '010';
4810:
4811: IF PO_LOG.d_proc THEN
4812: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4813: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4814: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4815: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4808: BEGIN
4809: l_progress := '010';
4810:
4811: IF PO_LOG.d_proc THEN
4812: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4813: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4814: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4815: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4816: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4809: l_progress := '010';
4810:
4811: IF PO_LOG.d_proc THEN
4812: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4813: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4814: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4815: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4816: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4817: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4810:
4811: IF PO_LOG.d_proc THEN
4812: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4813: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4814: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4815: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4816: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4817: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4818: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4811: IF PO_LOG.d_proc THEN
4812: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4813: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4814: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4815: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4816: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4817: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4818: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4819: END IF;
4812: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
4813: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4814: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4815: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4816: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4817: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4818: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4819: END IF;
4820:
4813: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
4814: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4815: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4816: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4817: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4818: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4819: END IF;
4820:
4821: l_progress := '020';
4814: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
4815: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
4816: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
4817: PO_LOG.proc_begin(d_mod,'p_language',p_language);
4818: PO_LOG.proc_begin(d_mod,'p_item_description',p_item_description);
4819: END IF;
4820:
4821: l_progress := '020';
4822: IF (p_po_line_id IS NOT NULL) THEN
4836: END IF;
4837:
4838: -- Do not create Attr/TLP if the doc type is not BLANKET or QUOTATION
4839: IF (l_type_lookup_code NOT IN ('BLANKET', 'QUOTATION')) THEN
4840: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Returning without creating Attr/TLP. Doc type='||l_type_lookup_code); END IF;
4841: RETURN;
4842: END IF;
4843: END IF;
4844:
4861: -- i.e. all attribute columns that have 'CAT' in the name.
4862: IF (p_ip_category_id <> l_orig_ip_category_id) THEN
4863: l_progress := '060';
4864:
4865: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IP_CATEGORY_ID has changed: p_ip_category_id='||p_ip_category_id||', l_orig_ip_category_id='||l_orig_ip_category_id); END IF;
4866:
4867: wipeout_category_attributes
4868: (
4869: p_po_line_id => p_po_line_id
4893: AND req_template_name = NVL(p_req_template_name, '-2')
4894: AND req_template_line_num = NVL(p_req_template_line_num, -2)
4895: AND org_id = p_org_id;
4896:
4897: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows updated='||SQL%rowcount); END IF;
4898:
4899: ELSE
4900: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IP_CATEGORY_ID has not changed.'); END IF;
4901: END IF;
4896:
4897: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows updated='||SQL%rowcount); END IF;
4898:
4899: ELSE
4900: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'IP_CATEGORY_ID has not changed.'); END IF;
4901: END IF;
4902:
4903: l_progress := '080';
4904:
4924: l_orig_item_description := NULL;
4925: END;
4926:
4927: IF (p_item_description = l_orig_item_description) THEN
4928: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'ITEM_DESCRIPTION has not changed.'); END IF;
4929: ELSE
4930: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'ITEM_DESCRIPTION has changed.'); END IF;
4931: END IF;
4932:
4926:
4927: IF (p_item_description = l_orig_item_description) THEN
4928: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'ITEM_DESCRIPTION has not changed.'); END IF;
4929: ELSE
4930: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'ITEM_DESCRIPTION has changed.'); END IF;
4931: END IF;
4932:
4933: l_progress := '090';
4934: IF ( (p_ip_category_id <> l_orig_ip_category_id) OR
4955: AND req_template_line_num = NVL(p_req_template_line_num, -2)
4956: AND org_id = p_org_id
4957: AND language = p_language;
4958:
4959: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows updated='||SQL%rowcount); END IF;
4960: END IF;
4961:
4962: l_progress := '100';
4963:
5002: AND req_template_line_num = NVL(p_req_template_line_num, -2)
5003: AND org_id = p_org_id
5004: AND language = p_language;
5005:
5006: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows updated='||SQL%rowcount); END IF;
5007: ELSE
5008: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'long description has not changed.'); END IF;
5009: END IF;
5010:
5004: AND language = p_language;
5005:
5006: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows updated='||SQL%rowcount); END IF;
5007: ELSE
5008: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'long description has not changed.'); END IF;
5009: END IF;
5010:
5011: l_progress := '120';
5012: BEGIN
5047: AND req_template_name = NVL(p_req_template_name, '-2')
5048: AND req_template_line_num = NVL(p_req_template_line_num, -2)
5049: AND org_id = p_org_id;
5050:
5051: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows updated='||SQL%rowcount); END IF;
5052:
5053: ELSE
5054: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'lead time has not changed.'); END IF;
5055: END IF;
5050:
5051: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows updated='||SQL%rowcount); END IF;
5052:
5053: ELSE
5054: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'lead time has not changed.'); END IF;
5055: END IF;
5056:
5057: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5058: EXCEPTION
5053: ELSE
5054: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'lead time has not changed.'); END IF;
5055: END IF;
5056:
5057: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5058: EXCEPTION
5059: WHEN OTHERS THEN
5060: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
5061: RAISE;
5056:
5057: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5058: EXCEPTION
5059: WHEN OTHERS THEN
5060: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
5061: RAISE;
5062: END update_attributes;
5063:
5064: --------------------------------------------------------------------------------
5095:
5096: BEGIN
5097: l_progress := '010';
5098:
5099: IF PO_LOG.d_proc THEN
5100: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
5101: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
5102: END IF;
5103:
5096: BEGIN
5097: l_progress := '010';
5098:
5099: IF PO_LOG.d_proc THEN
5100: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
5101: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
5102: END IF;
5103:
5104: --Bug# 5520701: PICTURE column needed to be inserted.
5097: l_progress := '010';
5098:
5099: IF PO_LOG.d_proc THEN
5100: PO_LOG.proc_begin(d_mod,'p_orig_po_line_id',p_orig_po_line_id);
5101: PO_LOG.proc_begin(d_mod,'p_new_po_line_id',p_new_po_line_id);
5102: END IF;
5103:
5104: --Bug# 5520701: PICTURE column needed to be inserted.
5105:
5773: AND ATR2.req_template_line_num = POATR.req_template_line_num
5774: AND ATR2.org_id = POATR.org_id);
5775:
5776: l_progress := '020';
5777: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows copied='||SQL%rowcount); END IF;
5778:
5779: -- SQL What: Insert new rows for Attribute values TLP.
5780: -- This SQL will enter multiple rows, one for each installed lang.
5781: -- SQL Why : To copy the TLP from old doc to new doc
6141: AND TLP2.org_id = POTLP.org_id
6142: AND TLP2.language = POTLP.language);
6143:
6144: l_progress := '030';
6145: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows copied='||SQL%rowcount); END IF;
6146:
6147: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6148: EXCEPTION
6149: WHEN OTHERS THEN
6143:
6144: l_progress := '030';
6145: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows copied='||SQL%rowcount); END IF;
6146:
6147: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6148: EXCEPTION
6149: WHEN OTHERS THEN
6150: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6151: RAISE;
6146:
6147: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6148: EXCEPTION
6149: WHEN OTHERS THEN
6150: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6151: RAISE;
6152: END copy_attributes;
6153:
6154: --------------------------------------------------------------------------------
6184:
6185: BEGIN
6186: l_progress := '010';
6187:
6188: IF PO_LOG.d_proc THEN
6189: PO_LOG.proc_begin(d_mod,'p_po_category_id',p_po_category_id);
6190: END IF;
6191:
6192: -- SQL What: Default the IP_CATEGORY_ID
6185: BEGIN
6186: l_progress := '010';
6187:
6188: IF PO_LOG.d_proc THEN
6189: PO_LOG.proc_begin(d_mod,'p_po_category_id',p_po_category_id);
6190: END IF;
6191:
6192: -- SQL What: Default the IP_CATEGORY_ID
6193: -- SQL Why : To insert the correct default value of IP_CATEGORY ID
6196: INTO x_ip_category_id
6197: FROM ICX_CAT_PURCHASING_CAT_MAP_V
6198: WHERE po_category_id = p_po_category_id;
6199:
6200: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_ip_category_id='||x_ip_category_id); END IF;
6201:
6202: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6203: EXCEPTION
6204: WHEN NO_DATA_FOUND THEN
6198: WHERE po_category_id = p_po_category_id;
6199:
6200: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'x_ip_category_id='||x_ip_category_id); END IF;
6201:
6202: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6203: EXCEPTION
6204: WHEN NO_DATA_FOUND THEN
6205: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'NO_DATA_FOUND exception: Ignoring and setting ip_category_id=-2'); END IF;
6206: x_ip_category_id := -2;
6201:
6202: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6203: EXCEPTION
6204: WHEN NO_DATA_FOUND THEN
6205: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'NO_DATA_FOUND exception: Ignoring and setting ip_category_id=-2'); END IF;
6206: x_ip_category_id := -2;
6207: WHEN TOO_MANY_ROWS THEN
6208: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'TOO_MANY_ROWS exception'); END IF;
6209: x_ip_category_id := -2; -- TODO: This is a temp fix. Resolve with iProc why this exceptions?
6204: WHEN NO_DATA_FOUND THEN
6205: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'NO_DATA_FOUND exception: Ignoring and setting ip_category_id=-2'); END IF;
6206: x_ip_category_id := -2;
6207: WHEN TOO_MANY_ROWS THEN
6208: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'TOO_MANY_ROWS exception'); END IF;
6209: x_ip_category_id := -2; -- TODO: This is a temp fix. Resolve with iProc why this exceptions?
6210: WHEN OTHERS THEN
6211: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6212: RAISE;
6207: WHEN TOO_MANY_ROWS THEN
6208: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'TOO_MANY_ROWS exception'); END IF;
6209: x_ip_category_id := -2; -- TODO: This is a temp fix. Resolve with iProc why this exceptions?
6210: WHEN OTHERS THEN
6211: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6212: RAISE;
6213: END get_ip_category_id;
6214:
6215: --------------------------------------------------------------------------------
6250:
6251: BEGIN
6252: l_progress := '010';
6253:
6254: IF PO_LOG.d_proc THEN
6255: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6256: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6257: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6258: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
6251: BEGIN
6252: l_progress := '010';
6253:
6254: IF PO_LOG.d_proc THEN
6255: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6256: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6257: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6258: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
6259: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6252: l_progress := '010';
6253:
6254: IF PO_LOG.d_proc THEN
6255: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6256: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6257: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6258: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
6259: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6260: END IF;
6253:
6254: IF PO_LOG.d_proc THEN
6255: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6256: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6257: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6258: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
6259: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6260: END IF;
6261:
6254: IF PO_LOG.d_proc THEN
6255: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6256: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6257: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6258: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
6259: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6260: END IF;
6261:
6262: -- SQL What: Delete Attribute Values
6255: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6256: PO_LOG.proc_begin(d_mod,'p_po_line_id',p_po_line_id);
6257: PO_LOG.proc_begin(d_mod,'p_req_template_name',p_req_template_name);
6258: PO_LOG.proc_begin(d_mod,'p_req_template_line_num',p_req_template_line_num);
6259: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6260: END IF;
6261:
6262: -- SQL What: Delete Attribute Values
6263: -- SQL Why : as required by this procedure
6268: AND req_template_line_num = NVL(p_req_template_line_num, -2)
6269: AND org_id = NVL(p_org_id, PO_MOAC_UTILS_PVT.get_current_org_id);
6270:
6271: l_progress := '020';
6272: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows deleted='||SQL%rowcount); END IF;
6273:
6274: -- SQL What: Delete Attribute Values TLP
6275: -- SQL Why : as required by this procedure
6276: -- SQL Join: po_line_id, req_template_name, req_template_line_num, org_id
6280: AND req_template_line_num = NVL(p_req_template_line_num, -2)
6281: AND org_id = NVL(p_org_id, PO_MOAC_UTILS_PVT.get_current_org_id);
6282:
6283: l_progress := '030';
6284: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows deleted='||SQL%rowcount); END IF;
6285:
6286: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6287: EXCEPTION
6288: WHEN OTHERS THEN
6282:
6283: l_progress := '030';
6284: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows deleted='||SQL%rowcount); END IF;
6285:
6286: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6287: EXCEPTION
6288: WHEN OTHERS THEN
6289: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6290: RAISE;
6285:
6286: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6287: EXCEPTION
6288: WHEN OTHERS THEN
6289: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6290: RAISE;
6291: END delete_attributes;
6292:
6293: --------------------------------------------------------------------------------
6323:
6324: BEGIN
6325: l_progress := '010';
6326:
6327: IF PO_LOG.d_proc THEN
6328: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6329: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
6330: END IF;
6331:
6324: BEGIN
6325: l_progress := '010';
6326:
6327: IF PO_LOG.d_proc THEN
6328: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6329: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
6330: END IF;
6331:
6332: IF (p_doc_type IN ('BLANKET', 'QUOTATION')) THEN
6325: l_progress := '010';
6326:
6327: IF PO_LOG.d_proc THEN
6328: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
6329: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
6330: END IF;
6331:
6332: IF (p_doc_type IN ('BLANKET', 'QUOTATION')) THEN
6333: -- SQL What: Delete Attribute Values for all lines in a PO Header
6341: AND POATR.po_line_id = POL.po_line_id);
6342:
6343:
6344: l_progress := '020';
6345: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of ATTR rows deleted='||SQL%rowcount); END IF;
6346:
6347: -- SQL What: Delete Attribute Values TLP for all lines in a PO Header
6348: -- SQL Why : as required by this procedure
6349: -- SQL Join: po_line_id, po_header_id
6354: WHERE POL.po_header_id = p_po_header_id
6355: AND POTLP.po_line_id = POL.po_line_id);
6356:
6357: l_progress := '030';
6358: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows deleted='||SQL%rowcount); END IF;
6359: ELSE
6360: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc_type='||p_doc_type); END IF;
6361: END IF;
6362:
6356:
6357: l_progress := '030';
6358: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of TLP rows deleted='||SQL%rowcount); END IF;
6359: ELSE
6360: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc_type='||p_doc_type); END IF;
6361: END IF;
6362:
6363: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6364: EXCEPTION
6359: ELSE
6360: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Invalid doc_type='||p_doc_type); END IF;
6361: END IF;
6362:
6363: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6364: EXCEPTION
6365: WHEN OTHERS THEN
6366: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6367: RAISE;
6362:
6363: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6364: EXCEPTION
6365: WHEN OTHERS THEN
6366: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6367: RAISE;
6368: END delete_attributes_for_header;
6369:
6370: --------------------------------------------------------------------------------
6391: d_mod CONSTANT VARCHAR2(100) := D_get_base_lang;
6392: l_progress VARCHAR2(4);
6393: BEGIN
6394: l_progress := '010';
6395: IF PO_LOG.d_proc THEN PO_LOG.proc_begin(d_mod); END IF;
6396:
6397: l_progress := '020';
6398: IF (g_base_language IS NULL) THEN
6399: -- SQL What: Get the base language of the system installation.
6405: WHERE installed_flag='B';
6406: END IF;
6407:
6408: l_progress := '030';
6409: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'base_lang=<'||g_base_language||'>'); END IF;
6410:
6411: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6412: RETURN g_base_language;
6413: EXCEPTION
6407:
6408: l_progress := '030';
6409: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'base_lang=<'||g_base_language||'>'); END IF;
6410:
6411: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6412: RETURN g_base_language;
6413: EXCEPTION
6414: WHEN OTHERS THEN
6415: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6411: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6412: RETURN g_base_language;
6413: EXCEPTION
6414: WHEN OTHERS THEN
6415: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6416: RAISE;
6417: END get_base_lang;
6418:
6419: PROCEDURE create_attributes_tlp_MI
6437: BEGIN
6438: l_progress := '010';
6439:
6440:
6441: IF PO_LOG.d_proc THEN
6442: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6443: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6444: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6445: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6438: l_progress := '010';
6439:
6440:
6441: IF PO_LOG.d_proc THEN
6442: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6443: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6444: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6445: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6446: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6439:
6440:
6441: IF PO_LOG.d_proc THEN
6442: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6443: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6444: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6445: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6446: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6447: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6440:
6441: IF PO_LOG.d_proc THEN
6442: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6443: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6444: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6445: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6446: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6447: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6448: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
6441: IF PO_LOG.d_proc THEN
6442: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6443: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6444: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6445: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6446: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6447: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6448: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
6449: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
6442: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
6443: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6444: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6445: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6446: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6447: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6448: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
6449: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
6450:
6443: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6444: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6445: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6446: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6447: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6448: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
6449: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
6450:
6451: END IF;
6444: PO_LOG.proc_begin(d_mod,'p_ip_category_id',p_ip_category_id);
6445: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6446: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6447: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6448: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
6449: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
6450:
6451: END IF;
6452:
6445: PO_LOG.proc_begin(d_mod,'p_language',p_language);
6446: PO_LOG.proc_begin(d_mod,'p_description',p_description);
6447: PO_LOG.proc_begin(d_mod,'p_long_description',p_long_description);
6448: PO_LOG.proc_begin(d_mod,'p_organization_id', p_organization_id);
6449: PO_LOG.proc_begin(d_mod,'p_master_organization_id',p_master_organization_id);
6450:
6451: END IF;
6452:
6453: l_progress := '030';
6533: AND TLP2.req_template_line_num = -2
6534: );
6535:
6536: l_progress := '060';
6537: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in TLP table='||SQL%rowcount); END IF;
6538:
6539: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6540: EXCEPTION
6541: WHEN OTHERS THEN
6535:
6536: l_progress := '060';
6537: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted in TLP table='||SQL%rowcount); END IF;
6538:
6539: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6540: EXCEPTION
6541: WHEN OTHERS THEN
6542: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6543: RAISE;
6538:
6539: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6540: EXCEPTION
6541: WHEN OTHERS THEN
6542: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
6543: RAISE;
6544: END create_attributes_tlp_MI;
6545:
6546: --------------------------------------------------------------------------------
6617: l_inv_organization_id MTL_PARAMETERS.master_organization_id%TYPE;
6618:
6619: BEGIN
6620: l_progress := '010';
6621: IF PO_LOG.d_proc THEN
6622: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6623: END IF;
6624:
6625: -- Get MASTER_ORGANIZATION_ID and INVENTORY_ORGANIZATION_ID
6618:
6619: BEGIN
6620: l_progress := '010';
6621: IF PO_LOG.d_proc THEN
6622: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6623: END IF;
6624:
6625: -- Get MASTER_ORGANIZATION_ID and INVENTORY_ORGANIZATION_ID
6626: -- Use master org to get mfg_part_num, manufacturer_name and long_description
6633: FROM mtl_parameters mtl,
6634: financials_system_parameters fsp
6635: WHERE fsp.inventory_organization_id = mtl.organization_id;
6636:
6637: IF PO_LOG.d_stmt THEN
6638: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);
6639: PO_LOG.stmt(d_mod,l_progress,'l_inv_organization_id='||l_inv_organization_id);
6640: END IF;
6641: l_progress := '020';
6634: financials_system_parameters fsp
6635: WHERE fsp.inventory_organization_id = mtl.organization_id;
6636:
6637: IF PO_LOG.d_stmt THEN
6638: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);
6639: PO_LOG.stmt(d_mod,l_progress,'l_inv_organization_id='||l_inv_organization_id);
6640: END IF;
6641: l_progress := '020';
6642:
6635: WHERE fsp.inventory_organization_id = mtl.organization_id;
6636:
6637: IF PO_LOG.d_stmt THEN
6638: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);
6639: PO_LOG.stmt(d_mod,l_progress,'l_inv_organization_id='||l_inv_organization_id);
6640: END IF;
6641: l_progress := '020';
6642:
6643: -- Get MANUFACTURER Related info
6654: WHERE inventory_item_id = p_inventory_item_id
6655: AND organization_id = l_master_organization_id);
6656:
6657:
6658: IF PO_LOG.d_stmt THEN
6659: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer_part_num='||p_manufacturer_part_num);
6660: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer='||p_manufacturer);
6661: END IF;
6662: l_progress := '030';
6655: AND organization_id = l_master_organization_id);
6656:
6657:
6658: IF PO_LOG.d_stmt THEN
6659: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer_part_num='||p_manufacturer_part_num);
6660: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer='||p_manufacturer);
6661: END IF;
6662: l_progress := '030';
6663:
6656:
6657:
6658: IF PO_LOG.d_stmt THEN
6659: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer_part_num='||p_manufacturer_part_num);
6660: PO_LOG.stmt(d_mod,l_progress,'p_manufacturer='||p_manufacturer);
6661: END IF;
6662: l_progress := '030';
6663:
6664: EXCEPTION
6673: FROM mtl_system_items_b
6674: WHERE inventory_item_id = p_inventory_item_id
6675: AND organization_id = l_inv_organization_id;
6676:
6677: IF PO_LOG.d_stmt THEN
6678: PO_LOG.stmt(d_mod,l_progress,'p_lead_time='||p_lead_time);
6679: END IF;
6680: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6681: exception
6674: WHERE inventory_item_id = p_inventory_item_id
6675: AND organization_id = l_inv_organization_id;
6676:
6677: IF PO_LOG.d_stmt THEN
6678: PO_LOG.stmt(d_mod,l_progress,'p_lead_time='||p_lead_time);
6679: END IF;
6680: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6681: exception
6682: when others then
6676:
6677: IF PO_LOG.d_stmt THEN
6678: PO_LOG.stmt(d_mod,l_progress,'p_lead_time='||p_lead_time);
6679: END IF;
6680: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6681: exception
6682: when others then
6683: IF PO_LOG.d_stmt THEN
6684: PO_LOG.stmt(d_mod,l_progress,'exception in get_item_attributes_values sqlcode='||sqlcode||' sqlerrm='||sqlerrm);
6679: END IF;
6680: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6681: exception
6682: when others then
6683: IF PO_LOG.d_stmt THEN
6684: PO_LOG.stmt(d_mod,l_progress,'exception in get_item_attributes_values sqlcode='||sqlcode||' sqlerrm='||sqlerrm);
6685: END IF;
6686: END get_item_attributes_values;
6687: --------------------------------------------------------------------------------
6680: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6681: exception
6682: when others then
6683: IF PO_LOG.d_stmt THEN
6684: PO_LOG.stmt(d_mod,l_progress,'exception in get_item_attributes_values sqlcode='||sqlcode||' sqlerrm='||sqlerrm);
6685: END IF;
6686: END get_item_attributes_values;
6687: --------------------------------------------------------------------------------
6688: --Start of Comments
6716: l_progress VARCHAR2(4);
6717: l_master_organization_id PO_LINES_ALL.org_id%TYPE;
6718: BEGIN
6719: l_progress := '010';
6720: IF PO_LOG.d_proc THEN
6721: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6722: PO_LOG.proc_begin(d_mod,'p_lang',p_lang);
6723: END IF;
6724:
6717: l_master_organization_id PO_LINES_ALL.org_id%TYPE;
6718: BEGIN
6719: l_progress := '010';
6720: IF PO_LOG.d_proc THEN
6721: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6722: PO_LOG.proc_begin(d_mod,'p_lang',p_lang);
6723: END IF;
6724:
6725: -- Get MASTER_ORGANIZATION_ID
6718: BEGIN
6719: l_progress := '010';
6720: IF PO_LOG.d_proc THEN
6721: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);
6722: PO_LOG.proc_begin(d_mod,'p_lang',p_lang);
6723: END IF;
6724:
6725: -- Get MASTER_ORGANIZATION_ID
6726: SELECT mtl.master_organization_id
6728: FROM mtl_parameters mtl,
6729: financials_system_parameters fsp
6730: WHERE fsp.inventory_organization_id = mtl.organization_id;
6731:
6732: IF PO_LOG.d_stmt THEN
6733: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);
6734: END IF;
6735: l_progress := '020';
6736:
6729: financials_system_parameters fsp
6730: WHERE fsp.inventory_organization_id = mtl.organization_id;
6731:
6732: IF PO_LOG.d_stmt THEN
6733: PO_LOG.stmt(d_mod,l_progress,'l_master_organization_id='||l_master_organization_id);
6734: END IF;
6735: l_progress := '020';
6736:
6737: -- Get LONG_DESCRIPTION
6742: WHERE inventory_item_id = p_inventory_item_id
6743: AND organization_id = l_master_organization_id
6744: AND language = p_lang;
6745:
6746: IF PO_LOG.d_stmt THEN
6747: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6748: END IF;
6749: EXCEPTION
6750: -- If not found, get it for the base lang
6743: AND organization_id = l_master_organization_id
6744: AND language = p_lang;
6745:
6746: IF PO_LOG.d_stmt THEN
6747: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6748: END IF;
6749: EXCEPTION
6750: -- If not found, get it for the base lang
6751: WHEN NO_DATA_FOUND THEN
6754: FROM mtl_system_items_tl
6755: WHERE inventory_item_id = p_inventory_item_id
6756: AND organization_id = l_master_organization_id
6757: AND language = g_base_language;
6758: IF PO_LOG.d_stmt THEN
6759: PO_LOG.stmt(d_mod,l_progress,'NO_DATA_FOUND');
6760: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6761: END IF;
6762: END;
6755: WHERE inventory_item_id = p_inventory_item_id
6756: AND organization_id = l_master_organization_id
6757: AND language = g_base_language;
6758: IF PO_LOG.d_stmt THEN
6759: PO_LOG.stmt(d_mod,l_progress,'NO_DATA_FOUND');
6760: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6761: END IF;
6762: END;
6763:
6756: AND organization_id = l_master_organization_id
6757: AND language = g_base_language;
6758: IF PO_LOG.d_stmt THEN
6759: PO_LOG.stmt(d_mod,l_progress,'NO_DATA_FOUND');
6760: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6761: END IF;
6762: END;
6763:
6764: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6760: PO_LOG.stmt(d_mod,l_progress,'p_long_description='||p_long_description);
6761: END IF;
6762: END;
6763:
6764: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6765: exception
6766: when others then
6767: IF PO_LOG.d_stmt THEN
6768: PO_LOG.stmt(d_mod,l_progress,'exception in get_item_attributes_tlp_values sqlcode='||sqlcode||' sqlerrm='||sqlerrm);
6763:
6764: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6765: exception
6766: when others then
6767: IF PO_LOG.d_stmt THEN
6768: PO_LOG.stmt(d_mod,l_progress,'exception in get_item_attributes_tlp_values sqlcode='||sqlcode||' sqlerrm='||sqlerrm);
6769: END IF;
6770: END get_item_attributes_tlp_values;
6771:
6764: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
6765: exception
6766: when others then
6767: IF PO_LOG.d_stmt THEN
6768: PO_LOG.stmt(d_mod,l_progress,'exception in get_item_attributes_tlp_values sqlcode='||sqlcode||' sqlerrm='||sqlerrm);
6769: END IF;
6770: END get_item_attributes_tlp_values;
6771:
6772: END;