APPS.AMW_PROC_APPROVAL_PKG dependencies on AMW_PROCESS_LOCKS

Line 44: insert into amw_process_locks

40: -- lock only the process and its children
41: -- (3) don't approve unless everything below is approved.
42: -- same as (1)
43:
44: insert into amw_process_locks
45: (organization_id,
46: locking_process_id,
47: locked_process_id,
48: LAST_UPDATE_DATE,

Line 69: insert into amw_process_locks

65: );
66:
67: if (approv_choice = 'B') then
68:
69: insert into amw_process_locks
70: (organization_id,
71: locking_process_id,
72: locked_process_id,
73: LAST_UPDATE_DATE,

Line 88: insert into amw_process_locks

84: and hierarchy_type = 'L');
85:
86: elsif (approv_choice = 'A') then
87:
88: insert into amw_process_locks
89: (organization_id,
90: locking_process_id,
91: locked_process_id,
92: LAST_UPDATE_DATE,

Line 112: insert into amw_process_locks

108: IF(P_WEBADI_CALL IS NULL) THEN
109: check_hier_approved(p_process_id);
110: END IF;
111:
112: insert into amw_process_locks
113: (organization_id,
114: locking_process_id,
115: locked_process_id,
116: LAST_UPDATE_DATE,

Line 183: delete from amw_process_locks

179:
180: -- release locks
181: approv_choice := amw_utility_pvt.get_parameter(-1, 'PROCESS_APPROVAL_OPTION');
182:
183: delete from amw_process_locks
184: where organization_id = -1
185: and locking_process_id = p_process_id;
186:
187: update amw_process

Line 251: delete from amw_process_locks

247: set approval_status = 'D'
248: where process_id = p_process_id
249: and end_date is null;
250:
251: delete from amw_process_locks
252: where organization_id = -1
253: and locking_process_id = p_process_id;
254:
255: end reject;

Line 1202: delete from amw_process_locks

1198: return;
1199: end if;
1200:
1201: /**
1202: delete from amw_process_locks
1203: where organization_id = -1
1204: and locking_process_id = p_process_id;
1205: **/
1206: