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_RATE_SCH_REVISIONS

Line 19: G_RATE_SCH_REVISION_ID PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE ;

15: ** 2981752 - PA.L:BURDENING ENHANCEMENTS : TRACKING BUG
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:

Line 21: G_ORG_STRUC_VER_ID PA_IND_RATE_SCH_REVISIONS.ORG_STRUCTURE_VERSION_ID%TYPE;

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;
25: G_EXPENDITURE_ITEM_ID_TAB PA_PLSQL_DATATYPES.IDTABTYP;

Line 22: G_START_ORGANIZATION_ID PA_IND_RATE_SCH_REVISIONS.START_ORGANIZATION_ID%TYPE;

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;
25: G_EXPENDITURE_ITEM_ID_TAB PA_PLSQL_DATATYPES.IDTABTYP;
26: G_ADJ_TYPE_TAB PA_PLSQL_DATATYPES.Char30TabTyp;

Line 31: PROCEDURE Cache_Impacted_Cost_Bases ( P_Ind_Rate_Sch_Revision_Id IN PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE

27:
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:

Line 70: PA_IND_RATE_SCH_REVISIONS IRSR

66: (
67: SELECT 1 /* Bug# 4527736 */
68: FROM PA_COST_BASE_COST_CODES CBICC,
69: PA_IND_COST_MULTIPLIERS ICM,
70: PA_IND_RATE_SCH_REVISIONS IRSR
71: WHERE IRSR.IND_RATE_SCH_REVISION_ID = ICM.IND_RATE_SCH_REVISION_ID
72: AND IRSR.IND_RATE_SCH_REVISION_ID = rate_sch_rev_id
73: AND (NVL(ICM.READY_TO_COMPILE_FLAG,'N') IN ('Y','X')
74: OR NVL(G_MODULE ,'XXX') = 'NEW_ORG')

Line 159: pa_ind_rate_sch_revisions irsr

155: cbicc.cost_base,
156: cbicc.ind_cost_code,
157: cbicc.precedence
158: FROM pa_cost_base_cost_codes cbicc,
159: pa_ind_rate_sch_revisions irsr
160: WHERE irsr.ind_rate_sch_revision_id = rate_sch_rev_id
161: AND irsr.cost_plus_structure = cbicc.cost_plus_structure
162: AND cbicc.cost_base = x_base -- 2933915
163: AND cbicc.cost_base_type = INDIRECT_COST_CODE

Line 868: UPDATE pa_ind_rate_sch_revisions

864: --
865: -- Set the compilation time in the rate schedule revision
866: --
867:
868: UPDATE pa_ind_rate_sch_revisions
869: SET
870: compiled_flag = 'Y',
871: compiled_date = SYSDATE
872: WHERE

Line 911: FROM pa_ind_rate_sch_revisions irsr

907: -- Cursor definition
908:
909: /* CURSOR rev_cursor IS
910: SELECT irsr.ind_rate_sch_revision_id
911: FROM pa_ind_rate_sch_revisions irsr
912: WHERE irsr.compiled_flag = 'Y' -- revision has been compiled before
913: AND irsr.ready_to_compile_flag = 'Y'; -- compilation is not on hold
914: *** cusor commented for bug 3033195 */
915:

Line 941: FROM pa_ind_rate_sch_revisions

937: /* Two cursors added below for bug 3033195 */
938:
939: Cursor rev_struct_cursor is
940: SELECT ind_rate_sch_revision_id, org_structure_version_id,cost_plus_structure,start_organization_id /*4590268*/
941: FROM pa_ind_rate_sch_revisions
942: WHERE compiled_flag = 'Y'
943: AND ready_to_compile_flag = 'Y'
944: AND org_structure_version_id in
945: (select org_structure_version_id

Line 1016: UPDATE pa_ind_rate_sch_revisions

1012: IF l_org_exists THEN
1013: NULL;
1014: ELSE
1015:
1016: UPDATE pa_ind_rate_sch_revisions
1017: SET
1018: last_update_date = SYSDATE,
1019: last_updated_by = x_last_updated_by,
1020: last_update_login = x_last_update_login,

Line 1096: -- UPDATE pa_ind_rate_sch_revisions

1092: --
1093: -- Set the compilation time in the rate schedule revision
1094: --
1095:
1096: -- UPDATE pa_ind_rate_sch_revisions
1097: -- SET
1098: -- last_update_date = SYSDATE,
1099: -- last_updated_by = x_last_updated_by,
1100: -- last_update_login = x_last_update_login,

Line 1255: UPDATE pa_ind_rate_sch_revisions

1251: --
1252: -- Set the compilation time in the rate schedule revision
1253: --
1254:
1255: UPDATE pa_ind_rate_sch_revisions
1256: SET
1257: last_update_date = SYSDATE,
1258: last_updated_by = x_last_updated_by,
1259: last_update_login = x_last_update_login,

Line 1552: FROM pa_ind_rate_sch_revisions irsr

1548:
1549: CURSOR sch_cursor
1550: IS
1551: SELECT ind_rate_sch_revision_id
1552: FROM pa_ind_rate_sch_revisions irsr
1553: WHERE irsr.compiled_flag = 'N'
1554: AND nvl(irsr.ready_to_compile_flag,'N') = 'Y'
1555: AND EXISTS (Select 1
1556: from pa_ind_cost_multipliers icm

Line 2061: rate_sch_rev_id PA_Ind_Rate_Sch_Revisions.Ind_Rate_Sch_Revision_ID%TYPE;

2057: total_burden_cost_project PA_Expenditure_Items.Project_Burdened_Cost%TYPE; /* ProjCurr Changes */
2058: qty PA_Expenditure_Items.Quantity%TYPE;
2059: compiled_set_id PA_Expenditure_Items.Cost_Ind_Compiled_Set_ID%TYPE;
2060: reason PA_Expenditure_Items.Ind_Cost_Dist_Rejection_Code%TYPE;
2061: rate_sch_rev_id PA_Ind_Rate_Sch_Revisions.Ind_Rate_Sch_Revision_ID%TYPE;
2062: status number(15);
2063: stage number(15);
2064: /*
2065: * Bug# 855461

Line 3025: from pa_ind_rate_sch_revisions

3021:
3022:
3023: select org_structure_version_id,start_organization_id
3024: into x_org_struc_ver_id,x_start_org
3025: from pa_ind_rate_sch_revisions
3026: where ind_rate_sch_revision_id = p_sch_rev_id;
3027:
3028:
3029: EXCEPTION

Line 3548: pa_ind_rate_sch_revisions

3544: SELECT
3545: cost_plus_structure
3546: INTO cp_structure
3547: FROM
3548: pa_ind_rate_sch_revisions
3549: WHERE
3550: ind_rate_sch_revision_id = rate_sch_rev_id;
3551:
3552: EXCEPTION

Line 3762: FROM pa_ind_rate_sch_revisions irsr

3758: -- Get the actual revision if there is one
3759: --
3760: SELECT irsr.ind_rate_sch_revision_id
3761: INTO rate_sch_rev_id
3762: FROM pa_ind_rate_sch_revisions irsr
3763: WHERE irsr.ind_rate_sch_id = sch_id
3764: AND TRUNC(base_date) BETWEEN
3765: TRUNC(irsr.start_date_active) AND
3766: TRUNC(NVL(irsr.end_date_active, base_date))

Line 3776: FROM pa_ind_rate_sch_revisions irsr

3772: -- Actual revision is not available
3773: --
3774: SELECT irsr.ind_rate_sch_revision_id
3775: INTO rate_sch_rev_id
3776: FROM pa_ind_rate_sch_revisions irsr
3777: WHERE irsr.ind_rate_sch_id = sch_id
3778: AND TRUNC(base_date) BETWEEN
3779: TRUNC(irsr.start_date_active) AND
3780: TRUNC(NVL(irsr.end_date_active, base_date));

Line 3894: FROM pa_ind_rate_sch_revisions

3890:
3891: CURSOR rev_cursor
3892: IS
3893: SELECT ind_rate_sch_revision_id
3894: FROM pa_ind_rate_sch_revisions
3895: WHERE cost_plus_structure = structure;
3896:
3897: BEGIN
3898:

Line 4096: l_cp_structure pa_ind_rate_sch_revisions.cost_plus_structure%TYPE ; /3054111/

4092: l_end_date date;
4093: rev_type varchar2(1);
4094: rev_done number;
4095: l_gms_enabled VARCHAR2(2) :='N'; /*3059344*/
4096: l_cp_structure pa_ind_rate_sch_revisions.cost_plus_structure%TYPE ; /*3054111*/
4097:
4098: l_this_fetch number:= 0;
4099: l_this_commit_cycle number:= 0;
4100: l_totally_fetched number:= 0;

Line 4150: INDEX(irsr PA_IND_RATE_SCH_REVISIONS_N1) */

4146:
4147: CURSOR cs2_cursor
4148: IS
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'

Line 4152: FROM pa_ind_rate_sch_revisions irsr,

4148: IS
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

Line 4164: FROM pa_ind_rate_sch_revisions irsr,

4160: CURSOR cs3_cursor
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;

Line 4214: FROM pa_ind_rate_sch_revisions irsr

4210: BEGIN
4211: SELECT ind_rate_sch_id, start_date_active, end_date_active,
4212: ind_rate_sch_revision_type,cost_plus_structure
4213: INTO sch_id, l_start_date, l_end_date, rev_type,l_cp_structure
4214: FROM pa_ind_rate_sch_revisions irsr
4215: WHERE ind_rate_sch_revision_id = rate_sch_rev_id;
4216: EXCEPTION
4217: WHEN OTHERS THEN
4218: gl_mc_currency_pkg.G_PA_UPGRADE_MODE := FALSE; /*Bug 4456789 */

Line 4724: FROM pa_ind_rate_sch_revisions irsr

4720: *** merged with a pervious select
4721: SELECT ind_rate_sch_id, start_date_active, end_date_active,
4722: ind_rate_sch_revision_type
4723: INTO sch_id, l_start_date, l_end_date, rev_type
4724: FROM pa_ind_rate_sch_revisions irsr
4725: WHERE ind_rate_sch_revision_id = rate_sch_rev_id;
4726: ****/
4727:
4728:

Line 7351: pa_ind_rate_sch_revisions sr,

7347: x_ind_rate_sch_revision_type,
7348: x_start_date_active,
7349: x_end_date_active
7350: from pa_ind_rate_schedules s,
7351: pa_ind_rate_sch_revisions sr,
7352: pa_lookups pl
7353: where s.ind_rate_sch_id = sr.ind_rate_sch_id
7354: and sr.ind_rate_sch_revision_type = pl.lookup_code
7355: and pl.lookup_type = 'IND RATE SCHEDULE REV TYPE'

Line 7646: pa_ind_rate_sch_revisions irsr

7642: CURSOR impacted_cost_code_cur(x_base VARCHAR2) **Cursor for all the cost codes of impacted cost bases**
7643: IS
7644: SELECT distinct cbicc.ind_cost_code
7645: FROM pa_cost_base_cost_codes cbicc,
7646: pa_ind_rate_sch_revisions irsr
7647: WHERE irsr.ind_rate_sch_revision_id = rate_sch_rev_id
7648: AND irsr.cost_plus_structure = cbicc.cost_plus_structure
7649: AND cbicc.cost_base = x_base
7650: AND cbicc.cost_base_type = INDIRECT_COST_CODE ;

Line 7797: PROCEDURE Cache_Impacted_Cost_Bases ( P_Ind_Rate_Sch_Revision_Id IN PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE

7793: WHEN OTHERS THEN
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

Line 7801: CURSOR impacted_cost_bases_cur( P_Ind_Rate_Sch_Revision_Id PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE

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
7803: )
7804: IS
7805: SELECT pcb.COST_BASE

Line 7829: PA_IND_rate_sch_revisions IRSR

7825: AND EXISTS
7826: (
7827: SELECT 1
7828: FROM PA_COST_BASE_COST_CODES CBICC,
7829: PA_IND_rate_sch_revisions IRSR
7830: WHERE IRSR.IND_RATE_SCH_REVISION_ID = P_Ind_Rate_Sch_Revision_Id
7831: AND nvl(G_MODULE ,'XXX') = 'NEW_ORG'
7832: AND IRSR.COST_PLUS_STRUCTURE= CBICC.COST_PLUS_STRUCTURE
7833: AND CBICC.COST_PLUS_STRUCTURE = P_Cp_Structure