28:
29: CURSOR check_template_name (cp_template_name VARCHAR2) IS
30: SELECT template_id,
31: context_organization_id
32: FROM mtl_item_templates
33: WHERE template_name = cp_template_name;
34:
35: CURSOR check_template_id (cp_template_id NUMBER) IS
36: SELECT template_id,
34:
35: CURSOR check_template_id (cp_template_id NUMBER) IS
36: SELECT template_id,
37: context_organization_id
38: FROM mtl_item_templates
39: WHERE template_id = cp_template_id;
40:
41:
42: CURSOR get_template_values(cp_template_id NUMBER) IS
75: GLOBAL_ATTRIBUTE17,
76: GLOBAL_ATTRIBUTE18,
77: GLOBAL_ATTRIBUTE19,
78: GLOBAL_ATTRIBUTE20
79: FROM MTL_ITEM_TEMPLATES MIT
80: WHERE MIT.template_id = cp_template_id;
81:
82: --Bug:6282388
83: CURSOR isMasterOrg(cp_orgid NUMBER)
88: AND rownum = 1;
89:
90: l_isMasterOrg NUMBER;
91: AttRec MTL_SYSTEM_ITEMS_B%ROWTYPE;
92: context_orgid mtl_item_templates.context_organization_id%TYPE;
93: l_template_id mtl_item_templates.template_id%TYPE := NULL;
94: rtn_status number := 0;
95: dumm_status number := 0;
96: LOGGING_ERR EXCEPTION;
89:
90: l_isMasterOrg NUMBER;
91: AttRec MTL_SYSTEM_ITEMS_B%ROWTYPE;
92: context_orgid mtl_item_templates.context_organization_id%TYPE;
93: l_template_id mtl_item_templates.template_id%TYPE := NULL;
94: rtn_status number := 0;
95: dumm_status number := 0;
96: LOGGING_ERR EXCEPTION;
97: l_error_exists BOOLEAN := FALSE;
100:
101: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
102:
103: TYPE template_id_type IS TABLE OF
104: mtl_item_templates.template_id%TYPE
105: INDEX BY BINARY_INTEGER;
106:
107: --Bug 4456453
108: TYPE transaction_table_type IS TABLE OF