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.PA_COST_PLUS dependencies on PA_IND_COMPILED_SETS

Line 131: compiled_set_id pa_ind_compiled_sets.ind_compiled_set_id%TYPE;

127: ind_cost_multiplier pa_ind_cost_multipliers.multiplier%TYPE;
128: old_cost_base pa_cost_bases.cost_base%TYPE DEFAULT NULL;
129: old_precedence pa_cost_base_cost_codes.precedence%TYPE DEFAULT NULL;
130: ind_cost_multiplier_sum pa_ind_cost_multipliers.multiplier%TYPE;
131: compiled_set_id pa_ind_compiled_sets.ind_compiled_set_id%TYPE;
132: org_override NUMBER(15) DEFAULT 0;
133: l_start_date DATE;
134: l_end_date DATE;
135: l_org_override NUMBER(15) DEFAULT 0; /*2933915*/

Line 258: INDEX(ics PA_IND_COMPILED_SETS_N1) */

254: --
255:
256: SELECT /*+ ORDERED
257: INDEX(ose PER_ORG_STRUCTURE_ELEMENTS_FK4)
258: INDEX(ics PA_IND_COMPILED_SETS_N1) */
259: ics.ind_compiled_set_id
260: INTO compiled_set_id
261: FROM per_org_structure_elements ose,
262: pa_ind_compiled_sets ics

Line 262: pa_ind_compiled_sets ics

258: INDEX(ics PA_IND_COMPILED_SETS_N1) */
259: ics.ind_compiled_set_id
260: INTO compiled_set_id
261: FROM per_org_structure_elements ose,
262: pa_ind_compiled_sets ics
263: WHERE ose.organization_id_child = org_id
264: AND ose.org_structure_version_id = org_struc_ver_id
265: AND ose.organization_id_parent = ics.organization_id
266: AND ics.ind_rate_sch_revision_id = rate_sch_rev_id

Line 276: INSERT INTO pa_ind_compiled_sets

