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_COST_MULTIPLIERS

Line 50: TYPE multiplier_tab_type IS TABLE OF pa_ind_cost_multipliers.multiplier%TYPE

46: TYPE precedence_tab_type IS TABLE OF pa_compiled_multipliers.precedence%TYPE
47: INDEX BY BINARY_INTEGER;
48: TYPE ind_cost_code_tab_type IS TABLE OF
49: pa_compiled_multipliers.ind_cost_code%TYPE INDEX BY BINARY_INTEGER;
50: TYPE multiplier_tab_type IS TABLE OF pa_ind_cost_multipliers.multiplier%TYPE
51: INDEX BY BINARY_INTEGER;
52:
53: /***Bug# 2933915:Cursor for selecting impacted cost bases for which :
54: ****the organization/cost code has ready_to_compile_flag as 'Y' or 'X' i.e the multiplier is modified or deleted respectively in

Line 55: pa_ind_cost_multipliers

51: INDEX BY BINARY_INTEGER;
52:
53: /***Bug# 2933915:Cursor for selecting impacted cost bases for which :
54: ****the organization/cost code has ready_to_compile_flag as 'Y' or 'X' i.e the multiplier is modified or deleted respectively in
55: pa_ind_cost_multipliers
56: OR
57: ****G_MODULE ='NEW_ORG' i.e when we need to generate new compiled set ids in all the revisions for a new organization even when there
58: is no change to the burden schedule******************************/
59:

Line 69: PA_IND_COST_MULTIPLIERS ICM,

65: AND EXISTS
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')

Line 127: ind_cost_multiplier pa_ind_cost_multipliers.multiplier%TYPE;

123: --
124:
125: base pa_compiled_multipliers.compiled_multiplier%TYPE;
126: defined_org_id hr_organization_units.organization_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;

Line 130: ind_cost_multiplier_sum pa_ind_cost_multipliers.multiplier%TYPE;

126: defined_org_id hr_organization_units.organization_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;

Line 223: FROM pa_ind_cost_multipliers

219: INTO org_override
220: FROM sys.dual WHERE EXISTS
221: (SELECT /*+ FIRST_ROWS */
222: 1
223: FROM pa_ind_cost_multipliers
224: WHERE ind_rate_sch_revision_id = rate_sch_rev_id
225: AND organization_id = org_id
226: AND nvl(ready_to_compile_flag,'N') <> 'X') ;
227:

Line 405: FROM pa_ind_cost_multipliers icm,

401: INTO l_org_override
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

Line 487: pa_ind_cost_multipliers

483:
484: SELECT multiplier
485: INTO ind_cost_multiplier
486: FROM
487: pa_ind_cost_multipliers
488: WHERE
489: organization_id = defined_org_id
490: AND ind_cost_code = icc_row.ind_cost_code
491: AND ind_rate_sch_revision_id = rate_sch_rev_id

Line 1290: Inserting dummy enteries of 0 in pa_ind_cost_multipliers for Start Org and all the cost

1286: G_ORG_STRUC_VER_ID := org_struc_ver_id;
1287: G_START_ORGANIZATION_ID := start_org;
1288:
1289: /*Changes for Bug# 3055700:
1290: Inserting dummy enteries of 0 in pa_ind_cost_multipliers for Start Org and all the cost
1291: bases when the version is compiled .
1292: This has to be done when there exists no compiled set ids for ALL the cost bases with
1293: status 'A' for start_org .
1294: This will ensure that the compiled set ids are generated for all the orgs in hierarchy

Line 1344: INSERT into pa_ind_cost_multipliers (ind_rate_sch_revision_id,

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,
1345: organization_id,
1346: ind_cost_code,
1347: multiplier,
1348: last_update_date,

Line 1368: from pa_ind_cost_multipliers m

1364: from pa_cost_base_cost_codes cbicc
1365: where cbicc.cost_plus_structure = G_CP_STRUCTURE /* 4527736 */
1366: and cbicc.cost_base_type = INDIRECT_COST_CODE
1367: and cbicc.ind_cost_code not in (select m.ind_cost_code
1368: from pa_ind_cost_multipliers m
1369: where m.ind_rate_sch_revision_id = G_RATE_SCH_REVISION_ID /* 4527736 */
1370: and m.organization_id =start_org)
1371: group by cbicc.ind_cost_code;
1372:

Line 1501: DELETE pa_ind_cost_multipliers

1497: For reference :Ready_to_compile_flag 'X' records are actually deleted records but they were retained till this point of time for
1498: processing and treating them as impacted records***/
1499:
1500: /*3055700 :Deleting the dummy entries inserted earlier since by now processing is done*/
1501: DELETE pa_ind_cost_multipliers
1502: where ind_rate_sch_revision_id = G_RATE_SCH_REVISION_ID
1503: and organization_id = start_org
1504: and created_by = l_created_by ;
1505: /*3055700*/

Line 1507: DELETE pa_ind_cost_multipliers

