APPS.MTL_STATUS_TRX_CONTROL_PKG dependencies on MTL_STATUS_TRANSACTION_CONTROL

Line 17: CURSOR C IS SELECT ROWID FROM MTL_STATUS_TRANSACTION_CONTROL

13: ,p_LAST_UPDATE_LOGIN IN NUMBER
14: ,p_PROGRAM_APPLICATION_ID IN NUMBER
15: ,p_PROGRAM_ID IN NUMBER
16: )IS
17: CURSOR C IS SELECT ROWID FROM MTL_STATUS_TRANSACTION_CONTROL
18: WHERE status_id = p_STATUS_ID
19: AND transaction_type_id = p_TRANSACTION_TYPE_ID;
20: BEGIN
21: INSERT INTO MTL_STATUS_TRANSACTION_CONTROL (

Line 21: INSERT INTO MTL_STATUS_TRANSACTION_CONTROL (

17: CURSOR C IS SELECT ROWID FROM MTL_STATUS_TRANSACTION_CONTROL
18: WHERE status_id = p_STATUS_ID
19: AND transaction_type_id = p_TRANSACTION_TYPE_ID;
20: BEGIN
21: INSERT INTO MTL_STATUS_TRANSACTION_CONTROL (
22: status_id
23: , transaction_type_id
24: , is_allowed
25: , creation_date

Line 70: FROM MTL_STATUS_TRANSACTION_CONTROL

66: , last_update_date
67: , last_update_login
68: , program_application_id
69: , program_id
70: FROM MTL_STATUS_TRANSACTION_CONTROL
71: WHERE status_id = p_STATUS_ID
72: AND transaction_type_id = p_TRANSACTION_TYPE_ID
73: FOR UPDATE OF status_id,transaction_type_id NOWAIT;
74:

Line 109: UPDATE MTL_STATUS_TRANSACTION_CONTROL SET

105: ,p_PROGRAM_ID IN NUMBER
106: )IS
107: x_ROWID varchar2(18);
108: BEGIN
109: UPDATE MTL_STATUS_TRANSACTION_CONTROL SET
110: status_id = p_STATUS_ID
111: , transaction_type_id = p_TRANSACTION_TYPE_ID
112: , is_allowed = p_IS_ALLOWED
113: , last_updated_by = p_LAST_UPDATED_BY

Line 148: FROM MTL_STATUS_TRANSACTION_CONTROL

144: From MTL_TRANSACTION_TYPES mmt
145: where mmt.status_control_flag = 1
146: and mmt.transaction_type_id not in (
147: SELECT transaction_type_id
148: FROM MTL_STATUS_TRANSACTION_CONTROL
149: WHERE status_id = P_STATUS_ID);
150: c_t_type c_excluded_trxs%ROWTYPE;
151:
152: x_ROWID varchar2(18);