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.ZPB_AC_OPS dependencies on ZPB_ANALYSIS_CYCLE_TASKS

Line 31: zpb_analysis_cycle_tasks t,

27: CURSOR c_active_instance IS
28: SELECT zaci.instance_ac_id, zac.current_instance_id, t.wf_process_name, t.item_key, t.task_id
29: FROM ZPB_ANALYSIS_CYCLE_INSTANCES zaci,
30: ZPB_ANALYSIS_CYCLES zac,
31: zpb_analysis_cycle_tasks t,
32: ZPB_ANALYSIS_CYCLES publishedac
33: WHERE publishedac.analysis_cycle_id = p_acid and
34: publishedac.current_instance_id=zac.current_instance_id and
35: zaci.instance_ac_id = zac.analysis_cycle_id and

Line 105: update zpb_analysis_cycle_tasks

101: l_REQID := FND_REQUEST.SUBMIT_REQUEST ('ZPB', 'ZPB_WF_DELAWINST', NULL, NULL, FALSE, l_instanceID, l_ownerid, l_business_area_id);
102:
103: -- now that the instance has been cleaned, set its last task to completed
104: -- in order to allow cleaning of the current instance of the BP
105: update zpb_analysis_cycle_tasks
106: set status_code='COMPLETE'
107: where task_id = v_active_instance.task_id;
108:
109: if l_REQID <= 0 then

Line 451: source_task_id_in IN zpb_analysis_cycle_tasks.task_id%TYPE,

447: END copy_cycle_comments_recs;
448:
449:
450: PROCEDURE copy_task_param_recs (
451: source_task_id_in IN zpb_analysis_cycle_tasks.task_id%TYPE,
452: target_task_id_in IN zpb_analysis_cycle_tasks.task_id%TYPE)
453: IS
454: BEGIN
455: INSERT INTO zpb_task_parameters

Line 452: target_task_id_in IN zpb_analysis_cycle_tasks.task_id%TYPE)

448:
449:
450: PROCEDURE copy_task_param_recs (
451: source_task_id_in IN zpb_analysis_cycle_tasks.task_id%TYPE,
452: target_task_id_in IN zpb_analysis_cycle_tasks.task_id%TYPE)
453: IS
454: BEGIN
455: INSERT INTO zpb_task_parameters
456: ( NAME,

Line 491: FROM zpb_analysis_cycle_tasks

487: is_anal_excep_copied IN boolean default true)
488: IS
489: CURSOR ac_task_cur IS
490: SELECT *
491: FROM zpb_analysis_cycle_tasks
492: WHERE analysis_cycle_id = source_ac_id_in;
493:
494: cursor analy_excep_cur(l_taskId number) is
495: select 1 FROM zpb_task_parameters where name = 'EXCEPTION_TYPE'

Line 498: target_task_id zpb_analysis_cycle_tasks.task_id%TYPE;

494: cursor analy_excep_cur(l_taskId number) is
495: select 1 FROM zpb_task_parameters where name = 'EXCEPTION_TYPE'
496: and value = 'A' and task_id = l_taskId;
497:
498: target_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
499: source_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
500:
501: excep_count number;
502: copy_task boolean :=true;

Line 499: source_task_id zpb_analysis_cycle_tasks.task_id%TYPE;

495: select 1 FROM zpb_task_parameters where name = 'EXCEPTION_TYPE'
496: and value = 'A' and task_id = l_taskId;
497:
498: target_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
499: source_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
500:
501: excep_count number;
502: copy_task boolean :=true;
503: BEGIN

Line 528: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,

524: ac_task_rec.CREATION_DATE := SYSDATE;
525: ac_task_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
526: ac_task_rec.LAST_UPDATE_DATE := SYSDATE;
527: ac_task_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
528: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,
529: TASK_ID,
530: SEQUENCE,
531: TASK_NAME,
532: STATUS_CODE,

Line 964: FROM zpb_analysis_cycle_tasks

960: -- cursor ac_task_cur contains all tasks from source_ac_id_in whose
961: -- corresponding tasks in target_ac_id_in have not yet started
962: CURSOR ac_task_cur IS
963: SELECT *
964: FROM zpb_analysis_cycle_tasks
965: WHERE analysis_cycle_id = source_ac_id_in and
966: sequence >=
967:
968: ((SELECT min(sequence)

Line 969: FROM zpb_analysis_cycle_tasks

965: WHERE analysis_cycle_id = source_ac_id_in and
966: sequence >=
967:
968: ((SELECT min(sequence)
969: FROM zpb_analysis_cycle_tasks
970: WHERE analysis_cycle_id = target_ac_id_in and
971: status_code is null));
972:
973: target_task_id zpb_analysis_cycle_tasks.task_id%TYPE;

Line 973: target_task_id zpb_analysis_cycle_tasks.task_id%TYPE;

969: FROM zpb_analysis_cycle_tasks
970: WHERE analysis_cycle_id = target_ac_id_in and
971: status_code is null));
972:
973: target_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
974: source_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
975: todelete_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
976:
977: BEGIN

Line 974: source_task_id zpb_analysis_cycle_tasks.task_id%TYPE;

970: WHERE analysis_cycle_id = target_ac_id_in and
971: status_code is null));
972:
973: target_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
974: source_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
975: todelete_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
976:
977: BEGIN
978:

Line 975: todelete_task_id zpb_analysis_cycle_tasks.task_id%TYPE;

971: status_code is null));
972:
973: target_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
974: source_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
975: todelete_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
976:
977: BEGIN
978:
979: -- loop over all tasks that need to be updated

