APPS.ZPB_AC_OPS dependencies on ZPB_TASK_PARAMETERS

Line 455: INSERT INTO zpb_task_parameters

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,
457: TASK_ID,
458: VALUE,
459: PARAM_ID,

Line 474: FROM zpb_task_parameters

470: SYSDATE,
471: fnd_global.USER_ID,
472: SYSDATE,
473: fnd_global.LOGIN_ID
474: FROM zpb_task_parameters
475: WHERE TASK_ID = source_task_id_in;
476:
477: exception
478: WHEN OTHERS THEN

Line 495: select 1 FROM zpb_task_parameters where name = 'EXCEPTION_TYPE'

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'
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;

Line 995: DELETE FROM zpb_task_parameters

991: when no_data_found then
992: todelete_task_id := null;
993: end;
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;

Line 1144: DELETE FROM zpb_task_parameters

1140:
1141: IF FND_API.To_Boolean(delete_tasks) THEN
1142:
1143: FOR ac_task_rec IN ac_task_cur LOOP
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

Line 2969: ac_task_param_rec zpb_task_parameters%rowtype;

2965: name in varchar2,
2966: value in varchar,
2967: p_apps_user_id in number) AS
2968:
2969: ac_task_param_rec zpb_task_parameters%rowtype;
2970: task_param_id zpb_task_parameters.param_id%type;
2971: begin
2972:
2973: SELECT zpb_task_param_id_seq.NEXTVAL INTO task_param_id FROM DUAL;

Line 2970: task_param_id zpb_task_parameters.param_id%type;

2966: value in varchar,
2967: p_apps_user_id in number) AS
2968:
2969: ac_task_param_rec zpb_task_parameters%rowtype;
2970: task_param_id zpb_task_parameters.param_id%type;
2971: begin
2972:
2973: SELECT zpb_task_param_id_seq.NEXTVAL INTO task_param_id FROM DUAL;
2974:

Line 2984: INSERT INTO zpb_task_parameters(NAME,

2980: ac_task_param_rec.CREATION_DATE := SYSDATE;
2981: ac_task_param_rec.LAST_UPDATED_BY := p_apps_user_id;
2982: ac_task_param_rec.LAST_UPDATE_DATE := SYSDATE;
2983: ac_task_param_rec.LAST_UPDATE_LOGIN := p_apps_user_id;
2984: INSERT INTO zpb_task_parameters(NAME,
2985: TASK_ID,
2986: VALUE,
2987: PARAM_ID,
2988: LAST_UPDATE_LOGIN,

Line 3007: task_param_id zpb_task_parameters.param_id%TYPE;

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:
3011: SELECT zpb_task_id_seq.NEXTVAL INTO load_task_id from dual;

Line 3073: task_param_id zpb_task_parameters.param_id%TYPE;

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:
3077: SELECT zpb_task_id_seq.NEXTVAL INTO curinst_task_id from dual;