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 DUAL

Line 519: SELECT zpb_task_id_seq.NEXTVAL INTO target_task_id FROM DUAL;

515: copy_task := true;
516: end if;
517: if copy_task = true
518: then
519: SELECT zpb_task_id_seq.NEXTVAL INTO target_task_id FROM DUAL;
520: source_task_id := ac_task_rec.task_id;
521: ac_task_rec.analysis_cycle_id := target_ac_id_in;
522: ac_task_rec.task_id := target_task_id;
523: ac_task_rec.CREATED_BY := fnd_global.USER_ID;

Line 1001: SELECT zpb_task_id_seq.NEXTVAL INTO target_task_id FROM DUAL;

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;
1003: ac_task_rec.analysis_cycle_id := target_ac_id_in;
1004: ac_task_rec.task_id := target_task_id;
1005: ac_task_rec.CREATED_BY := fnd_global.USER_ID;

Line 1348: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

1344: comments boolean := true;
1345: analy_excep boolean := true;
1346:
1347: BEGIN
1348: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1349: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
1350: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
1351:
1352: if lower(is_comments_copied) = 'false' then comments := false; end if;

Line 1349: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;

1345: analy_excep boolean := true;
1346:
1347: BEGIN
1348: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1349: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
1350: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
1351:
1352: if lower(is_comments_copied) = 'false' then comments := false; end if;
1353: if lower(is_analy_excep_copied) = 'false' then analy_excep := false; end if;

Line 1350: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;

1346:
1347: BEGIN
1348: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1349: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
1350: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
1351:
1352: if lower(is_comments_copied) = 'false' then comments := false; end if;
1353: if lower(is_analy_excep_copied) = 'false' then analy_excep := false; end if;
1354:

Line 1418: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

1414: INTO pet_row_rec
1415: FROM zpb_cycle_relationships
1416: WHERE published_ac_id = published_ac_id_in;
1417:
1418: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1419:
1420: create_ac_copy(published_ac_id_in, new_ac_id);
1421:
1422: UPDATE zpb_analysis_cycles

Line 1456: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

1452: relationship_id zpb_cycle_relationships.relationship_id%TYPE;
1453: pet_rec zpb_cycle_relationships%ROWTYPE;
1454: ac_rec zpb_analysis_cycles%ROWTYPE;
1455: BEGIN
1456: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1457: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
1458: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
1459:
1460: ac_rec.analysis_cycle_id := new_ac_id;

Line 1457: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;

1453: pet_rec zpb_cycle_relationships%ROWTYPE;
1454: ac_rec zpb_analysis_cycles%ROWTYPE;
1455: BEGIN
1456: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1457: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
1458: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
1459:
1460: ac_rec.analysis_cycle_id := new_ac_id;
1461: ac_rec.name := ac_name_in;

Line 1458: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;

1454: ac_rec zpb_analysis_cycles%ROWTYPE;
1455: BEGIN
1456: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1457: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
1458: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
1459:
1460: ac_rec.analysis_cycle_id := new_ac_id;
1461: ac_rec.name := ac_name_in;
1462: ac_rec.validate_status := 'INVALID';

Line 1570: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

1566: SELECT VALUE FROM ZPB_AC_PARAM_VALUES
1567: WHERE ANALYSIS_CYCLE_ID = ac_id_in AND PARAM_ID = l_appview_param_id ;
1568:
1569: BEGIN
1570: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1571:
1572: create_ac_copy(ac_id_in, new_ac_id);
1573:
1574: SELECT *

Line 1684: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

1680: FROM zpb_cycle_relationships
1681: WHERE editable_ac_id = editable_ac_id_in;
1682:
1683: IF pet_row_rec.tmp_ac_id IS NULL THEN
1684: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
1685: ELSE
1686: delete_ac(pet_row_rec.tmp_ac_id);
1687: new_ac_id := pet_row_rec.tmp_ac_id;
1688: END IF;

Line 2084: -- SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

2080: FROM zpb_cycle_relationships
2081: WHERE editable_ac_id = editable_ac_id_in;
2082:
2083: IF pet_row_rec.published_ac_id IS NULL THEN
2084: -- SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
2085: old_published_ac_id := -1;
2086: published_before := 'N';
2087:
2088: ELSE

Line 2290: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

2286: FROM zpb_cycle_relationships
2287: WHERE tmp_ac_id = tmp_ac_id_in;
2288:
2289: IF pet_row_rec.editable_ac_id IS NULL THEN
2290: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
2291: ELSE
2292: delete_ac(pet_row_rec.editable_ac_id);
2293: new_ac_id := pet_row_rec.editable_ac_id;
2294: END IF;

Line 2725: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

2721: END IF;
2722:
2723: -- Initialize API return status to success
2724: x_return_status := FND_API.G_RET_STS_SUCCESS;
2725: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
2726: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
2727: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
2728:
2729: ac_rec.analysis_cycle_id := new_ac_id;

Line 2726: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;

2722:
2723: -- Initialize API return status to success
2724: x_return_status := FND_API.G_RET_STS_SUCCESS;
2725: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
2726: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
2727: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
2728:
2729: ac_rec.analysis_cycle_id := new_ac_id;
2730: ac_rec.name := p_cycle_name;

Line 2727: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;

2723: -- Initialize API return status to success
2724: x_return_status := FND_API.G_RET_STS_SUCCESS;
2725: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
2726: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO current_inst_id FROM DUAL;
2727: SELECT zpb_relationship_id_seq.NEXTVAL INTO relationship_id FROM DUAL;
2728:
2729: ac_rec.analysis_cycle_id := new_ac_id;
2730: ac_rec.name := p_cycle_name;
2731: ac_rec.description := p_description;

Line 2973: SELECT zpb_task_param_id_seq.NEXTVAL INTO task_param_id FROM DUAL;

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:
2975: ac_task_param_rec.task_id := task_id;
2976: ac_task_param_rec.param_id := task_param_id;
2977: ac_task_param_rec.name := name;

Line 3011: SELECT zpb_task_id_seq.NEXTVAL INTO load_task_id from dual;

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:
3013: ac_task_rec.analysis_cycle_id := p_ac_id;
3014: ac_task_rec.task_id := load_task_id;
3015: ac_task_rec.sequence := 1;

Line 3077: SELECT zpb_task_id_seq.NEXTVAL INTO curinst_task_id from dual;

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:
3079: ac_task_rec.analysis_cycle_id := p_ac_id;
3080: ac_task_rec.task_id := curinst_task_id;
3081: ac_task_rec.sequence := 2;

Line 3171: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;

3167:
3168: -- Initialize API return status to success
3169: x_return_status := FND_API.G_RET_STS_SUCCESS;
3170:
3171: SELECT zpb_analysis_cycle_id_seq.NEXTVAL INTO new_ac_id FROM DUAL;
3172:
3173: copy_ac_table_rec(p_analysis_cycle_id, new_ac_id);
3174: copy_cycle_model_dim_recs(p_analysis_cycle_id, new_ac_id);
3175:

Line 3437: FROM dual;

3433: -- exist already in the table
3434: IF l_hierarchy_exists = 0
3435: THEN
3436: SELECT zpb_solve_hier_order_s.nextval INTO l_solve_hier_order_id
3437: FROM dual;
3438:
3439: IF l_new_dim <> l_prev_dim
3440: THEN
3441: l_order_num := 0;