1503: and organization_id = start_org
1504: and created_by = l_created_by ;
1505: /*3055700*/
1506:
1507: DELETE pa_ind_cost_multipliers
1508: where ind_rate_sch_revision_id = G_RATE_SCH_REVISION_ID
1509: and nvl(ready_to_compile_flag,'N') ='X';
1510:
1511: UPDATE pa_ind_cost_multipliers

Line 1511: UPDATE pa_ind_cost_multipliers

1507: DELETE pa_ind_cost_multipliers
1508: where ind_rate_sch_revision_id = G_RATE_SCH_REVISION_ID
1509: and nvl(ready_to_compile_flag,'N') ='X';
1510:
1511: UPDATE pa_ind_cost_multipliers
1512: set ready_to_compile_flag ='N'
1513: where ind_rate_sch_revision_id = G_RATE_SCH_REVISION_ID
1514: and nvl(ready_to_compile_flag,'N') ='Y';
1515:

Line 1556: from pa_ind_cost_multipliers icm

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
1557: WHERE icm.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
1558: AND nvl(icm.ready_to_compile_flag,'N') in ('Y','X'));
1559:
1560: -- Local variables

Line 4119: pa_ind_cost_multipliers icm

4115: IS
4116: SELECT
4117: DISTINCT cbicc.cost_base ,cbicc.cost_plus_structure
4118: FROM pa_cost_base_cost_codes cbicc,
4119: pa_ind_cost_multipliers icm
4120: WHERE icm.ind_rate_sch_revision_id = rate_sch_rev_id --3054111
4121: AND (nvl(icm.ready_to_compile_flag,'N') in ('Y','X') OR nvl(G_MODULE,'XXX') ='NEW_ORG')
4122: AND cbicc.cost_plus_structure = l_cp_structure --3054111
4123: AND cbicc.ind_cost_code = icm.ind_cost_code

Line 7525: in pa_ind_cost_multipliers .

7521:
7522: PURPOSE
7523: The objective of this procedure is to find the highest
7524: organizations with ready_to_compile_flag as 'Y'
7525: in pa_ind_cost_multipliers .
7526: This is to ensure that compilation starts from highest impacted orgs rather than from Start_org
7527: ***************************************************************************************************************/
7528:
7529: procedure find_impacted_top_org(rate_sch_rev_id IN number,

Line 7540: from pa_ind_cost_multipliers

7536:
7537: /*Cursor to select distinct organizations having ready_to_compile_flag as 'Y' */
7538: Cursor ready_to_compile_orgs is
7539: select DISTINCT organization_id
7540: from pa_ind_cost_multipliers
7541: where ind_rate_sch_revision_id = rate_sch_rev_id
7542: and nvl(ready_to_compile_flag,'N') in ('Y','X') ;
7543:
7544: l_count NUMBER ;

Line 7562: from pa_ind_cost_multipliers

7558: AND org_structure_version_id = ver_id
7559: START WITH organization_id_child = org.organization_id
7560: AND org_structure_version_id = ver_id) a
7561: WHERE a.organization_id_parent in (select DISTINCT organization_id
7562: from pa_ind_cost_multipliers
7563: where ind_rate_sch_revision_id = rate_sch_rev_id
7564: and nvl(ready_to_compile_flag,'N') in ('Y','X') );
7565:
7566:

Line 7599: from pa_ind_cost_multipliers

7595: AND org_structure_version_id = ver_id
7596: START WITH organization_id_child = org.organization_id
7597: AND org_structure_version_id = ver_id) b
7598: WHERE b.organization_id_parent in (select DISTINCT organization_id
7599: from pa_ind_cost_multipliers
7600: where ind_rate_sch_revision_id = rate_sch_rev_id
7601: and nvl(ready_to_compile_flag,'N') in ('Y','X'));
7602:
7603: /*There will not be many records in this table since we are storing only the top impacted org in this after full traversal of one

Line 7698: from pa_ind_cost_multipliers icm ,

7694: select 1 into org_override
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

Line 7725: from pa_ind_cost_multipliers icm ,

7721: from sys.dual
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

Line 7735: FROM PA_IND_COST_MULTIPLIERS ICM ,

7731: and nvl(icm.ready_to_compile_flag,'N') <> 'N'
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

Line 7813: PA_IND_COST_MULTIPLIERS ICM

7809: AND EXISTS
7810: (
7811: SELECT 1
7812: FROM PA_COST_BASE_COST_CODES CBICC,
7813: PA_IND_COST_MULTIPLIERS ICM
7814: WHERE ICM.IND_RATE_SCH_REVISION_ID = P_Ind_Rate_Sch_Revision_Id
7815: AND (NVL(ICM.READY_TO_COMPILE_FLAG,'N') IN ('Y','X') AND NVL(G_MODULE ,'XXX') <> 'NEW_ORG')/*4870539*/
7816: AND CBICC.COST_PLUS_STRUCTURE = P_Cp_Structure
7817: AND CBICC.IND_COST_CODE = ICM.IND_COST_CODE