APPS.AMW_PROC_ORG_APPROVAL_PKG dependencies on AMW_PROCESS_LOCKS

Line 56: insert into amw_process_locks

52: -- lock only the process and its children
53: -- (3) don't approve unless everything below is approved.
54: -- same as (1)
55:
56: insert into amw_process_locks
57: (organization_id,
58: locking_process_id,
59: locked_process_id,
60: LAST_UPDATE_DATE,

Line 82: insert into amw_process_locks

78: );
79:
80: if (approv_choice = 'B') then
81:
82: insert into amw_process_locks
83: (organization_id,
84: locking_process_id,
85: locked_process_id,
86: LAST_UPDATE_DATE,

Line 107: insert into amw_process_locks

103: and hierarchy_type = 'L');
104: */
105: elsif (approv_choice = 'A') then
106:
107: insert into amw_process_locks
108: (organization_id,
109: locking_process_id,
110: locked_process_id,
111: LAST_UPDATE_DATE,

Line 127: insert into amw_process_locks

123: elsif (approv_choice = 'C') then
124:
125: check_hier_approved(p_process_id, p_org_id);
126:
127: insert into amw_process_locks
128: (organization_id,
129: locking_process_id,
130: locked_process_id,
131: LAST_UPDATE_DATE,

Line 210: delete from amw_process_locks

206:
207: -- release locks
208: approv_choice := amw_utility_pvt.get_parameter(p_org_id, 'PROCESS_APPROVAL_OPTION' );
209:
210: delete from amw_process_locks
211: where organization_id = p_org_id
212: and locking_process_id = p_process_id;
213:
214: update amw_process_organization

Line 354: delete from amw_process_locks

350: where process_id = p_process_id
351: and organization_id = p_org_id
352: and end_date is null;
353:
354: delete from amw_process_locks
355: where organization_id = p_org_id
356: and locking_process_id = p_process_id;
357:
358: end reject;