[Home] [Help]
216: BEGIN
217: SELECT /*+ FIRST_ROWS */
218: 1
219: INTO org_override
220: FROM sys.dual WHERE EXISTS
221: (SELECT /*+ FIRST_ROWS */
222: 1
223: FROM pa_ind_cost_multipliers
224: WHERE ind_rate_sch_revision_id = rate_sch_rev_id
337: x_program_application_id,
338: x_program_id,
339: SYSDATE,
340: 'A'
341: FROM DUAL
342: WHERE NOT EXISTS
343: ( SELECT 1 from pa_ind_compiled_sets ics
344: WHERE ics.ind_rate_sch_revision_id =rate_sch_rev_id
345: AND ics.organization_id = org_id
398: BEGIN
399: SELECT /*+ FIRST_ROWS */
400: 1
401: INTO l_org_override
402: FROM sys.dual WHERE EXISTS
403: (SELECT /*+ FIRST_ROWS */
404: 1
405: FROM pa_ind_cost_multipliers icm,
406: pa_ind_compiled_sets ics
443: --
444:
445: stage := 200;
446:
447: SELECT pa_ind_compiled_sets_s.NEXTVAL into compiled_set_id FROM sys.dual;
448:
449:
450: SAVEPOINT before_adding_multipliers;
451:
703: x_program_application_id,
704: x_program_id,
705: SYSDATE,
706: 'A'
707: FROM DUAL
708: WHERE NOT EXISTS
709: ( SELECT 1 from pa_ind_compiled_sets ics
710: WHERE ics.ind_rate_sch_revision_id =rate_sch_rev_id
711: AND ics.organization_id = org_id
954: AND org_structure_version_id = ver_id
955: START WITH organization_id_parent = l_org_id
956: AND org_structure_version_id = ver_id
957: UNION ALL
958: SELECT 0,l_org_id organization_id FROM dual
959: ORDER BY 1;
960:
961: BEGIN
962:
1320: FOR base_rec in all_cost_bases
1321: LOOP
1322: select 1
1323: into l_check
1324: from sys.dual
1325: where exists(select 1
1326: from pa_ind_compiled_sets
1327: where ind_rate_sch_revision_id =G_RATE_SCH_REVISION_ID /* 4527736 */
1328: and organization_id =start_org
3792: * also.
3793: */
3794:
3795: --S.O. /*Bug 4527736 */
3796: -- SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
3797: -- (SELECT 1 FROM pa_ind_compiled_sets ICS, /* Removed Hint NO_INDEX(ITEM PA_EXPENDITURE_ITEMS_N13) */
3798: -- pa_expenditure_items_all ITEM
3799: -- WHERE
3800: -- ICS.ind_rate_sch_revision_id = rate_sch_rev_id
3803: -- OR (ICS.ind_compiled_set_id = ITEM.tp_ind_compiled_set_id)
3804: -- OR (ICS.ind_compiled_set_id = ITEM.inv_ind_compiled_set_id)));
3805: --E.O. /*Bug 4527736 */
3806: --S.N. /*Bug 4527736 */
3807: SELECT 1 INTO dummy FROM SYS.DUAL
3808: WHERE NOT EXISTS
3809: (SELECT 1
3810: FROM PA_IND_COMPILED_SETS ICS
3811: WHERE ICS.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id
3962: end if;
3963:
3964:
3965: for icc_row in icc_cursor loop
3966: SELECT pa_cost_base_cost_codes_s.nextval into cbicc_id FROM sys.dual;
3967:
3968: INSERT INTO pa_cost_base_cost_codes
3969: (cost_base_cost_code_id,
3970: cost_plus_structure,
6781: AND org_structure_version_id = ver_id
6782: START WITH organization_id_parent = org_id
6783: AND org_structure_version_id = ver_id
6784: UNION
6785: select org_id from dual ;
6786:
6787: -- Standard who
6788: x_last_updated_by NUMBER(15);
6789: x_last_update_login NUMBER(15);
7245: AND org_structure_version_id = ver_id
7246: START WITH organization_id_parent = org_id
7247: AND org_structure_version_id = ver_id
7248: UNION
7249: select org_id from dual ;
7250:
7251: BEGIN
7252: --
7253: -- Remove redundant compiled sets and multipiers.
7456:
7457: LOOP
7458: BEGIN
7459: select 1 into org_override
7460: from sys.dual
7461: where exists(select 1
7462: from pa_ind_cost_multipliers icm ,
7463: pa_ind_compiled_sets ics
7464: where icm.ind_rate_sch_revision_id =ics.ind_rate_sch_revision_id
7474: EXCEPTION
7475: WHEN NO_DATA_FOUND THEN
7476: BEGIN /* Code change for Bug 4739218 Starts */
7477: select 0 into org_override
7478: from sys.dual
7479: where exists
7480: (
7481: select 1
7482: from pa_ind_cost_multipliers icm ,