eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_PROC_APPROVAL_PKG dependencies on AMW_PROCESS

Line 30: update amw_process

26: -- does not have any approved revision.
27: prod_err_unapr_obj_ass_ex (p_process_id, approv_choice, 'Y', dummy1, dummy2);
28:
29: -- assuming that the process is in Draft status, otherwise you can't submit it for approval.
30: update amw_process
31: set approval_status = 'PA'
32: where process_id = p_process_id
33: and end_date is null;
34:

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 133: -- process approved: update amw_process, change status to A

129:
130: end sub_for_approval;
131:
132:
133: -- process approved: update amw_process, change status to A
134: -- unlock process(es)
135: -- write into amw_approved_hierarchy
136: -- update the association_tables
137: -- update amw_proc_hierarchy_denorm table where hierarchy_type = 'A'

Line 155: amw_process ap

151: and hierarchy_type = 'L';
152: */
153: select ah.parent_child_id
154: from amw_proc_hierarchy_denorm ah,
155: amw_process ap
156: where ah.process_id = p_process_id
157: and ah.up_down_ind = 'D'
158: and ah.hierarchy_type = 'L'
159: and ah.parent_child_id = ap.process_id

Line 171: from amw_process

167: APPROV_TXN_DATE := sysdate;
168: -- check if the process is already approved, in that case, return
169: select approval_status
170: into curr_app_status
171: from amw_process
172: where process_id = p_process_id
173: and end_date is null;
174:
175: if curr_app_status = 'A' then

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 187: update amw_process

183: delete from amw_process_locks
184: where organization_id = -1
185: and locking_process_id = p_process_id;
186:
187: update amw_process
188: set approval_status = 'A',
189: approval_date = APPROV_TXN_DATE
190: where process_id = p_process_id
191: and end_date is null

Line 195: update amw_process

191: and end_date is null
192: returning revision_number into rev_num;
193:
194: if rev_num > 1 then
195: update amw_process
196: set approval_end_date = APPROV_TXN_DATE
197: where process_id = p_process_id
198: and revision_number = (rev_num-1);
199: end if;

Line 212: update amw_process

208: if (approv_choice = 'B') then
209:
210: for c1_rec in c1(p_process_id) loop
211: exit when c1%notfound;
212: update amw_process
213: set approval_status = 'A',
214: approval_date = APPROV_TXN_DATE
215: where process_id = c1_rec.parent_child_id
216: and end_date is null

Line 220: update amw_process

216: and end_date is null
217: returning revision_number into rev_num;
218:
219: if rev_num > 1 then
220: update amw_process
221: set approval_end_date = APPROV_TXN_DATE
222: where process_id = c1_rec.parent_child_id
223: and revision_number = (rev_num-1);
224: end if;

Line 246: update amw_process

242: -- change status D and unlock
243: procedure reject (p_process_id in number) is
244:
245: begin
246: update amw_process
247: set approval_status = 'D'
248: where process_id = p_process_id
249: and end_date is null;
250:

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 270: from amw_proc_hierarchy_denorm d, amw_process a

266:
267: begin
268: select 1 --parent_child_id, a.approval_status
269: into l_dummy
270: from amw_proc_hierarchy_denorm d, amw_process a
271: where d.process_id = p_process_id
272: and up_down_ind = 'D'
273: and hierarchy_type = 'L'
274: and a.process_id = d.parent_child_id

Line 760: from amw_proc_hierarchy_denorm d, amw_process a

756: p_out_mesg := null;
757: begin
758: select 1 --parent_child_id, a.approval_status
759: into l_dummy
760: from amw_proc_hierarchy_denorm d, amw_process a
761: where d.process_id = p_process_id
762: and up_down_ind = 'D'
763: and hierarchy_type = 'L'
764: and a.process_id = d.parent_child_id

Line 909: from amw_process a, amw_process b

905: begin
906:
907: select a.standard_process_flag, b.process_id
908: into std_process, st_var_pid
909: from amw_process a, amw_process b
910: where a.process_id = process_list_rec.parent_child_id
911: and a.end_date is null
912: and b.process_rev_id = a.standard_variation;
913:

Line 923: from amw_process

919: if std_process = 'N' then -- if process is non-standard
920: begin
921: select 1
922: into l_dummy
923: from amw_process
924: where process_id = st_var_pid
925: and approval_status = 'A';
926:
927: exception

Line 944: from amw_process a, amw_process b

940: else
941: begin
942: select a.standard_process_flag, b.process_id
943: into std_process, st_var_pid
944: from amw_process a, amw_process b
945: where a.process_id = p_process_id
946: and a.end_date is null
947: and b.process_rev_id = a.standard_variation;
948: exception

