APPS.INVUPDAT dependencies on MTL_SYSTEM_ITEMS

Line 29: from mtl_system_items

25: the system from hanging if an item record that needs to be updated is open and locked.*/
26:
27: CURSOR lock_records IS
28: select 'x'
29: from mtl_system_items
30: where decode(current_attribute_name, 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG', inventory_item_flag,
31: 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG', stock_enabled_flag,
32: 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG', purchasing_item_flag,
33: 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG', invoiceable_item_flag,

Line 30: where decode(current_attribute_name, 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG', inventory_item_flag,

26:
27: CURSOR lock_records IS
28: select 'x'
29: from mtl_system_items
30: where decode(current_attribute_name, 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG', inventory_item_flag,
31: 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG', stock_enabled_flag,
32: 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG', purchasing_item_flag,
33: 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG', invoiceable_item_flag,
34: 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG', inventory_item_flag,

Line 31: 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG', stock_enabled_flag,

27: CURSOR lock_records IS
28: select 'x'
29: from mtl_system_items
30: where decode(current_attribute_name, 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG', inventory_item_flag,
31: 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG', stock_enabled_flag,
32: 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG', purchasing_item_flag,
33: 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG', invoiceable_item_flag,
34: 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG', inventory_item_flag,
35: 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG', customer_order_flag,

Line 32: 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG', purchasing_item_flag,

28: select 'x'
29: from mtl_system_items
30: where decode(current_attribute_name, 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG', inventory_item_flag,
31: 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG', stock_enabled_flag,
32: 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG', purchasing_item_flag,
33: 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG', invoiceable_item_flag,
34: 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG', inventory_item_flag,
35: 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG', customer_order_flag,
36: 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG', internal_order_flag,

Line 33: 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG', invoiceable_item_flag,

29: from mtl_system_items
30: where decode(current_attribute_name, 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG', inventory_item_flag,
31: 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG', stock_enabled_flag,
32: 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG', purchasing_item_flag,
33: 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG', invoiceable_item_flag,
34: 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG', inventory_item_flag,
35: 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG', customer_order_flag,
36: 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG', internal_order_flag,
37: 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG', bom_enabled_flag,

Line 34: 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG', inventory_item_flag,

30: where decode(current_attribute_name, 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG', inventory_item_flag,
31: 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG', stock_enabled_flag,
32: 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG', purchasing_item_flag,
33: 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG', invoiceable_item_flag,
34: 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG', inventory_item_flag,
35: 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG', customer_order_flag,
36: 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG', internal_order_flag,
37: 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG', bom_enabled_flag,
38: 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG', recipe_enabled_flag,

Line 35: 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG', customer_order_flag,

31: 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG', stock_enabled_flag,
32: 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG', purchasing_item_flag,
33: 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG', invoiceable_item_flag,
34: 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG', inventory_item_flag,
35: 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG', customer_order_flag,
36: 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG', internal_order_flag,
37: 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG', bom_enabled_flag,
38: 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG', recipe_enabled_flag,
39: 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG',process_execution_enabled_flag, 'N')

Line 36: 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG', internal_order_flag,

32: 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG', purchasing_item_flag,
33: 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG', invoiceable_item_flag,
34: 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG', inventory_item_flag,
35: 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG', customer_order_flag,
36: 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG', internal_order_flag,
37: 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG', bom_enabled_flag,
38: 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG', recipe_enabled_flag,
39: 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG',process_execution_enabled_flag, 'N')
40: = 'Y'

Line 37: 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG', bom_enabled_flag,

33: 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG', invoiceable_item_flag,
34: 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG', inventory_item_flag,
35: 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG', customer_order_flag,
36: 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG', internal_order_flag,
37: 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG', bom_enabled_flag,
38: 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG', recipe_enabled_flag,
39: 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG',process_execution_enabled_flag, 'N')
40: = 'Y'
41: and input_status = MTL_SYSTEM_ITEMS.inventory_item_status_code

Line 38: 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG', recipe_enabled_flag,

34: 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG', inventory_item_flag,
35: 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG', customer_order_flag,
36: 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG', internal_order_flag,
37: 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG', bom_enabled_flag,
38: 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG', recipe_enabled_flag,
39: 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG',process_execution_enabled_flag, 'N')
40: = 'Y'
41: and input_status = MTL_SYSTEM_ITEMS.inventory_item_status_code
42: for update of last_update_date NOWAIT;

Line 39: 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG',process_execution_enabled_flag, 'N')

35: 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG', customer_order_flag,
36: 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG', internal_order_flag,
37: 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG', bom_enabled_flag,
38: 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG', recipe_enabled_flag,
39: 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG',process_execution_enabled_flag, 'N')
40: = 'Y'
41: and input_status = MTL_SYSTEM_ITEMS.inventory_item_status_code
42: for update of last_update_date NOWAIT;
43:

Line 41: and input_status = MTL_SYSTEM_ITEMS.inventory_item_status_code

37: 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG', bom_enabled_flag,
38: 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG', recipe_enabled_flag,
39: 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG',process_execution_enabled_flag, 'N')
40: = 'Y'
41: and input_status = MTL_SYSTEM_ITEMS.inventory_item_status_code
42: for update of last_update_date NOWAIT;
43:
44: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
45: BEGIN

Line 62: if ( current_attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG') then

58: IF l_inv_debug_level IN(101, 102) THEN
59: INVPUTLI.info('inside for IISC ' || status_cursor_row.IISC);
60: INVPUTLI.info('current attribute is ' ||current_attribute_name );
61: END IF;
62: if ( current_attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG') then
63: update mtl_system_items msi
64: set msi.stock_enabled_flag
65: = NVL(current_attribute_value, status_cursor_row.AV),
66: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

Line 63: update mtl_system_items msi

59: INVPUTLI.info('inside for IISC ' || status_cursor_row.IISC);
60: INVPUTLI.info('current attribute is ' ||current_attribute_name );
61: END IF;
62: if ( current_attribute_name = 'MTL_SYSTEM_ITEMS.STOCK_ENABLED_FLAG') then
63: update mtl_system_items msi
64: set msi.stock_enabled_flag
65: = NVL(current_attribute_value, status_cursor_row.AV),
66: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
67: msi.last_update_date = sysdate,

Line 73: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG') then

69: where msi.inventory_item_flag = 'Y'
70: and msi.stock_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
71: and msi.inventory_item_status_code = status_cursor_row.IISC;
72:
73: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG') then
74: update mtl_system_items msi
75: set msi.mtl_transactions_enabled_flag
76: = NVL(current_attribute_value, status_cursor_row.AV),
77: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

Line 74: update mtl_system_items msi

70: and msi.stock_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
71: and msi.inventory_item_status_code = status_cursor_row.IISC;
72:
73: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG') then
74: update mtl_system_items msi
75: set msi.mtl_transactions_enabled_flag
76: = NVL(current_attribute_value, status_cursor_row.AV),
77: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
78: msi.last_update_date = sysdate,

Line 84: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG') then

80: where msi.stock_enabled_flag = 'Y'
81: and msi.mtl_transactions_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
82: and msi.inventory_item_status_code = status_cursor_row.IISC;
83:
84: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG') then
85: update mtl_system_items msi
86: set msi.purchasing_enabled_flag
87: = NVL(current_attribute_value, status_cursor_row.AV),
88: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

Line 85: update mtl_system_items msi

81: and msi.mtl_transactions_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
82: and msi.inventory_item_status_code = status_cursor_row.IISC;
83:
84: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG') then
85: update mtl_system_items msi
86: set msi.purchasing_enabled_flag
87: = NVL(current_attribute_value, status_cursor_row.AV),
88: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
89: msi.last_update_date = sysdate,

Line 95: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG') then

91: where msi.purchasing_item_flag = 'Y'
92: and msi.purchasing_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
93: and msi.inventory_item_status_code = status_cursor_row.IISC;
94:
95: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG') then
96: update mtl_system_items msi
97: set msi.invoice_enabled_flag
98: = NVL(current_attribute_value, status_cursor_row.AV),
99: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

Line 96: update mtl_system_items msi

92: and msi.purchasing_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
93: and msi.inventory_item_status_code = status_cursor_row.IISC;
94:
95: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG') then
96: update mtl_system_items msi
97: set msi.invoice_enabled_flag
98: = NVL(current_attribute_value, status_cursor_row.AV),
99: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
100: msi.last_update_date = sysdate,

Line 106: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG') then

102: where msi.invoiceable_item_flag = 'Y'
103: and msi.invoice_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
104: and msi.inventory_item_status_code = status_cursor_row.IISC;
105:
106: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG') then
107: update mtl_system_items msi
108: set msi.build_in_wip_flag
109: = NVL(current_attribute_value, status_cursor_row.AV),
110: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

Line 107: update mtl_system_items msi

103: and msi.invoice_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
104: and msi.inventory_item_status_code = status_cursor_row.IISC;
105:
106: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG') then
107: update mtl_system_items msi
108: set msi.build_in_wip_flag
109: = NVL(current_attribute_value, status_cursor_row.AV),
110: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
111: msi.last_update_date = sysdate,

Line 118: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG') then

114: and msi.build_in_wip_flag <> NVL(current_attribute_value, status_cursor_row.AV)
115: and msi.bom_item_type = 4
116: and msi.inventory_item_status_code = status_cursor_row.IISC;
117:
118: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG') then
119: update mtl_system_items msi
120: set msi.customer_order_enabled_flag
121: = NVL(current_attribute_value, status_cursor_row.AV),
122: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

Line 119: update mtl_system_items msi

115: and msi.bom_item_type = 4
116: and msi.inventory_item_status_code = status_cursor_row.IISC;
117:
118: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG') then
119: update mtl_system_items msi
120: set msi.customer_order_enabled_flag
121: = NVL(current_attribute_value, status_cursor_row.AV),
122: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
123: msi.last_update_date = sysdate,

Line 129: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG') then

125: where msi.customer_order_flag = 'Y'
126: and msi.customer_order_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
127: and msi.inventory_item_status_code = status_cursor_row.IISC;
128:
129: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG') then
130: update mtl_system_items msi
131: set msi.internal_order_enabled_flag
132: = NVL(current_attribute_value, status_cursor_row.AV),
133: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

Line 130: update mtl_system_items msi

126: and msi.customer_order_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
127: and msi.inventory_item_status_code = status_cursor_row.IISC;
128:
129: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG') then
130: update mtl_system_items msi
131: set msi.internal_order_enabled_flag
132: = NVL(current_attribute_value, status_cursor_row.AV),
133: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
134: msi.last_update_date = sysdate,

Line 140: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG') then

136: where msi.internal_order_flag = 'Y'
137: and msi.internal_order_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
138: and msi.inventory_item_status_code = status_cursor_row.IISC;
139:
140: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG') then
141: update mtl_system_items msi
142: set msi.bom_enabled_flag
143: = NVL(current_attribute_value, status_cursor_row.AV),
144: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

Line 141: update mtl_system_items msi

137: and msi.internal_order_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
138: and msi.inventory_item_status_code = status_cursor_row.IISC;
139:
140: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG') then
141: update mtl_system_items msi
142: set msi.bom_enabled_flag
143: = NVL(current_attribute_value, status_cursor_row.AV),
144: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
145: msi.last_update_date = sysdate,

Line 151: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG') then

147: where --Bug: 3546140 msi.inventory_item_flag = 'Y'and
148: msi.bom_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
149: and msi.inventory_item_status_code = status_cursor_row.IISC;
150: /* Jalaj Srivastava Bug 4032615 */
151: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG') then
152: update mtl_system_items msi
153: set msi.recipe_enabled_flag
154: = NVL(current_attribute_value, status_cursor_row.AV),
155: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

Line 152: update mtl_system_items msi

148: msi.bom_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
149: and msi.inventory_item_status_code = status_cursor_row.IISC;
150: /* Jalaj Srivastava Bug 4032615 */
151: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG') then
152: update mtl_system_items msi
153: set msi.recipe_enabled_flag
154: = NVL(current_attribute_value, status_cursor_row.AV),
155: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
156: msi.last_update_date = sysdate,

Line 161: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG') then

157: msi.last_update_login = to_number(fnd_profile.value('LOGIN_ID'))
158: where msi.recipe_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
159: and msi.inventory_item_status_code = status_cursor_row.IISC;
160:
161: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG') then
162: update mtl_system_items msi
163: set msi.process_execution_enabled_flag
164: = NVL(current_attribute_value, status_cursor_row.AV),
165: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),

Line 162: update mtl_system_items msi

158: where msi.recipe_enabled_flag <> NVL(current_attribute_value, status_cursor_row.AV)
159: and msi.inventory_item_status_code = status_cursor_row.IISC;
160:
161: elsif ( current_attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG') then
162: update mtl_system_items msi
163: set msi.process_execution_enabled_flag
164: = NVL(current_attribute_value, status_cursor_row.AV),
165: msi.last_updated_by = to_number(fnd_profile.value('USER_ID')),
166: msi.last_update_date = sysdate,