272: --
273: -- Add the set id information to this organization
274: --
275: /*S.O. 4888548
276: INSERT INTO pa_ind_compiled_sets
277: (ind_compiled_set_id,
278: ind_rate_sch_revision_id,
279: organization_id,
280: cost_base, /*2933915*

Line 310: INSERT INTO pa_ind_compiled_sets

306: 'A');
307: E.O. 4888548 */
308:
309: /*S.N. 4888548 */
310: INSERT INTO pa_ind_compiled_sets
311: (ind_compiled_set_id,
312: ind_rate_sch_revision_id,
313: organization_id,
314: cost_base,

Line 343: ( SELECT 1 from pa_ind_compiled_sets ics

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
346: AND ics.cost_base = G_IMPACTED_COST_BASES_TAB(i)
347: AND ics.status='A'

Line 406: pa_ind_compiled_sets ics

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
407: WHERE icm.ind_rate_sch_revision_id =ics.ind_rate_sch_revision_id
408: AND icm.ind_rate_sch_revision_id = rate_sch_rev_id
409: AND icm.organization_id =ics.organization_id
410: AND icm.organization_id = org_id

Line 447: SELECT pa_ind_compiled_sets_s.NEXTVAL into compiled_set_id FROM sys.dual;

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:

Line 643: INSERT INTO pa_ind_compiled_sets

639:
640: IF (old_cost_base is NULL) OR (icc_row.cost_base <> old_cost_base) THEN /*Bug 2933915*/
641:
642: /*S.N. 4888548
643: INSERT INTO pa_ind_compiled_sets
644: (ind_compiled_set_id,
645: ind_rate_sch_revision_id,
646: organization_id,
647: cost_base, /*Bug# 2933915

Line 677: INSERT INTO pa_ind_compiled_sets

673: );
674: E.O. 4888548 */
675:
676: /*S.N. 4888548 */
677: INSERT INTO pa_ind_compiled_sets
678: (ind_compiled_set_id,
679: ind_rate_sch_revision_id,
680: organization_id,
681: cost_base,

Line 709: ( SELECT 1 from pa_ind_compiled_sets ics

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
712: AND ics.cost_base =icc_row.cost_base
713: AND ics.status='A'

Line 924: FROM pa_ind_compiled_sets cmp

920: */
921:
922: CURSOR rev_org_cursor(p_rev_id IN NUMBER, p_org_id IN NUMBER) IS /* p_org_id added for 3033195 */
923: SELECT '1'
924: FROM pa_ind_compiled_sets cmp
925: WHERE cmp.organization_id = p_org_id
926: AND cmp.ind_rate_sch_revision_id = p_rev_id
927: AND status = 'A';
928:

Line 1136: INDEX(ics PA_IND_COMPILED_SETS_N1)

1132: */
1133: /*Bug# 1851731:
1134: SELECT + ORDERED
1135: INDEX(ose PER_ORG_STRUCTURE_ELEMENTS_FK4)
1136: INDEX(ics PA_IND_COMPILED_SETS_N1)
1137: ics.ind_compiled_set_id
1138: INTO l_compiled_set_id
1139: FROM per_org_structure_elements ose,
1140: pa_ind_compiled_sets ics

Line 1140: pa_ind_compiled_sets ics

1136: INDEX(ics PA_IND_COMPILED_SETS_N1)
1137: ics.ind_compiled_set_id
1138: INTO l_compiled_set_id
1139: FROM per_org_structure_elements ose,
1140: pa_ind_compiled_sets ics
1141: WHERE ose.organization_id_child = l_org_id
1142: AND ose.org_structure_version_id = l_org_struc_ver_id
1143: AND ose.organization_id_parent = ics.organization_id
1144: AND ics.ind_rate_sch_revision_id = rev_row.ind_rate_sch_revision_id

Line 1151: /* Bug# 1851731 : INSERT INTO pa_ind_compiled_sets

1147: /*
1148: * Insert compiled set information
1149: */
1150:
1151: /* Bug# 1851731 : INSERT INTO pa_ind_compiled_sets
1152: (ind_compiled_set_id,
1153: ind_rate_sch_revision_id,
1154: organization_id,
1155: last_update_date,

Line 1326: from pa_ind_compiled_sets

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
1329: and cost_base = base_rec.cost_base
1330: and status ='A');

Line 1441: FROM pa_ind_compiled_sets

1437: --
1438: DELETE pa_compiled_multipliers
1439: WHERE ind_compiled_set_id IN
1440: (SELECT ind_compiled_set_id
1441: FROM pa_ind_compiled_sets
1442: WHERE ind_rate_sch_revision_id = rate_sch_rev_id);
1443:
1444: DELETE pa_ind_compiled_sets
1445: WHERE ind_rate_sch_revision_id = rate_sch_rev_id;

Line 1444: DELETE pa_ind_compiled_sets

1440: (SELECT ind_compiled_set_id
1441: FROM pa_ind_compiled_sets
1442: WHERE ind_rate_sch_revision_id = rate_sch_rev_id);
1443:
1444: DELETE pa_ind_compiled_sets
1445: WHERE ind_rate_sch_revision_id = rate_sch_rev_id;
1446: ***************************************************************************************/
1447: /*4642011
1448: else

Line 1886: FROM pa_ind_compiled_sets

1882: --
1883:
1884: SELECT ind_compiled_set_id
1885: INTO compiled_set_id
1886: FROM pa_ind_compiled_sets
1887: WHERE ind_rate_sch_revision_id = rate_sch_rev_id
1888: AND organization_id = org_id
1889: AND cost_base = c_base /*Bug# 2933915*/
1890: AND STATUS = 'A';

Line 2406: FROM pa_ind_compiled_sets ics,

2402: -- functional currency
2403: --
2404: SELECT SUM(PA_CURRENCY.ROUND_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier)))
2405: into indirect_cost_sum
2406: FROM pa_ind_compiled_sets ics,
2407: pa_compiled_multipliers icpm
2408: WHERE
2409: ics.ind_rate_sch_revision_id = rate_sch_rev_id
2410: AND ics.organization_id = org_id

Line 2482: -- FROM pa_ind_compiled_sets ics,

2478: -- into indirect_cost_sum,
2479: -- indirect_cost_denom_sum,
2480: -- indirect_cost_acct_sum,
2481: -- indirect_cost_project_sum
2482: -- FROM pa_ind_compiled_sets ics,
2483: -- pa_compiled_multipliers icpm
2484: -- WHERE
2485: -- ics.ind_rate_sch_revision_id = rate_sch_rev_id
2486: -- AND ics.organization_id = org_id

Line 2504: FROM pa_ind_compiled_sets ics,

2500: into indirect_cost_sum,
2501: indirect_cost_denom_sum,
2502: indirect_cost_acct_sum,
2503: indirect_cost_project_sum
2504: FROM pa_ind_compiled_sets ics,
2505: pa_compiled_multipliers icpm
2506: WHERE
2507: ics.ind_rate_sch_revision_id = rate_sch_rev_id
2508: AND ics.organization_id = org_id

Line 3624: FROM pa_ind_compiled_sets ics

3620: stage := 100;
3621:
3622: SELECT ics.ind_compiled_set_id
3623: INTO compiled_set_id
3624: FROM pa_ind_compiled_sets ics
3625: WHERE ics.ind_rate_sch_revision_id = rate_sch_rev_id
3626: AND ics.organization_id = org_id
3627: AND cost_base =c_base /*2933915*/
3628: AND ics.status = 'A';

Line 3797: -- (SELECT 1 FROM pa_ind_compiled_sets ICS, /* Removed Hint NO_INDEX(ITEM PA_EXPENDITURE_ITEMS_N13) */

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
3801: -- AND ( (ICS.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)

Line 3810: FROM PA_IND_COMPILED_SETS ICS

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
3812: AND EXISTS
3813: (SELECT ITEM.COST_IND_COMPILED_SET_ID
3814: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

Line 4101: FROM pa_ind_compiled_sets

4097: /****2933915 :Modified this cursor
4098: CURSOR cs1_cursor
4099: IS
4100: SELECT DISTINCT ind_compiled_set_id
4101: FROM pa_ind_compiled_sets
4102: WHERE ind_rate_sch_revision_id = rate_sch_rev_id
4103: AND status = 'H';
4104: *************************************************/
4105:

Line 4109: FROM pa_ind_compiled_sets ICS

4105:
4106: CURSOR cs1_cursor(c_base VARCHAR2)
4107: IS
4108: SELECT DISTINCT ICS.ind_compiled_set_id
4109: FROM pa_ind_compiled_sets ICS
4110: WHERE ICS.ind_rate_sch_revision_id = rate_sch_rev_id
4111: AND ICS.cost_base = c_base
4112: AND ICS.status = 'H';
4113:

Line 4123: pa_ind_compiled_sets ics

4119: SELECT /*+ ORDERED
4120: INDEX(irsr PA_IND_RATE_SCH_REVISIONS_N1) */
4121: DISTINCT ics.ind_compiled_set_id
4122: FROM pa_ind_rate_sch_revisions irsr,
4123: pa_ind_compiled_sets ics
4124: WHERE ics.status = 'A'
4125: AND ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
4126: AND irsr.ind_rate_sch_id = sch_id
4127: AND irsr.start_date_active < l_start_date

Line 4135: pa_ind_compiled_sets ics

4131: IS
4132: SELECT /*+ ORDERED */
4133: DISTINCT ics.ind_compiled_set_id
4134: FROM pa_ind_rate_sch_revisions irsr,
4135: pa_ind_compiled_sets ics
4136: WHERE ics.status = 'A'
4137: AND ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
4138: AND irsr.actual_sch_revision_id = rate_sch_rev_id;
4139:

Line 4328: ,pa_ind_compiled_sets ics

4324: are defined for an org for all the cost codes */
4325: /* 4527736
4326: AND exists (SELECT NULL
4327: FROM pa_expenditures_all exp
4328: ,pa_ind_compiled_sets ics
4329: WHERE exp.expenditure_id = ITEM.expenditure_id
4330: AND ((ics.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)
4331: or (ics.ind_compiled_set_id = ITEM.tp_ind_compiled_set_id))
4332: AND nvl(ITEM.override_to_organization_id,exp.incurred_by_organization_id) =ics.organization_id

Line 4340: ,PA_IND_COMPILED_SETS ICS

4336: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 -- Bug# 3134445 and Bug 3938479
4337: ) */
4338: AND EXISTS ((SELECT NULL
4339: FROM PA_EXPENDITURES_ALL EXP
4340: ,PA_IND_COMPILED_SETS ICS
4341: WHERE EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID
4342: AND (ICS.IND_COMPILED_SET_ID = ITEM.COST_IND_COMPILED_SET_ID)
4343: AND NVL(ITEM.OVERRIDE_TO_ORGANIZATION_ID, EXP.INCURRED_BY_ORGANIZATION_ID) =ICS.ORGANIZATION_ID
4344: AND ICS.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id /* Added for Bug 5683523 */

Line 4352: ,PA_IND_COMPILED_SETS ICS

4348: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
4349: )
4350: UNION ALL (SELECT NULL
4351: FROM PA_EXPENDITURES_ALL EXP
4352: ,PA_IND_COMPILED_SETS ICS
4353: WHERE EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID
4354: AND (ICS.IND_COMPILED_SET_ID = ITEM.TP_IND_COMPILED_SET_ID)
4355: AND NVL(ITEM.OVERRIDE_TO_ORGANIZATION_ID, EXP.INCURRED_BY_ORGANIZATION_ID) =ICS.ORGANIZATION_ID
4356: AND ICS.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id /* Added for Bug 5683523 */

Line 4540: ,pa_ind_compiled_sets ics

4536: )
4537: /*Bug# 3055700 ::Added this exist clause back for bug# 3016281*/
4538: AND exists (SELECT NULL
4539: FROM pa_expenditures_all exp
4540: ,pa_ind_compiled_sets ics
4541: WHERE exp.expenditure_id = ITEM.expenditure_id
4542: AND ((ics.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)
4543: or (ics.ind_compiled_set_id = ITEM.tp_ind_compiled_set_id))
4544: AND nvl(ITEM.override_to_organization_id,exp.incurred_by_organization_id) =ics.organization_id

Line 4628: AND EXISTS (SELECT /+ index(ics PA_IND_COMPILED_SETS_N6) / NULL /Added index hint for Bug 5683523 /

4624: and cbet.cost_base_type = INDIRECT_COST_CODE
4625: and cbet.expenditure_type = ITEM.expenditure_type
4626: )
4627: /*Bug# 3055700 : Added this exist clause back for bug# 3016281*/
4628: AND EXISTS (SELECT /*+ index(ics PA_IND_COMPILED_SETS_N6) */ NULL /*Added index hint for Bug 5683523 */
4629: FROM pa_expenditures_all exp
4630: ,pa_ind_compiled_sets ics
4631: WHERE exp.expenditure_id = ITEM.expenditure_id
4632: AND ((ics.ind_compiled_set_id = ITEM.rev_ind_compiled_set_id)

Line 4630: ,pa_ind_compiled_sets ics

4626: )
4627: /*Bug# 3055700 : Added this exist clause back for bug# 3016281*/
4628: AND EXISTS (SELECT /*+ index(ics PA_IND_COMPILED_SETS_N6) */ NULL /*Added index hint for Bug 5683523 */
4629: FROM pa_expenditures_all exp
4630: ,pa_ind_compiled_sets ics
4631: WHERE exp.expenditure_id = ITEM.expenditure_id
4632: AND ((ics.ind_compiled_set_id = ITEM.rev_ind_compiled_set_id)
4633: or (ics.ind_compiled_set_id = ITEM.inv_ind_compiled_set_id))
4634: AND nvl(ITEM.override_to_organization_id,exp.incurred_by_organization_id) =ics.organization_id

Line 6819: UPDATE pa_ind_compiled_sets

6815: IF G_IMPACTED_COST_BASES_TAB.COUNT <> 0 THEN /*4590268*/
6816:
6817: FOR i IN G_IMPACTED_COST_BASES_TAB.FIRST .. G_IMPACTED_COST_BASES_TAB.LAST
6818: LOOP
6819: UPDATE pa_ind_compiled_sets
6820: SET status = 'H',
6821: last_update_date = SYSDATE,
6822: last_updated_by = x_last_updated_by,
6823: last_update_login = x_last_update_login,

Line 6895: UPDATE pa_ind_compiled_sets

6891: --
6892: -- Set the compiled set to history
6893: --
6894:
6895: UPDATE pa_ind_compiled_sets
6896: SET status = 'H',
6897: last_update_date = SYSDATE,
6898: last_updated_by = x_last_updated_by,
6899: last_update_login = x_last_update_login,

Line 7101: from pa_ind_compiled_sets

7097:
7098: begin
7099: select ind_compiled_set_id
7100: into x_ind_compiled_set_id
7101: from pa_ind_compiled_sets
7102: where ind_rate_sch_revision_id = x_rate_sch_rev_id
7103: and organization_id = x_organization_id
7104: and status = 'A';
7105:

Line 7174: FROM pa_ind_compiled_sets ics,

7170: P_stage := 100;
7171:
7172: SELECT SUM(icpm.compiled_multiplier)
7173: INTO P_Compiled_multiplier
7174: FROM pa_ind_compiled_sets ics,
7175: pa_compiled_multipliers icpm
7176: WHERE ics.ind_rate_sch_revision_id = P_Rate_sch_rev_id
7177: AND ics.organization_id = P_Org_id
7178: AND ics.status = 'A'

Line 7265: FROM pa_ind_compiled_sets

7261:
7262: DELETE pa_compiled_multipliers
7263: WHERE ind_compiled_set_id IN
7264: (SELECT ind_compiled_set_id
7265: FROM pa_ind_compiled_sets
7266: WHERE ind_rate_sch_revision_id = rate_sch_rev_id
7267: and organization_id = ORG_REC.org_id_child
7268: and cost_base = cost_base_rec.cost_base) ;
7269:

Line 7273: DELETE pa_ind_compiled_sets

7269:
7270: E.N. Bug 3946409 */
7271:
7272: /* Bug# 4527736
7273: DELETE pa_ind_compiled_sets
7274: WHERE ind_rate_sch_revision_id = rate_sch_rev_id
7275: and organization_id =ORG_REC.org_id_child
7276: and cost_base =G_IMPACTED_COST_BASES_TAB(i)
7277: Bug# 4527736 */

Line 7463: pa_ind_compiled_sets ics

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
7465: and icm.ind_rate_sch_revision_id = rate_sch_rev_id
7466: AND icm.organization_id =ics.organization_id
7467: and icm.organization_id = org_id

Line 7483: pa_ind_compiled_sets ics

7479: where exists
7480: (
7481: select 1
7482: from pa_ind_cost_multipliers icm ,
7483: pa_ind_compiled_sets ics
7484: where icm.ind_rate_sch_revision_id =ics.ind_rate_sch_revision_id
7485: and icm.ind_rate_sch_revision_id = rate_sch_rev_id
7486: and icm.organization_id =ics.organization_id
7487: and icm.organization_id = org_id