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_COST_PLUS

Line 1: package body PA_COST_PLUS as

1: package body PA_COST_PLUS as
2: -- $Header: PAXCCPEB.pls 120.26.12020000.3 2012/12/31 10:54:54 sisana ship $
3: -- Package constants
4: NO_DATA_FOUND_ERR number := 100;
5: INDIRECT_COST_CODE varchar2(30) := 'INDIRECT COST';

Line 20: G_CP_STRUCTURE PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE;

16: */
17:
18: /*Added these variables for the bug 4527736*/
19: G_RATE_SCH_REVISION_ID PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE ;
20: G_CP_STRUCTURE PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE;
21: G_ORG_STRUC_VER_ID PA_IND_RATE_SCH_REVISIONS.ORG_STRUCTURE_VERSION_ID%TYPE;
22: G_START_ORGANIZATION_ID PA_IND_RATE_SCH_REVISIONS.START_ORGANIZATION_ID%TYPE;
23:
24: G_IMPACTED_COST_BASES_TAB PA_PLSQL_DATATYPES.Char30TabTyp;

Line 32: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE

28: /*
29: * Private Procedure.
30: */
31: PROCEDURE Cache_Impacted_Cost_Bases ( P_Ind_Rate_Sch_Revision_Id IN PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE
32: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
33: );
34: /* End Bug# 4527736 */
35:
36: G_gms_enabled varchar2(1):= gms_pa_api3.grants_enabled ;

