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 2436: FROM pa_ind_compiled_sets ics,

2432: -- functional currency
2433: --
2434: SELECT SUM(PA_CURRENCY.ROUND_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier)))
2435: into indirect_cost_sum
2436: FROM pa_ind_compiled_sets ics,
2437: pa_compiled_multipliers icpm
2438: WHERE
2439: ics.ind_rate_sch_revision_id = rate_sch_rev_id
2440: AND ics.organization_id = org_id

Line 2512: -- FROM pa_ind_compiled_sets ics,

2508: -- into indirect_cost_sum,
2509: -- indirect_cost_denom_sum,
2510: -- indirect_cost_acct_sum,
2511: -- indirect_cost_project_sum
2512: -- FROM pa_ind_compiled_sets ics,
2513: -- pa_compiled_multipliers icpm
2514: -- WHERE
2515: -- ics.ind_rate_sch_revision_id = rate_sch_rev_id
2516: -- AND ics.organization_id = org_id

Line 2534: FROM pa_ind_compiled_sets ics,

2530: into indirect_cost_sum,
2531: indirect_cost_denom_sum,
2532: indirect_cost_acct_sum,
2533: indirect_cost_project_sum
2534: FROM pa_ind_compiled_sets ics,
2535: pa_compiled_multipliers icpm
2536: WHERE
2537: ics.ind_rate_sch_revision_id = rate_sch_rev_id
2538: AND ics.organization_id = org_id

Line 3654: FROM pa_ind_compiled_sets ics

3650: stage := 100;
3651:
3652: SELECT ics.ind_compiled_set_id
3653: INTO compiled_set_id
3654: FROM pa_ind_compiled_sets ics
3655: WHERE ics.ind_rate_sch_revision_id = rate_sch_rev_id
3656: AND ics.organization_id = org_id
3657: AND cost_base =c_base /*2933915*/
3658: AND ics.status = 'A';

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

