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_WF_HIERARCHY_PKG dependencies on STANDARD

Line 51: p_STANDARD_PROCESS_FLAG IN VARCHAR2,

47:
48: procedure write_amw_process (
49: p_process_name IN VARCHAR2,
50: p_SIGNIFICANT_PROCESS_FLAG IN VARCHAR2,
51: p_STANDARD_PROCESS_FLAG IN VARCHAR2,
52: p_APPROVAL_STATUS IN VARCHAR2,
53: p_CERTIFICATION_STATUS IN VARCHAR2,
54: p_PROCESS_OWNER_ID IN NUMBER,
55: p_PROCESS_CATEGORY IN VARCHAR2,

Line 252: STANDARD_PROCESS_FLAG,

248: FORALL v_ind IN 1..final_row_cnt
249: INSERT INTO amw_process( PROCESS_REV_ID,
250: PROCESS_ID,
251: SIGNIFICANT_PROCESS_FLAG,
252: STANDARD_PROCESS_FLAG,
253: APPROVAL_STATUS,
254: CERTIFICATION_STATUS,
255: PROCESS_OWNER_ID,
256: PROCESS_CATEGORY,

Line 2941: (select process_id from amw_process where standard_process_flag = 'Y');

2937: select exception_id
2938: from amw_exceptions_b
2939: where object_type = 'PROCESS_VARIANT_ADD'
2940: and new_pk1 not in
2941: (select process_id from amw_process where standard_process_flag = 'Y');
2942:
2943: l_ex_id number;
2944: hvalue number;
2945: v_inner_index number;

Line 3168: -- nullify the standard variations that have been deleted

3164: --v_amwp_name_pid.delete;
3165: v_amwp_name.trim;
3166: v_amwp_pid.trim;
3167:
3168: -- nullify the standard variations that have been deleted
3169: update amw_process ap1
3170: set ap1.standard_variation =
3171: (select ap2.process_id from amw_process ap2 where ap2.process_id = ap1.standard_variation);
3172:

Line 3170: set ap1.standard_variation =

3166: v_amwp_pid.trim;
3167:
3168: -- nullify the standard variations that have been deleted
3169: update amw_process ap1
3170: set ap1.standard_variation =
3171: (select ap2.process_id from amw_process ap2 where ap2.process_id = ap1.standard_variation);
3172:
3173: -- delete the corresponding variation exceptions created for them.
3174: open exceptions_to_be_del;

Line 3171: (select ap2.process_id from amw_process ap2 where ap2.process_id = ap1.standard_variation);

3167:
3168: -- nullify the standard variations that have been deleted
3169: update amw_process ap1
3170: set ap1.standard_variation =
3171: (select ap2.process_id from amw_process ap2 where ap2.process_id = ap1.standard_variation);
3172:
3173: -- delete the corresponding variation exceptions created for them.
3174: open exceptions_to_be_del;
3175: loop

Line 3282: (select process_id from amw_process where standard_process_flag = 'Y');

3278: select exception_id
3279: from amw_exceptions_b
3280: where object_type = 'PROCESS_VARIANT_ADD'
3281: and new_pk1 not in
3282: (select process_id from amw_process where standard_process_flag = 'Y');
3283:
3284: l_ex_id number;
3285: hvalue number;
3286: v_inner_index number;

Line 3421: -- nullify the standard variations that have been deleted

3417: --v_amwp_name_pid.delete;
3418: v_amwp_name.trim;
3419: v_amwp_pid.trim;
3420:
3421: -- nullify the standard variations that have been deleted
3422: update amw_process ap1
3423: set ap1.standard_variation =
3424: (select ap2.process_id from amw_process ap2 where ap2.process_id = ap1.standard_variation);
3425:

Line 3423: set ap1.standard_variation =

3419: v_amwp_pid.trim;
3420:
3421: -- nullify the standard variations that have been deleted
3422: update amw_process ap1
3423: set ap1.standard_variation =
3424: (select ap2.process_id from amw_process ap2 where ap2.process_id = ap1.standard_variation);
3425:
3426: -- delete the corresponding variation exceptions created for them.
3427: open exceptions_to_be_del;

Line 3424: (select ap2.process_id from amw_process ap2 where ap2.process_id = ap1.standard_variation);

3420:
3421: -- nullify the standard variations that have been deleted
3422: update amw_process ap1
3423: set ap1.standard_variation =
3424: (select ap2.process_id from amw_process ap2 where ap2.process_id = ap1.standard_variation);
3425:
3426: -- delete the corresponding variation exceptions created for them.
3427: open exceptions_to_be_del;
3428: loop