Line 986: FROM zpb_analysis_cycle_tasks

982:
983: -- First delete task from target_ac_id_in
984: -- For newly created tasks in the source, no deletion is necessary
985: SELECT task_id into todelete_task_id
986: FROM zpb_analysis_cycle_tasks
987: WHERE analysis_cycle_id = target_ac_id_in and
988: sequence = ac_task_rec.sequence;
989:
990: exception

Line 998: DELETE FROM zpb_analysis_cycle_tasks

994:
995: DELETE FROM zpb_task_parameters
996: WHERE task_id = todelete_task_id;
997:
998: DELETE FROM zpb_analysis_cycle_tasks
999: WHERE task_id = todelete_task_id;
1000:
1001: SELECT zpb_task_id_seq.NEXTVAL INTO target_task_id FROM DUAL;
1002: source_task_id := ac_task_rec.task_id;

Line 1010: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,

1006: ac_task_rec.CREATION_DATE := SYSDATE;
1007: ac_task_rec.LAST_UPDATED_BY := fnd_global.USER_ID;
1008: ac_task_rec.LAST_UPDATE_DATE := SYSDATE;
1009: ac_task_rec.LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1010: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,
1011: TASK_ID,
1012: SEQUENCE,
1013: TASK_NAME,
1014: STATUS_CODE,

Line 1092: FROM zpb_analysis_cycle_tasks

1088: delete_tasks IN VARCHAR2 default FND_API.G_TRUE)
1089: IS
1090: CURSOR ac_task_cur IS
1091: SELECT *
1092: FROM zpb_analysis_cycle_tasks
1093: WHERE analysis_cycle_id = ac_id_in;
1094:
1095: pet_rec zpb_cycle_relationships%ROWTYPE;
1096: delete_task_id zpb_analysis_cycle_tasks.task_id%TYPE;

Line 1096: delete_task_id zpb_analysis_cycle_tasks.task_id%TYPE;

1092: FROM zpb_analysis_cycle_tasks
1093: WHERE analysis_cycle_id = ac_id_in;
1094:
1095: pet_rec zpb_cycle_relationships%ROWTYPE;
1096: delete_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
1097: l_return_status VARCHAR2(1);
1098: l_msg_count NUMBER;
1099: l_msg_data VARCHAR2(2000);
1100: BEGIN

Line 1148: DELETE FROM zpb_analysis_cycle_tasks

1144: DELETE FROM zpb_task_parameters
1145: WHERE task_id = ac_task_rec.task_id;
1146: END LOOP;
1147:
1148: DELETE FROM zpb_analysis_cycle_tasks
1149: WHERE analysis_cycle_id = ac_id_in;
1150: END IF;
1151:
1152: DELETE FROM zpb_business_process_scope

Line 3006: load_task_id zpb_analysis_cycle_tasks.task_id%TYPE;

3002: end create_task_parameters;
3003: procedure create_cycle_load_task( p_ac_id in number,
3004: p_apps_user_id in number) AS
3005:
3006: load_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
3007: task_param_id zpb_task_parameters.param_id%TYPE;
3008: ac_task_rec zpb_analysis_cycle_tasks%rowtype;
3009: begin
3010:

Line 3008: ac_task_rec zpb_analysis_cycle_tasks%rowtype;

3004: p_apps_user_id in number) AS
3005:
3006: load_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
3007: task_param_id zpb_task_parameters.param_id%TYPE;
3008: ac_task_rec zpb_analysis_cycle_tasks%rowtype;
3009: begin
3010:
3011: SELECT zpb_task_id_seq.NEXTVAL INTO load_task_id from dual;
3012:

Line 3025: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,

3021: ac_task_rec.LAST_UPDATED_BY := p_apps_user_id;
3022: ac_task_rec.LAST_UPDATE_DATE := SYSDATE;
3023: ac_task_rec.LAST_UPDATE_LOGIN := p_apps_user_id;
3024:
3025: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,
3026: TASK_ID,
3027: SEQUENCE,
3028: TASK_NAME,
3029: STATUS_CODE,

Line 3072: curinst_task_id zpb_analysis_cycle_tasks.task_id%TYPE;

3068:
3069: procedure create_cycle_curinst_task( p_ac_id in number,
3070: p_apps_user_id in number) AS
3071:
3072: curinst_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
3073: task_param_id zpb_task_parameters.param_id%TYPE;
3074: ac_task_rec zpb_analysis_cycle_tasks%rowtype;
3075: begin
3076:

Line 3074: ac_task_rec zpb_analysis_cycle_tasks%rowtype;

3070: p_apps_user_id in number) AS
3071:
3072: curinst_task_id zpb_analysis_cycle_tasks.task_id%TYPE;
3073: task_param_id zpb_task_parameters.param_id%TYPE;
3074: ac_task_rec zpb_analysis_cycle_tasks%rowtype;
3075: begin
3076:
3077: SELECT zpb_task_id_seq.NEXTVAL INTO curinst_task_id from dual;
3078:

Line 3091: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,

3087: ac_task_rec.LAST_UPDATED_BY := p_apps_user_id;
3088: ac_task_rec.LAST_UPDATE_DATE := SYSDATE;
3089: ac_task_rec.LAST_UPDATE_LOGIN := p_apps_user_id;
3090:
3091: INSERT INTO zpb_analysis_cycle_tasks(ANALYSIS_CYCLE_ID,
3092: TASK_ID,
3093: SEQUENCE,
3094: TASK_NAME,
3095: STATUS_CODE,