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 4089: pa_ind_cost_multipliers icm

4085: IS
4086: SELECT
4087: DISTINCT cbicc.cost_base ,cbicc.cost_plus_structure
4088: FROM pa_cost_base_cost_codes cbicc,
4089: pa_ind_cost_multipliers icm
4090: WHERE icm.ind_rate_sch_revision_id = rate_sch_rev_id --3054111
4091: AND (nvl(icm.ready_to_compile_flag,'N') in ('Y','X') OR nvl(G_MODULE,'XXX') ='NEW_ORG')
4092: AND cbicc.cost_plus_structure = l_cp_structure --3054111
4093: AND cbicc.ind_cost_code = icm.ind_cost_code

Line 7298: in pa_ind_cost_multipliers .

7294:
7295: PURPOSE
7296: The objective of this procedure is to find the highest
7297: organizations with ready_to_compile_flag as 'Y'
7298: in pa_ind_cost_multipliers .
7299: This is to ensure that compilation starts from highest impacted orgs rather than from Start_org
7300: ***************************************************************************************************************/
7301:
7302: procedure find_impacted_top_org(rate_sch_rev_id IN number,

Line 7313: from pa_ind_cost_multipliers

7309:
7310: /*Cursor to select distinct organizations having ready_to_compile_flag as 'Y' */
7311: Cursor ready_to_compile_orgs is
7312: select DISTINCT organization_id
7313: from pa_ind_cost_multipliers
7314: where ind_rate_sch_revision_id = rate_sch_rev_id
7315: and nvl(ready_to_compile_flag,'N') in ('Y','X') ;
7316:
7317: l_count NUMBER ;

Line 7335: from pa_ind_cost_multipliers

7331: AND org_structure_version_id = ver_id
7332: START WITH organization_id_child = org.organization_id
7333: AND org_structure_version_id = ver_id) a
7334: WHERE a.organization_id_parent in (select DISTINCT organization_id
7335: from pa_ind_cost_multipliers
7336: where ind_rate_sch_revision_id = rate_sch_rev_id
7337: and nvl(ready_to_compile_flag,'N') in ('Y','X') );
7338:
7339:

Line 7372: from pa_ind_cost_multipliers

7368: AND org_structure_version_id = ver_id
7369: START WITH organization_id_child = org.organization_id
7370: AND org_structure_version_id = ver_id) b
7371: WHERE b.organization_id_parent in (select DISTINCT organization_id
7372: from pa_ind_cost_multipliers
7373: where ind_rate_sch_revision_id = rate_sch_rev_id
7374: and nvl(ready_to_compile_flag,'N') in ('Y','X'));
7375:
7376: /*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 7462: from pa_ind_cost_multipliers icm ,

7458: BEGIN
7459: select 1 into org_override
7460: from sys.dual
7461: where exists(select 1
7462: from pa_ind_cost_multipliers icm ,
7463: pa_ind_compiled_sets ics
7464: where icm.ind_rate_sch_revision_id =ics.ind_rate_sch_revision_id
7465: and icm.ind_rate_sch_revision_id = rate_sch_rev_id
7466: AND icm.organization_id =ics.organization_id

Line 7482: from pa_ind_cost_multipliers icm ,

7478: from sys.dual
7479: where exists
7480: (
7481: select 1
7482: from pa_ind_cost_multipliers icm ,
7483: pa_ind_compiled_sets ics
7484: where icm.ind_rate_sch_revision_id =ics.ind_rate_sch_revision_id
7485: and icm.ind_rate_sch_revision_id = rate_sch_rev_id
7486: and icm.organization_id =ics.organization_id

Line 7544: PA_IND_COST_MULTIPLIERS ICM

7540: AND EXISTS
7541: (
7542: SELECT 1
7543: FROM PA_COST_BASE_COST_CODES CBICC,
7544: PA_IND_COST_MULTIPLIERS ICM
7545: WHERE ICM.IND_RATE_SCH_REVISION_ID = P_Ind_Rate_Sch_Revision_Id
7546: AND (NVL(ICM.READY_TO_COMPILE_FLAG,'N') IN ('Y','X') AND NVL(G_MODULE ,'XXX') <> 'NEW_ORG')/*4870539*/
7547: AND CBICC.COST_PLUS_STRUCTURE = P_Cp_Structure
7548: AND CBICC.IND_COST_CODE = ICM.IND_COST_CODE