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 2060: rate_sch_rev_id PA_Ind_Rate_Sch_Revisions.Ind_Rate_Sch_Revision_ID%TYPE;

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

Line 2995: from pa_ind_rate_sch_revisions

2991:
2992:
2993: select org_structure_version_id,start_organization_id
2994: into x_org_struc_ver_id,x_start_org
2995: from pa_ind_rate_sch_revisions
2996: where ind_rate_sch_revision_id = p_sch_rev_id;
2997:
2998:
2999: EXCEPTION

Line 3518: pa_ind_rate_sch_revisions

3514: SELECT
3515: cost_plus_structure
3516: INTO cp_structure
3517: FROM
3518: pa_ind_rate_sch_revisions
3519: WHERE
3520: ind_rate_sch_revision_id = rate_sch_rev_id;
3521:
3522: EXCEPTION

Line 3732: FROM pa_ind_rate_sch_revisions irsr

3728: -- Get the actual revision if there is one
3729: --
3730: SELECT irsr.ind_rate_sch_revision_id
3731: INTO rate_sch_rev_id
3732: FROM pa_ind_rate_sch_revisions irsr
3733: WHERE irsr.ind_rate_sch_id = sch_id
3734: AND TRUNC(base_date) BETWEEN
3735: TRUNC(irsr.start_date_active) AND
3736: TRUNC(NVL(irsr.end_date_active, base_date))

Line 3746: FROM pa_ind_rate_sch_revisions irsr

3742: -- Actual revision is not available
3743: --
3744: SELECT irsr.ind_rate_sch_revision_id
3745: INTO rate_sch_rev_id
3746: FROM pa_ind_rate_sch_revisions irsr
3747: WHERE irsr.ind_rate_sch_id = sch_id
3748: AND TRUNC(base_date) BETWEEN
3749: TRUNC(irsr.start_date_active) AND
3750: TRUNC(NVL(irsr.end_date_active, base_date));

Line 3864: FROM pa_ind_rate_sch_revisions

3860:
3861: CURSOR rev_cursor
3862: IS
3863: SELECT ind_rate_sch_revision_id
3864: FROM pa_ind_rate_sch_revisions
3865: WHERE cost_plus_structure = structure;
3866:
3867: BEGIN
3868:

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

4062: l_end_date date;
4063: rev_type varchar2(1);
4064: rev_done number;
4065: l_gms_enabled VARCHAR2(2) :='N'; /*3059344*/
4066: l_cp_structure pa_ind_rate_sch_revisions.cost_plus_structure%TYPE ; /*3054111*/
4067:
4068: l_this_fetch number:= 0;
4069: l_this_commit_cycle number:= 0;
4070: l_totally_fetched number:= 0;

Line 4120: INDEX(irsr PA_IND_RATE_SCH_REVISIONS_N1) */

4116:
4117: CURSOR cs2_cursor
4118: IS
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'

Line 4122: FROM pa_ind_rate_sch_revisions irsr,

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

Line 4134: FROM pa_ind_rate_sch_revisions irsr,

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

Line 4184: FROM pa_ind_rate_sch_revisions irsr

4180: BEGIN
4181: SELECT ind_rate_sch_id, start_date_active, end_date_active,
4182: ind_rate_sch_revision_type,cost_plus_structure
4183: INTO sch_id, l_start_date, l_end_date, rev_type,l_cp_structure
4184: FROM pa_ind_rate_sch_revisions irsr
4185: WHERE ind_rate_sch_revision_id = rate_sch_rev_id;
4186: EXCEPTION
4187: WHEN OTHERS THEN
4188: gl_mc_currency_pkg.G_PA_UPGRADE_MODE := FALSE; /*Bug 4456789 */

Line 4694: FROM pa_ind_rate_sch_revisions irsr

4690: *** merged with a pervious select
4691: SELECT ind_rate_sch_id, start_date_active, end_date_active,
4692: ind_rate_sch_revision_type
4693: INTO sch_id, l_start_date, l_end_date, rev_type
4694: FROM pa_ind_rate_sch_revisions irsr
4695: WHERE ind_rate_sch_revision_id = rate_sch_rev_id;
4696: ****/
4697:
4698:

Line 7124: pa_ind_rate_sch_revisions sr,

7120: x_ind_rate_sch_revision_type,
7121: x_start_date_active,
7122: x_end_date_active
7123: from pa_ind_rate_schedules s,
7124: pa_ind_rate_sch_revisions sr,
7125: pa_lookups pl
7126: where s.ind_rate_sch_id = sr.ind_rate_sch_id
7127: and sr.ind_rate_sch_revision_type = pl.lookup_code
7128: and pl.lookup_type = 'IND RATE SCHEDULE REV TYPE'

Line 7419: pa_ind_rate_sch_revisions irsr

7415: CURSOR impacted_cost_code_cur(x_base VARCHAR2) **Cursor for all the cost codes of impacted cost bases**
7416: IS
7417: SELECT distinct cbicc.ind_cost_code
7418: FROM pa_cost_base_cost_codes cbicc,
7419: pa_ind_rate_sch_revisions irsr
7420: WHERE irsr.ind_rate_sch_revision_id = rate_sch_rev_id
7421: AND irsr.cost_plus_structure = cbicc.cost_plus_structure
7422: AND cbicc.cost_base = x_base
7423: AND cbicc.cost_base_type = INDIRECT_COST_CODE ;

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

7524: WHEN OTHERS THEN
7525: RAISE;
7526: END check_for_explicit_multiplier ; /*3012681*/
7527:
7528: PROCEDURE Cache_Impacted_Cost_Bases ( P_Ind_Rate_Sch_Revision_Id IN PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE
7529: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
7530: )
7531: IS
7532: CURSOR impacted_cost_bases_cur( P_Ind_Rate_Sch_Revision_Id PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE

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

7528: PROCEDURE Cache_Impacted_Cost_Bases ( P_Ind_Rate_Sch_Revision_Id IN PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE
7529: ,P_Cp_Structure IN PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
7530: )
7531: IS
7532: CURSOR impacted_cost_bases_cur( P_Ind_Rate_Sch_Revision_Id PA_IND_RATE_SCH_REVISIONS.IND_RATE_SCH_REVISION_ID%TYPE
7533: ,P_Cp_Structure PA_COST_PLUS_STRUCTURES.COST_PLUS_STRUCTURE%TYPE
7534: )
7535: IS
7536: SELECT pcb.COST_BASE

Line 7560: PA_IND_rate_sch_revisions IRSR

7556: AND EXISTS
7557: (
7558: SELECT 1
7559: FROM PA_COST_BASE_COST_CODES CBICC,
7560: PA_IND_rate_sch_revisions IRSR
7561: WHERE IRSR.IND_RATE_SCH_REVISION_ID = P_Ind_Rate_Sch_Revision_Id
7562: AND nvl(G_MODULE ,'XXX') = 'NEW_ORG'
7563: AND IRSR.COST_PLUS_STRUCTURE= CBICC.COST_PLUS_STRUCTURE
7564: AND CBICC.COST_PLUS_STRUCTURE = P_Cp_Structure