3823: */
3824:
3825: --S.O. /*Bug 4527736 */
3826: -- SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
3827: -- (SELECT 1 FROM pa_ind_compiled_sets ICS, /* Removed Hint NO_INDEX(ITEM PA_EXPENDITURE_ITEMS_N13) */
3828: -- pa_expenditure_items_all ITEM
3829: -- WHERE
3830: -- ICS.ind_rate_sch_revision_id = rate_sch_rev_id
3831: -- AND ( (ICS.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)

Line 3840: FROM PA_IND_COMPILED_SETS ICS

3836: --S.N. /*Bug 4527736 */
3837: SELECT 1 INTO dummy FROM SYS.DUAL
3838: WHERE NOT EXISTS
3839: (SELECT 1
3840: FROM PA_IND_COMPILED_SETS ICS
3841: WHERE ICS.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id
3842: AND EXISTS
3843: (SELECT /*+ no_unnest */ ITEM.COST_IND_COMPILED_SET_ID --Bug 12811820
3844: FROM PA_EXPENDITURE_ITEMS_ALL ITEM

Line 4131: FROM pa_ind_compiled_sets

4127: /****2933915 :Modified this cursor
4128: CURSOR cs1_cursor
4129: IS
4130: SELECT DISTINCT ind_compiled_set_id
4131: FROM pa_ind_compiled_sets
4132: WHERE ind_rate_sch_revision_id = rate_sch_rev_id
4133: AND status = 'H';
4134: *************************************************/
4135:

Line 4139: FROM pa_ind_compiled_sets ICS

4135:
4136: CURSOR cs1_cursor(c_base VARCHAR2)
4137: IS
4138: SELECT DISTINCT ICS.ind_compiled_set_id
4139: FROM pa_ind_compiled_sets ICS
4140: WHERE ICS.ind_rate_sch_revision_id = rate_sch_rev_id
4141: AND ICS.cost_base = c_base
4142: AND ICS.status = 'H';
4143:

Line 4153: pa_ind_compiled_sets ics

4149: SELECT /*+ ORDERED
4150: INDEX(irsr PA_IND_RATE_SCH_REVISIONS_N1) */
4151: DISTINCT ics.ind_compiled_set_id
4152: FROM pa_ind_rate_sch_revisions irsr,
4153: pa_ind_compiled_sets ics
4154: WHERE ics.status = 'A'
4155: AND ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
4156: AND irsr.ind_rate_sch_id = sch_id
4157: AND irsr.start_date_active < l_start_date

Line 4165: pa_ind_compiled_sets ics

4161: IS
4162: SELECT /*+ ORDERED */
4163: DISTINCT ics.ind_compiled_set_id
4164: FROM pa_ind_rate_sch_revisions irsr,
4165: pa_ind_compiled_sets ics
4166: WHERE ics.status = 'A'
4167: AND ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
4168: AND irsr.actual_sch_revision_id = rate_sch_rev_id;
4169:

Line 4358: ,pa_ind_compiled_sets ics

4354: are defined for an org for all the cost codes */
4355: /* 4527736
4356: AND exists (SELECT NULL
4357: FROM pa_expenditures_all exp
4358: ,pa_ind_compiled_sets ics
4359: WHERE exp.expenditure_id = ITEM.expenditure_id
4360: AND ((ics.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)
4361: or (ics.ind_compiled_set_id = ITEM.tp_ind_compiled_set_id))
4362: AND nvl(ITEM.override_to_organization_id,exp.incurred_by_organization_id) =ics.organization_id

Line 4370: ,PA_IND_COMPILED_SETS ICS

4366: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 -- Bug# 3134445 and Bug 3938479
4367: ) */
4368: AND EXISTS ((SELECT /*+ PUSH_SUBQ NO_UNNEST */ 1
4369: FROM PA_EXPENDITURES_ALL EXP
4370: ,PA_IND_COMPILED_SETS ICS
4371: WHERE EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID
4372: AND (ICS.IND_COMPILED_SET_ID = ITEM.COST_IND_COMPILED_SET_ID)
4373: AND NVL(ITEM.OVERRIDE_TO_ORGANIZATION_ID, EXP.INCURRED_BY_ORGANIZATION_ID) =ICS.ORGANIZATION_ID
4374: AND ICS.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id /* Added for Bug 5683523 */

Line 4382: ,PA_IND_COMPILED_SETS ICS

4378: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
4379: )
4380: UNION ALL (SELECT /*+ PUSH_SUBQ NO_UNNEST */ 1
4381: FROM PA_EXPENDITURES_ALL EXP
4382: ,PA_IND_COMPILED_SETS ICS
4383: WHERE EXP.EXPENDITURE_ID = ITEM.EXPENDITURE_ID
4384: AND (ICS.IND_COMPILED_SET_ID = ITEM.TP_IND_COMPILED_SET_ID)
4385: AND NVL(ITEM.OVERRIDE_TO_ORGANIZATION_ID, EXP.INCURRED_BY_ORGANIZATION_ID) =ICS.ORGANIZATION_ID
4386: AND ICS.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id /* Added for Bug 5683523 */

Line 4570: ,pa_ind_compiled_sets ics

4566: )
4567: /*Bug# 3055700 ::Added this exist clause back for bug# 3016281*/
4568: AND exists (SELECT NULL
4569: FROM pa_expenditures_all exp
4570: ,pa_ind_compiled_sets ics
4571: WHERE exp.expenditure_id = ITEM.expenditure_id
4572: AND ((ics.ind_compiled_set_id = ITEM.cost_ind_compiled_set_id)
4573: or (ics.ind_compiled_set_id = ITEM.tp_ind_compiled_set_id))
4574: AND nvl(ITEM.override_to_organization_id,exp.incurred_by_organization_id) =ics.organization_id

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

4654: and cbet.cost_base_type = INDIRECT_COST_CODE
4655: and cbet.expenditure_type = ITEM.expenditure_type
4656: )
4657: /*Bug# 3055700 : Added this exist clause back for bug# 3016281*/
4658: AND EXISTS (SELECT /*+ index(ics PA_IND_COMPILED_SETS_N6) */ NULL /*Added index hint for Bug 5683523 */
4659: FROM pa_expenditures_all exp
4660: ,pa_ind_compiled_sets ics
4661: WHERE exp.expenditure_id = ITEM.expenditure_id
4662: AND ((ics.ind_compiled_set_id = ITEM.rev_ind_compiled_set_id)

Line 4660: ,pa_ind_compiled_sets ics

4656: )
4657: /*Bug# 3055700 : Added this exist clause back for bug# 3016281*/
4658: AND EXISTS (SELECT /*+ index(ics PA_IND_COMPILED_SETS_N6) */ NULL /*Added index hint for Bug 5683523 */
4659: FROM pa_expenditures_all exp
4660: ,pa_ind_compiled_sets ics
4661: WHERE exp.expenditure_id = ITEM.expenditure_id
4662: AND ((ics.ind_compiled_set_id = ITEM.rev_ind_compiled_set_id)
4663: or (ics.ind_compiled_set_id = ITEM.inv_ind_compiled_set_id))
4664: AND nvl(ITEM.override_to_organization_id,exp.incurred_by_organization_id) =ics.organization_id

Line 7046: UPDATE pa_ind_compiled_sets

7042: IF G_IMPACTED_COST_BASES_TAB.COUNT <> 0 THEN /*4590268*/
7043:
7044: FOR i IN G_IMPACTED_COST_BASES_TAB.FIRST .. G_IMPACTED_COST_BASES_TAB.LAST
7045: LOOP
7046: UPDATE pa_ind_compiled_sets
7047: SET status = 'H',
7048: last_update_date = SYSDATE,
7049: last_updated_by = x_last_updated_by,
7050: last_update_login = x_last_update_login,

Line 7122: UPDATE pa_ind_compiled_sets

7118: --
7119: -- Set the compiled set to history
7120: --
7121:
7122: UPDATE pa_ind_compiled_sets
7123: SET status = 'H',
7124: last_update_date = SYSDATE,
7125: last_updated_by = x_last_updated_by,
7126: last_update_login = x_last_update_login,

Line 7328: from pa_ind_compiled_sets

7324:
7325: begin
7326: select ind_compiled_set_id
7327: into x_ind_compiled_set_id
7328: from pa_ind_compiled_sets
7329: where ind_rate_sch_revision_id = x_rate_sch_rev_id
7330: and organization_id = x_organization_id
7331: and status = 'A';
7332:

Line 7401: FROM pa_ind_compiled_sets ics,

7397: P_stage := 100;
7398:
7399: SELECT SUM(icpm.compiled_multiplier)
7400: INTO P_Compiled_multiplier
7401: FROM pa_ind_compiled_sets ics,
7402: pa_compiled_multipliers icpm
7403: WHERE ics.ind_rate_sch_revision_id = P_Rate_sch_rev_id
7404: AND ics.organization_id = P_Org_id
7405: AND ics.status = 'A'

Line 7492: FROM pa_ind_compiled_sets

7488:
7489: DELETE pa_compiled_multipliers
7490: WHERE ind_compiled_set_id IN
7491: (SELECT ind_compiled_set_id
7492: FROM pa_ind_compiled_sets
7493: WHERE ind_rate_sch_revision_id = rate_sch_rev_id
7494: and organization_id = ORG_REC.org_id_child
7495: and cost_base = cost_base_rec.cost_base) ;
7496:

Line 7500: DELETE pa_ind_compiled_sets

7496:
7497: E.N. Bug 3946409 */
7498:
7499: /* Bug# 4527736
7500: DELETE pa_ind_compiled_sets
7501: WHERE ind_rate_sch_revision_id = rate_sch_rev_id
7502: and organization_id =ORG_REC.org_id_child
7503: and cost_base =G_IMPACTED_COST_BASES_TAB(i)
7504: Bug# 4527736 */

Line 7699: pa_ind_compiled_sets ics

7695: from sys.dual
7696: where exists(*/
7697: select /*+ use_nl(ICS) */ 1 into org_override
7698: from pa_ind_cost_multipliers icm ,
7699: pa_ind_compiled_sets ics
7700: where icm.ind_rate_sch_revision_id =ics.ind_rate_sch_revision_id
7701: and icm.ind_rate_sch_revision_id = rate_sch_rev_id
7702: AND icm.organization_id =ics.organization_id
7703: and icm.organization_id = org_id

Line 7726: pa_ind_compiled_sets ics

7722: where exists
7723: (
7724: select 1
7725: from pa_ind_cost_multipliers icm ,
7726: pa_ind_compiled_sets ics
7727: where icm.ind_rate_sch_revision_id =ics.ind_rate_sch_revision_id
7728: and icm.ind_rate_sch_revision_id = rate_sch_rev_id
7729: and icm.organization_id =ics.organization_id
7730: and icm.organization_id = org_id

Line 7736: PA_IND_COMPILED_SETS ICS

7732: );*/
7733: SELECT /*+ use_nl(ICS) */ 0
7734: INTO org_override
7735: FROM PA_IND_COST_MULTIPLIERS ICM ,
7736: PA_IND_COMPILED_SETS ICS
7737: WHERE ICM.IND_RATE_SCH_REVISION_ID = ICS.IND_RATE_SCH_REVISION_ID
7738: AND ICM.IND_RATE_SCH_REVISION_ID = RATE_SCH_REV_ID
7739: AND ICM.ORGANIZATION_ID =ICS.ORGANIZATION_ID
7740: AND ICM.ORGANIZATION_ID = ORG_ID