Line 958: from amw_process

954:
955: begin
956: select 1
957: into l_dummy
958: from amw_process
959: where process_id = st_var_pid
960: and approval_status = 'A';
961:
962: exception

Line 995: l_std_variation amw_process.STANDARD_VARIATION%TYPE;

991: union
992: select pid from dual;
993:
994: std_process varchar2(1);
995: l_std_variation amw_process.STANDARD_VARIATION%TYPE;
996: l_dummy number;
997:
998: begin
999: -- standard variation treatment

Line 1007: from amw_process

1003: for process_list_rec in process_list(p_process_id) loop
1004:
1005: select standard_process_flag,standard_variation
1006: into std_process,l_std_variation
1007: from amw_process
1008: where process_id = process_list_rec.parent_child_id
1009: and end_date is null;
1010:
1011: if std_process = 'N' and l_std_variation is not null then

Line 1025: from amw_process

1021: (select NON_STD_CHILD_ID
1022: from AMW_NONSTANDARD_VARIATIONS_B
1023: where NON_STD_PROCESS_ID = process_list_rec.parent_child_id
1024: and NON_STD_PROCESS_REV_NUM = (select revision_number
1025: from amw_process
1026: where process_id = process_list_rec.parent_child_id
1027: and end_date is null)
1028: and END_DATE is null);
1029:

Line 1052: from amw_process

1048: into l_dummy
1049: from AMW_NONSTANDARD_VARIATIONS_B
1050: where NON_STD_PROCESS_ID = process_list_rec.parent_child_id
1051: and NON_STD_PROCESS_REV_NUM = (select revision_number
1052: from amw_process
1053: where process_id = process_list_rec.parent_child_id
1054: and end_date is null)
1055: and END_DATE is null
1056: and NON_STD_CHILD_ID not in

Line 1085: from amw_process

1081: end loop;
1082: else
1083: select standard_process_flag,standard_variation
1084: into std_process,l_std_variation
1085: from amw_process
1086: where process_id = p_process_id
1087: and end_date is null;
1088:
1089: if std_process = 'N' and l_std_variation is not null then

Line 1103: from amw_process

1099: (select NON_STD_CHILD_ID
1100: from AMW_NONSTANDARD_VARIATIONS_B
1101: where NON_STD_PROCESS_ID = p_process_id
1102: and NON_STD_PROCESS_REV_NUM = (select revision_number
1103: from amw_process
1104: where process_id = p_process_id
1105: and end_date is null)
1106: and END_DATE is null);
1107:

Line 1130: from amw_process

1126: into l_dummy
1127: from AMW_NONSTANDARD_VARIATIONS_B
1128: where NON_STD_PROCESS_ID = p_process_id
1129: and NON_STD_PROCESS_REV_NUM = (select revision_number
1130: from amw_process
1131: where process_id = p_process_id
1132: and end_date is null)
1133: and END_DATE is null
1134: and NON_STD_CHILD_ID not in

Line 1193: from amw_process

1189: APPROV_TXN_DATE := sysdate;
1190: -- check if the process is already approved, in that case, return
1191: select approval_status
1192: into curr_app_status
1193: from amw_process
1194: where process_id = p_process_id
1195: and end_date is null;
1196:
1197: if curr_app_status = 'A' then

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:

Line 1207: update amw_process

1203: where organization_id = -1
1204: and locking_process_id = p_process_id;
1205: **/
1206:
1207: update amw_process
1208: set approval_status = 'A',
1209: approval_date = APPROV_TXN_DATE
1210: where process_id = p_process_id
1211: and end_date is null

Line 1215: update amw_process

1211: and end_date is null
1212: returning revision_number into rev_num;
1213:
1214: if rev_num > 1 then
1215: update amw_process
1216: set approval_end_date = APPROV_TXN_DATE
1217: where process_id = p_process_id
1218: and revision_number = (rev_num-1);
1219: end if;

Line 1233: update amw_process

1229:
1230: if (p_approv_choice = 'B') then
1231: for c1_rec in c1(p_process_id) loop
1232: exit when c1%notfound;
1233: update amw_process
1234: set approval_status = 'A',
1235: approval_date = APPROV_TXN_DATE
1236: where process_id = c1_rec.parent_child_id
1237: and end_date is null

Line 1241: update amw_process

1237: and end_date is null
1238: returning revision_number into rev_num;
1239:
1240: if rev_num > 1 then
1241: update amw_process
1242: set approval_end_date = APPROV_TXN_DATE
1243: where process_id = c1_rec.parent_child_id
1244: and revision_number = (rev_num-1);
1245: end if;