Line 792: pa_cost_plus.get_hierarchy_from_revision(rate_sch_rev_id,

788: start_org := G_START_ORGANIZATION_ID ;
789: /*
790: * Commented for bug 4527736
791: *
792: pa_cost_plus.get_hierarchy_from_revision(rate_sch_rev_id,
793: org_struc_ver_id,
794: start_org,
795: status,
796: stage);

Line 810: pa_cost_plus.disable_sch_rev_org(rate_sch_rev_id,

806: --
807:
808: if (comp_type = 'INCREMENTAL') then
809:
810: pa_cost_plus.disable_sch_rev_org(rate_sch_rev_id,
811: org_id,
812: status,
813: stage);
814:

Line 817: pa_cost_plus.compile_org_rates(rate_sch_rev_id,

813: stage);
814:
815: end if;
816:
817: pa_cost_plus.compile_org_rates(rate_sch_rev_id,
818: org_id,
819: org_struc_ver_id,
820: start_org,
821: status,

Line 843: pa_cost_plus.disable_sch_rev_org(rate_sch_rev_id,

839: --
840:
841: if (comp_type = 'INCREMENTAL') then
842:
843: pa_cost_plus.disable_sch_rev_org(rate_sch_rev_id,
844: org_row.organization_id_child,
845: status,
846: stage);
847:

Line 850: pa_cost_plus.compile_org_rates(rate_sch_rev_id,

846: stage);
847:
848: end if;
849:
850: pa_cost_plus.compile_org_rates(rate_sch_rev_id,
851: org_row.organization_id_child,
852: org_struc_ver_id,
853: start_org,
854: status,

Line 995: pa_cost_plus.Cache_Impacted_Cost_Bases( G_RATE_SCH_REVISION_ID

991: ELSE
992: G_RATE_SCH_REVISION_ID := rev_struct_row.ind_rate_sch_revision_id;
993: G_CP_STRUCTURE := rev_struct_row.cost_plus_structure;
994:
995: pa_cost_plus.Cache_Impacted_Cost_Bases( G_RATE_SCH_REVISION_ID
996: ,G_CP_STRUCTURE);
997: END IF;
998:
999: G_ORG_STRUC_VER_ID := rev_struct_row.org_structure_version_id;

Line 1030: pa_cost_plus.compile_org_hierarchy_rates(

1026: ind_rate_sch_revision_id = rev_struct_row.ind_rate_sch_revision_id;
1027:
1028: COMMIT;
1029:
1030: pa_cost_plus.compile_org_hierarchy_rates(
1031: rev_struct_row.ind_rate_sch_revision_id,
1032: orgn_row.organization_id,
1033: 'INCREMENTAL',
1034: status,

Line 1110: -- pa_cost_plus.compile_org_hierarchy_rates(

1106: -- ind_rate_sch_revision_id = rev_row.ind_rate_sch_revision_id;
1107: --
1108: -- COMMIT;
1109: --
1110: -- pa_cost_plus.compile_org_hierarchy_rates(
1111: -- rev_row.ind_rate_sch_revision_id,
1112: -- l_org_id,
1113: -- 'INCREMENTAL',
1114: -- status,

Line 1219: l_cp_structure pa_cost_plus_structures.cost_plus_structure%TYPE ; /3055700/

1215: rate_sch_rev_id number;
1216: org_tab org_tab_type; /*2933915*/ /*To store top impacted orgs*/
1217: lstatus number ; /*2933915*/
1218: l_check number ; /*3055700*/
1219: l_cp_structure pa_cost_plus_structures.cost_plus_structure%TYPE ; /*3055700*/
1220: -- Standard who
1221: x_last_updated_by NUMBER(15);
1222: x_last_update_login NUMBER(15);
1223: x_request_id NUMBER(15);

Line 1275: pa_cost_plus.get_hierarchy_from_revision(G_RATE_SCH_REVISION_ID, /* 4527736 */

1271: -- Join can not be used in a CONNECT BY statement
1272: --
1273:
1274:
1275: pa_cost_plus.get_hierarchy_from_revision(G_RATE_SCH_REVISION_ID, /* 4527736 */
1276: org_struc_ver_id,
1277: start_org,
1278: status,
1279: stage);

Line 1300: pa_cost_plus.get_cost_plus_structure(rate_sch_rev_id,

1296: Subsequently any changes in multiplies will affect only impacted org and
1297: impacted cost base as per enhancement .
1298: *********************************************************************************************/
1299:
1300: pa_cost_plus.get_cost_plus_structure(rate_sch_rev_id,
1301: l_cp_structure,
1302: status,
1303: stage);
1304:

Line 1314: /* pa_cost_plus.Cache_Impacted_Cost_Bases( G_RATE_SCH_REVISION_ID

1310:
1311: /* 4527736
1312: * Call Cache_Impacted_Cost_Bases.
1313: */
1314: /* pa_cost_plus.Cache_Impacted_Cost_Bases( G_RATE_SCH_REVISION_ID
1315: ,G_CP_STRUCTURE); Commented for Bug 5181688 */
1316:
1317: Begin
1318: /*If for start_org there are compiled set ids present with status 'A' for ALL the cost bases then

Line 1340: IF pa_cost_plus.check_for_explicit_multiplier(G_RATE_SCH_REVISION_ID ,start_org) =0 THEN /* 0 means not present*/

1336:
1337: IF (l_check =0) THEN
1338: /*If explicit multipliers are not defined for start org for ALL cost codes then only insert*/
1339:
1340: IF pa_cost_plus.check_for_explicit_multiplier(G_RATE_SCH_REVISION_ID ,start_org) =0 THEN /* 0 means not present*/
1341:
1342: Begin
1343:
1344: INSERT into pa_ind_cost_multipliers (ind_rate_sch_revision_id,

Line 1383: pa_cost_plus.Cache_Impacted_Cost_Bases( G_RATE_SCH_REVISION_ID

1379:
1380: /*End of changes for 3055700 */
1381:
1382: /*Bug 5181688 */
1383: pa_cost_plus.Cache_Impacted_Cost_Bases( G_RATE_SCH_REVISION_ID
1384: ,G_CP_STRUCTURE);
1385:
1386:
1387: /*2933915 :Added call to procedure find_impacted_top_org() that should return the PL/SQL table of

Line 1395: pa_cost_plus.find_impacted_top_org(G_RATE_SCH_REVISION_ID,G_ORG_STRUC_VER_ID,start_org,org_tab,status); /2933915/

1391: This is to avoid compiling ALL the organizations in the hierarchy as was happening earlier and hence
1392: to start compiling from the top most impacted orgs */
1393:
1394: /* 4527736 */
1395: pa_cost_plus.find_impacted_top_org(G_RATE_SCH_REVISION_ID,G_ORG_STRUC_VER_ID,start_org,org_tab,status); /*2933915*/
1396:
1397: if (status < 0) then /*2933915*/
1398:
1399: errbuf := sqlerrm (status);

Line 1408: pa_cost_plus.check_revision_used(G_RATE_SCH_REVISION_ID, lstatus, stage); /2933915/

1404: -- Verify whether there is any costed expenditure item
1405: --
1406:
1407: -- 4527736
1408: pa_cost_plus.check_revision_used(G_RATE_SCH_REVISION_ID, lstatus, stage); /*2933915*/
1409:
1410: /*2933915 : FOR SELECTIVE DELETION AND OBSOLETION */
1411: /***Added a LOOP for the processing to go for each TOP IMPACTED organization returned by the above procedure in org_tab
1412: We are going to process for all the children of the top affected org **********/

Line 1454: pa_cost_plus.disable_rate_sch_revision(G_RATE_SCH_REVISION_ID,G_ORG_STRUC_VER_ID,org_tab(i),status, stage );

1450: --
1451: -- Disable the current rate schedule if any
1452: --
1453: -- 4527736
1454: pa_cost_plus.disable_rate_sch_revision(G_RATE_SCH_REVISION_ID,G_ORG_STRUC_VER_ID,org_tab(i),status, stage );
1455: /*2933915 :ADDED org_struc_ver_id and org_id as parameter *****/
1456: if (status < 0) then
1457: errbuf := sqlerrm (status);
1458: retcode := 2;

Line 1470: pa_cost_plus.compile_org_hierarchy_rates(G_RATE_SCH_REVISION_ID,

1466: --
1467: -- Compile rates for all organizations starting from the top impacted organization
1468: --
1469:
1470: pa_cost_plus.compile_org_hierarchy_rates(G_RATE_SCH_REVISION_ID,
1471: org_tab(i), /*2933915 : Replaced start_org by org_tab(i)*/
1472: 'ALL',
1473: status,
1474: stage);

Line 1487: pa_cost_plus.mark_impacted_exp_items(G_RATE_SCH_REVISION_ID,status, stage);

1483: END IF ; /*If org_tab.exists*/
1484:
1485: -- Mark impacted expenditure items for re-costing
1486:
1487: pa_cost_plus.mark_impacted_exp_items(G_RATE_SCH_REVISION_ID,status, stage);
1488:
1489: if (status < 0) then
1490: errbuf := sqlerrm (status);
1491: retcode := 2;

Line 1573: pa_cost_plus.compile_schedule(errbuf,

1569:
1570: BEGIN
1571: sch_rev_id := sch_row.ind_rate_sch_revision_id;
1572:
1573: pa_cost_plus.compile_schedule(errbuf,
1574: retcode,
1575: sch_rev_id);
1576:
1577: END;

Line 1736: pa_cost_plus.get_rate_sch_rev_id(exp_item_id,

1732: --
1733: -- Get the rate schedule revision id
1734: --
1735:
1736: pa_cost_plus.get_rate_sch_rev_id(exp_item_id,
1737: schedule_type,
1738: rate_sch_rev_id,
1739: status,
1740: stage);

Line 1751: pa_cost_plus.get_cost_plus_structure(rate_sch_rev_id,

1747: --
1748: -- Get the cost plus structure
1749: --
1750:
1751: pa_cost_plus.get_cost_plus_structure(rate_sch_rev_id,
1752: cp_structure,
1753: status,
1754: stage);
1755:

Line 1766: pa_cost_plus.get_cost_base(exp_type,

1762: --
1763: -- Get the cost base
1764: --
1765:
1766: pa_cost_plus.get_cost_base(exp_type,
1767: cp_structure,
1768: c_base,
1769: status,
1770: stage);

Line 1782: pa_cost_plus.get_organization_id(exp_item_id,

1778: --
1779: -- Get the organization
1780: --
1781:
1782: pa_cost_plus.get_organization_id(exp_item_id,
1783: org_id,
1784: status,
1785: stage);
1786:

Line 1801: pa_cost_plus.get_indirect_cost_sum(org_id,

1797: -- Get the indirect cost
1798: --
1799:
1800: /*
1801: pa_cost_plus.get_indirect_cost_sum(org_id,
1802: c_base,
1803: rate_sch_rev_id,
1804: direct_cost,
1805: 2, -- FOR US CURRENCY

Line 1826: * pa_cost_plus.get_compiled_multiplier(org_id,

1822: * Bug#2110452
1823: * Commented to implement the same logic for burden cost calculation
1824: * as is used in R10.7/R11.0.
1825: *
1826: * pa_cost_plus.get_compiled_multiplier(org_id,
1827: * c_base,
1828: * rate_sch_rev_id,
1829: * compiled_multiplier,
1830: * status,

Line 1840: pa_cost_plus.get_indirect_cost_sum1 ( org_id => org_id

1836: * To implement the same logic as is used in R10.7/R11.0 for
1837: * burden cost calculation.
1838: */
1839:
1840: pa_cost_plus.get_indirect_cost_sum1 ( org_id => org_id
1841: ,c_base => c_base
1842: ,rate_sch_rev_id => rate_sch_rev_id
1843: ,direct_cost => direct_cost
1844: ,direct_cost_denom => direct_cost_denom

Line 1939: pa_cost_plus.get_exp_item_indirect_cost(exp_item_id,

1935: burden_amount_denom PA_EXPENDITURE_ITEMS.Denom_Burdened_cost%TYPE;
1936: burden_amount_Acct PA_EXPENDITURE_ITEMS.Acct_Burdened_cost%TYPE;
1937: burden_amount_Project PA_EXPENDITURE_ITEMS.Project_Burdened_cost%TYPE; /* epp */
1938: BEGIN
1939: pa_cost_plus.get_exp_item_indirect_cost(exp_item_id,
1940: schedule_type,
1941: burden_amount,
1942: burden_amount_denom,
1943: burden_amount_acct,

Line 2220: pa_cost_plus.get_exp_item_indirect_cost(

2216: status := 0;
2217:
2218: ELSE
2219:
2220: pa_cost_plus.get_exp_item_indirect_cost(
2221: Exp_Item_Row.Expenditure_Item_ID,
2222: 'C',
2223: indirect_cost,
2224: indirect_cost_acct,

Line 2596: -- Will make appropriate modifications to PA_COST_PLUS1 package to call

2592: -- for which I couldn't find any references in 11.0 source stream
2593: -- By adding this change, we will be sending the indirect_cost as
2594: -- 0 if the burden amount to be displayed on same project as separate
2595: -- expenditure items
2596: -- Will make appropriate modifications to PA_COST_PLUS1 package to call
2597: -- PA_COST_PLUS1.view_indirect_cost instead of
2598: -- PA_COST_PLUS.view_indirect_cost
2599: --
2600: /*

Line 2597: -- PA_COST_PLUS1.view_indirect_cost instead of

2593: -- By adding this change, we will be sending the indirect_cost as
2594: -- 0 if the burden amount to be displayed on same project as separate
2595: -- expenditure items
2596: -- Will make appropriate modifications to PA_COST_PLUS1 package to call
2597: -- PA_COST_PLUS1.view_indirect_cost instead of
2598: -- PA_COST_PLUS.view_indirect_cost
2599: --
2600: /*
2601: * Bug#1065740

Line 2598: -- PA_COST_PLUS.view_indirect_cost

2594: -- 0 if the burden amount to be displayed on same project as separate
2595: -- expenditure items
2596: -- Will make appropriate modifications to PA_COST_PLUS1 package to call
2597: -- PA_COST_PLUS1.view_indirect_cost instead of
2598: -- PA_COST_PLUS.view_indirect_cost
2599: --
2600: /*
2601: * Bug#1065740
2602: * parameter added to this cursor to avoid conflict

Line 2669: pa_cost_plus.find_rate_sch_rev_id(

2665: END LOOP;
2666: END IF;
2667:
2668:
2669: pa_cost_plus.find_rate_sch_rev_id(
2670: transaction_id,
2671: transaction_type,
2672: task_id,
2673: schedule_type,

Line 2691: pa_cost_plus.get_cost_plus_structure(rate_sch_rev_id,

2687: --
2688: -- Get the cost plus structure
2689: --
2690:
2691: pa_cost_plus.get_cost_plus_structure(rate_sch_rev_id,
2692: cp_structure,
2693: status,
2694: stage);
2695:

Line 2706: pa_cost_plus.get_cost_base(expenditure_type,

2702: --
2703: -- Get the cost base
2704: --
2705:
2706: pa_cost_plus.get_cost_base(expenditure_type,
2707: cp_structure,
2708: c_base,
2709: status,
2710: stage);

Line 2730: pa_cost_plus.get_indirect_cost_sum(organization_id,

2726: --
2727: -- Get the indirect cost
2728: --
2729:
2730: pa_cost_plus.get_indirect_cost_sum(organization_id,
2731: c_base,
2732: rate_sch_rev_id,
2733: direct_cost,
2734: 2, -- FOR US CURRENCY

Line 2794: pa_cost_plus.get_revision_by_date(burden_schedule_id,

2790: --
2791: -- Get the rate schedule revision id
2792: --
2793:
2794: pa_cost_plus.get_revision_by_date(burden_schedule_id,
2795: effective_date,
2796: effective_date,
2797: burden_sch_rev_id,
2798: status,

Line 2811: pa_cost_plus.get_cost_plus_structure(burden_sch_rev_id,

2807: --
2808: -- Get the cost plus structure
2809: --
2810:
2811: pa_cost_plus.get_cost_plus_structure(burden_sch_rev_id,
2812: cp_structure,
2813: status,
2814: stage);
2815:

Line 2826: pa_cost_plus.get_cost_base(expenditure_type,

2822: --
2823: -- Get the cost base
2824: --
2825:
2826: pa_cost_plus.get_cost_base(expenditure_type,
2827: cp_structure,
2828: c_base,
2829: status,
2830: stage);

Line 2842: pa_cost_plus.get_compiled_set_id(burden_sch_rev_id,

2838: --
2839: -- Get the compiled set id
2840: --
2841:
2842: pa_cost_plus.get_compiled_set_id(burden_sch_rev_id,
2843: organization_id,
2844: c_base, /*Bug# 2933915*/
2845: compiled_set_id,
2846: status,

Line 2858: pa_cost_plus.get_indirect_cost_sum(organization_id,

2854: --
2855: -- Get the indirect cost
2856: --
2857:
2858: pa_cost_plus.get_indirect_cost_sum(organization_id,
2859: c_base,
2860: burden_sch_rev_id,
2861: raw_amount,
2862: 2, -- FOR US CURRENCY

Line 2910: pa_cost_plus.get_revision_by_date(burden_schedule_id,

2906: -- Get the rate schedule revision id
2907: --
2908:
2909: /*
2910: pa_cost_plus.get_revision_by_date(burden_schedule_id,
2911: effective_date,
2912: effective_date,
2913: burden_sch_rev_id,
2914: status,

Line 2929: pa_cost_plus.get_cost_plus_structure(burden_sch_rev_id,

2925: --
2926: -- Get the cost plus structure
2927: --
2928:
2929: pa_cost_plus.get_cost_plus_structure(burden_sch_rev_id,
2930: cp_structure,
2931: status,
2932: stage);
2933:

Line 2944: pa_cost_plus.get_cost_base(expenditure_type,

2940: --
2941: -- Get the cost base
2942: --
2943:
2944: pa_cost_plus.get_cost_base(expenditure_type,
2945: cp_structure,
2946: c_base,
2947: status,
2948: stage);

Line 2960: pa_cost_plus.get_compiled_set_id(burden_sch_rev_id,

2956: --
2957: -- Get the compiled set id
2958: --
2959:
2960: pa_cost_plus.get_compiled_set_id(burden_sch_rev_id,
2961: organization_id,
2962: c_base, /*Bug# 2933915*/
2963: compiled_set_id,
2964: status,

Line 2976: pa_cost_plus.get_indirect_cost_sum(organization_id,

2972: --
2973: -- Get the indirect cost
2974: --
2975:
2976: pa_cost_plus.get_indirect_cost_sum(organization_id,
2977: c_base,
2978: burden_sch_rev_id,
2979: raw_amount,
2980: 2, -- FOR US CURRENCY

Line 3156: pa_cost_plus.get_revision_by_date(sch_id,

3152: -- Get revision id if schedule is not null
3153: --
3154:
3155: IF (sch_id IS NOT NULL) THEN
3156: pa_cost_plus.get_revision_by_date(sch_id,
3157: sch_fixed_date,
3158: exp_item_date,
3159: rate_sch_rev_id,
3160: status,

Line 3313: pa_cost_plus.get_revision_by_date(sch_id,

3309: END IF;
3310:
3311:
3312: if (sch_id IS NOT NULL) then
3313: pa_cost_plus.get_revision_by_date(sch_id,
3314: sch_fixed_date,
3315: exp_item_date,
3316: rate_sch_rev_id,
3317: status,

Line 3366: pa_cost_plus.get_revision_by_date(sch_id,

3362:
3363: END IF;
3364:
3365: if (sch_id IS NOT NULL) then
3366: pa_cost_plus.get_revision_by_date(sch_id,
3367: sch_fixed_date,
3368: exp_item_date,
3369: rate_sch_rev_id,
3370: status,

Line 3442: pa_cost_plus.find_rate_sch_rev_id(

3438: --
3439: -- Get the indirect rate schedule
3440: --
3441:
3442: pa_cost_plus.find_rate_sch_rev_id(
3443: exp_item_id,
3444: 'PA',
3445: t_id,
3446: schedule_type,

Line 3903: pa_cost_plus.check_revision_used(rev_row.ind_rate_sch_revision_id,

3899: status := 0;
3900:
3901: FOR rev_row IN rev_cursor LOOP
3902:
3903: pa_cost_plus.check_revision_used(rev_row.ind_rate_sch_revision_id,
3904: status,
3905: stage);
3906:
3907: if (status <> 0) then

Line 3985: FROM pa_cost_plus_structures

3981: x_last_update_login := FND_GLOBAL.LOGIN_ID;
3982:
3983: SELECT cost_plus_structure_type
3984: INTO structure_type
3985: FROM pa_cost_plus_structures
3986: WHERE cost_plus_structure = destination;
3987:
3988: if (structure_type = 'A') then
3989: icc_precedence := 1 ;

Line 4364: * AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 -- Bug# 3134445

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
4363: AND ics.status = 'H'
4364: * AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 -- Bug# 3134445
4365: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id))
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

Line 4365: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_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
4363: AND ics.status = 'H'
4364: * AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 -- Bug# 3134445
4365: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id))
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

Line 4366: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 -- Bug# 3134445 and Bug 3938479

4362: AND nvl(ITEM.override_to_organization_id,exp.incurred_by_organization_id) =ics.organization_id
4363: AND ics.status = 'H'
4364: * AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 -- Bug# 3134445
4365: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id))
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

Line 4377: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_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 */
4375: AND ICS.STATUS = 'H'
4376: AND DECODE(rate_sch_rev_id ,g_rate_sch_rev_id ,DECODE(ICS.ORGANIZATION_ID,g_org_id ,g_org_override
4377: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID))
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

Line 4378: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0

4374: AND ICS.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id /* Added for Bug 5683523 */
4375: AND ICS.STATUS = 'H'
4376: AND DECODE(rate_sch_rev_id ,g_rate_sch_rev_id ,DECODE(ICS.ORGANIZATION_ID,g_org_id ,g_org_override
4377: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID))
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

Line 4389: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_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 */
4387: AND ICS.STATUS = 'H'
4388: AND DECODE(rate_sch_rev_id ,g_rate_sch_rev_id ,DECODE(ICS.ORGANIZATION_ID,g_org_id ,g_org_override
4389: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID))
4390: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
4391: )
4392: )
4393: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d') AND l_burden_profile ='N')

Line 4390: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0

4386: AND ICS.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id /* Added for Bug 5683523 */
4387: AND ICS.STATUS = 'H'
4388: AND DECODE(rate_sch_rev_id ,g_rate_sch_rev_id ,DECODE(ICS.ORGANIZATION_ID,g_org_id ,g_org_override
4389: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID))
4390: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
4391: )
4392: )
4393: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d') AND l_burden_profile ='N')
4394: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s') AND l_burden_profile ='Y'))

Line 4399: pa_cost_plus.add_adjustment_activity(G_EXPENDITURE_ITEM_ID_TAB

4395: RETURNING expenditure_item_id, decode(cs1_row.ind_compiled_set_id,ITEM.tp_ind_compiled_set_id,'UPDATE TP SCHEDULE REVISION','UPDATE COST SCHEDULE REVISION')
4396: BULK COLLECT INTO G_EXPENDITURE_ITEM_ID_TAB,G_ADJ_TYPE_TAB;
4397:
4398: stage := 290 ;
4399: pa_cost_plus.add_adjustment_activity(G_EXPENDITURE_ITEM_ID_TAB
4400: ,G_ADJ_TYPE_TAB
4401: ,status
4402: ,stage
4403: );

Line 4576: /AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 /3134445*/

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
4575: AND ics.status = 'H'
4576: /*AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 /*3134445*/
4577: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id))
4578: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 /*Bug# 3134445 and Bug 3938479*/
4579: )
4580:

Line 4577: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_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
4575: AND ics.status = 'H'
4576: /*AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 /*3134445*/
4577: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id))
4578: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 /*Bug# 3134445 and Bug 3938479*/
4579: )
4580:
4581: /*****************************************************************

Line 4578: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 /Bug# 3134445 and Bug 3938479/

4574: AND nvl(ITEM.override_to_organization_id,exp.incurred_by_organization_id) =ics.organization_id
4575: AND ics.status = 'H'
4576: /*AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 /*3134445*/
4577: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id))
4578: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 /*Bug# 3134445 and Bug 3938479*/
4579: )
4580:
4581: /*****************************************************************
4582: AND exists (select 1

Line 4596: pa_cost_plus.add_adjustment_activity(cs1_row.ind_compiled_set_id

4592: BULK COLLECT INTO G_EXPENDITURE_ITEM_ID_TAB,G_ADJ_TYPE_TAB;
4593:
4594: stage := 300 ;
4595: /*
4596: pa_cost_plus.add_adjustment_activity(cs1_row.ind_compiled_set_id
4597: --,cost_base_rec.cost_base
4598: ,G_IMPACTED_COST_BASES_TAB(i)
4599: ,l_cp_structure
4600: ,'UPDATE COST SCHEDULE REVISION'

Line 4609: pa_cost_plus.add_adjustment_activity(G_EXPENDITURE_ITEM_ID_TAB

4605: ,stage
4606: ,G_EXPENDITURE_ITEM_ID_TAB
4607: ,G_ADJ_TYPE_TAB);
4608: */
4609: pa_cost_plus.add_adjustment_activity(G_EXPENDITURE_ITEM_ID_TAB
4610: ,G_ADJ_TYPE_TAB
4611: ,status
4612: ,stage
4613: );

Line 4667: /AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 /Bug# 3134445*/

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
4665: AND ics.ind_rate_sch_revision_id = rate_sch_rev_id /* Added for Bug 5683523 */
4666: AND ics.status = 'H'
4667: /*AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 /*Bug# 3134445*/
4668: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id))
4669: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 /*Bug# 3134445 and Bug 3938479*/
4670: )
4671: RETURNING expenditure_item_id, decode(cs1_row.ind_compiled_set_id,ITEM.rev_ind_compiled_set_id,'UPDATE REV SCHEDULE REVISION','UPDATE INV SCHEDULE REVISION')

Line 4668: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id))

4664: AND nvl(ITEM.override_to_organization_id,exp.incurred_by_organization_id) =ics.organization_id
4665: AND ics.ind_rate_sch_revision_id = rate_sch_rev_id /* Added for Bug 5683523 */
4666: AND ics.status = 'H'
4667: /*AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 /*Bug# 3134445*/
4668: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id))
4669: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 /*Bug# 3134445 and Bug 3938479*/
4670: )
4671: RETURNING expenditure_item_id, decode(cs1_row.ind_compiled_set_id,ITEM.rev_ind_compiled_set_id,'UPDATE REV SCHEDULE REVISION','UPDATE INV SCHEDULE REVISION')
4672: BULK COLLECT INTO G_EXPENDITURE_ITEM_ID_TAB,G_ADJ_TYPE_TAB;

Line 4669: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 /Bug# 3134445 and Bug 3938479/

4665: AND ics.ind_rate_sch_revision_id = rate_sch_rev_id /* Added for Bug 5683523 */
4666: AND ics.status = 'H'
4667: /*AND pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ) =0 /*Bug# 3134445*/
4668: AND decode(rate_sch_rev_id,g_rate_sch_rev_id,decode(ics.organization_id,g_org_id,g_org_override,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id))
4669: ,pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id,ics.organization_id ))=0 /*Bug# 3134445 and Bug 3938479*/
4670: )
4671: RETURNING expenditure_item_id, decode(cs1_row.ind_compiled_set_id,ITEM.rev_ind_compiled_set_id,'UPDATE REV SCHEDULE REVISION','UPDATE INV SCHEDULE REVISION')
4672: BULK COLLECT INTO G_EXPENDITURE_ITEM_ID_TAB,G_ADJ_TYPE_TAB;
4673:

Line 4675: /* pa_cost_plus.add_adjustment_activity(cs1_row.ind_compiled_set_id

4671: RETURNING expenditure_item_id, decode(cs1_row.ind_compiled_set_id,ITEM.rev_ind_compiled_set_id,'UPDATE REV SCHEDULE REVISION','UPDATE INV SCHEDULE REVISION')
4672: BULK COLLECT INTO G_EXPENDITURE_ITEM_ID_TAB,G_ADJ_TYPE_TAB;
4673:
4674: stage := 450 ;
4675: /* pa_cost_plus.add_adjustment_activity(cs1_row.ind_compiled_set_id
4676: --,cost_base_rec.cost_base
4677: ,G_IMPACTED_COST_BASES_TAB(i)
4678: ,l_cp_structure
4679: ,NULL

Line 4689: pa_cost_plus.add_adjustment_activity(G_EXPENDITURE_ITEM_ID_TAB

4685: ,G_EXPENDITURE_ITEM_ID_TAB
4686: ,G_ADJ_TYPE_TAB);
4687: */
4688:
4689: pa_cost_plus.add_adjustment_activity(G_EXPENDITURE_ITEM_ID_TAB
4690: ,G_ADJ_TYPE_TAB
4691: ,status
4692: ,stage
4693: );

Line 4734: pa_cost_plus.mark_prev_rev_exp_items(cs2_row.ind_compiled_set_id,

4730: FOR cs2_row IN cs2_cursor LOOP
4731:
4732: stage := 500;
4733:
4734: pa_cost_plus.mark_prev_rev_exp_items(cs2_row.ind_compiled_set_id,
4735: rev_type,
4736: 'NEW REVISION',
4737: l_start_date,
4738: l_end_date,

Line 4765: pa_cost_plus.mark_prev_rev_exp_items(cs3_row.ind_compiled_set_id,

4761: FOR cs3_row IN cs3_cursor LOOP
4762:
4763: stage := 600;
4764:
4765: pa_cost_plus.mark_prev_rev_exp_items(cs3_row.ind_compiled_set_id,
4766: rev_type,
4767: 'APPLY ACTUAL',
4768: l_start_date,
4769: l_end_date,

Line 6594: ,p_cost_plus_structure IN pa_cost_plus_structures.cost_plus_structure%TYPE,

6590:
6591: /*
6592: procedure add_adjustment_activity(compiled_set_id IN number,
6593: p_cost_base IN pa_cost_bases.cost_base%TYPE
6594: ,p_cost_plus_structure IN pa_cost_plus_structures.cost_plus_structure%TYPE,
6595: cost_adj_reason IN varchar2,
6596: rev_adj_reason IN varchar2,
6597: inv_adj_reason IN varchar2,
6598: tp_adj_reason IN varchar2,

Line 7040: IF pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id ,org_id_rec.org_id_child) =0 THEN /3016281/

7036: compiled set ids for that.
7037: This is in view of the enhancement that new compiled set ids will not be generated for an org if explicit multipliers are defined
7038: for all the cost codes in impacted cost bases for that org*/
7039:
7040: IF pa_cost_plus.check_for_explicit_multiplier(rate_sch_rev_id ,org_id_rec.org_id_child) =0 THEN /*3016281*/
7041: --FOR cost_base_rec in impacted_cost_bases(rate_sch_rev_id)
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

Line 7165: pa_cost_plus.view_indirect_cost(

7161:
7162: --
7163: -- Get the costing indirect cost
7164: --
7165: pa_cost_plus.view_indirect_cost(
7166: NULL,
7167: 'PA',
7168: x_task_id,
7169: x_gl_date,

Line 7191: pa_cost_plus.view_indirect_cost(

7187:
7188: --
7189: -- Get the revenue indirect cost
7190: --
7191: pa_cost_plus.view_indirect_cost(
7192: NULL,
7193: 'PA',
7194: x_task_id,
7195: x_gl_date,

Line 7222: pa_cost_plus.view_indirect_cost(

7218:
7219: --
7220: -- Get the invoice indirect cost
7221: --
7222: pa_cost_plus.view_indirect_cost(
7223: NULL,
7224: 'PA',
7225: x_task_id,
7226: x_gl_date,

Line 7280: pa_cost_plus.find_rate_sch_rev_id (NULL,

7276:
7277: x_return_status := 0;
7278: x_stage := 0;
7279:
7280: pa_cost_plus.find_rate_sch_rev_id (NULL,
7281: 'PA',
7282: x_task_id,
7283: x_detail_type_flag,
7284: x_gl_date,

Line 7304: pa_cost_plus.get_cost_plus_structure(x_rate_sch_rev_id,

7300:
7301:
7302: begin
7303:
7304: pa_cost_plus.get_cost_plus_structure(x_rate_sch_rev_id,
7305: x_cp_structure,
7306: x_return_status,
7307: x_stage);
7308:

Line 7309: pa_cost_plus.get_cost_base (x_expenditure_type,

7305: x_cp_structure,
7306: x_return_status,
7307: x_stage);
7308:
7309: pa_cost_plus.get_cost_base (x_expenditure_type,
7310: x_cp_structure,
7311: x_cost_base,
7312: x_return_status,
7313: x_stage);

Line 7798: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE

7794: RAISE;
7795: END check_for_explicit_multiplier ; /*3012681*/
7796:
7797: PROCEDURE Cache_Impacted_Cost_Bases ( P_Ind_Rate_Sch_Revision_Id IN PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE
7798: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
7799: )
7800: IS
7801: CURSOR impacted_cost_bases_cur( P_Ind_Rate_Sch_Revision_Id PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE
7802: ,P_Cp_Structure PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE

Line 7802: ,P_Cp_Structure PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE

7798: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
7799: )
7800: IS
7801: CURSOR impacted_cost_bases_cur( P_Ind_Rate_Sch_Revision_Id PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE
7802: ,P_Cp_Structure PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
7803: )
7804: IS
7805: SELECT pcb.COST_BASE
7806: FROM PA_COST_BASES pcb

Line 7879: end PA_COST_PLUS ;

7875: RAISE;
7876:
7877: END validate_CrDr_lines;
7878:
7879: end PA_COST_PLUS ;