APPS.PA_COST_PLUS dependencies on PA_COMPILED_MULTIPLIERS

Line 46: TYPE precedence_tab_type IS TABLE OF pa_compiled_multipliers.precedence%TYPE

42: */
43:
44:
45: -- Package 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

Line 49: pa_compiled_multipliers.ind_cost_code%TYPE INDEX BY BINARY_INTEGER;

45: -- Package 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 :

Line 125: base pa_compiled_multipliers.compiled_multiplier%TYPE;

121: --
122: -- VARIABLE definition
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;

Line 590: INSERT INTO pa_compiled_multipliers

586: --
587: -- Enter the compiled rate into table
588: --
589:
590: INSERT INTO pa_compiled_multipliers
591: (ind_compiled_set_id,
592: cost_base_cost_code_id,
593: cost_base,
594: ind_cost_code,

Line 1438: DELETE pa_compiled_multipliers

1434:
1435: --
1436: -- Remove redundant compiled sets and multipiers.
1437: --
1438: DELETE pa_compiled_multipliers
1439: WHERE ind_compiled_set_id IN
1440: (SELECT ind_compiled_set_id
1441: FROM pa_ind_compiled_sets
1442: WHERE ind_rate_sch_revision_id = rate_sch_rev_id);

Line 1653: compiled_multiplier pa_compiled_multipliers.compiled_multiplier%TYPE;

1649: burden_cost_denom pa_expenditure_items_all.denom_burdened_cost%TYPE;
1650: burden_cost_acct pa_expenditure_items_all.acct_burdened_cost%TYPE;
1651: burden_cost_project pa_expenditure_items_all.project_burdened_cost%TYPE; /* ProjCurr Changes */
1652: system_linkage pa_expenditure_items_all.system_linkage_function%TYPE;
1653: compiled_multiplier pa_compiled_multipliers.compiled_multiplier%TYPE;
1654:
1655: BEGIN
1656:
1657: -- Initialize output parameters

Line 2437: pa_compiled_multipliers icpm

2433: --
2434: SELECT SUM(PA_CURRENCY.ROUND_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier)))
2435: into indirect_cost_sum
2436: FROM pa_ind_compiled_sets ics,
2437: pa_compiled_multipliers icpm
2438: WHERE
2439: ics.ind_rate_sch_revision_id = rate_sch_rev_id
2440: AND ics.organization_id = org_id
2441: AND ics.status = 'A'

Line 2513: -- pa_compiled_multipliers icpm

2509: -- indirect_cost_denom_sum,
2510: -- indirect_cost_acct_sum,
2511: -- indirect_cost_project_sum
2512: -- FROM pa_ind_compiled_sets ics,
2513: -- pa_compiled_multipliers icpm
2514: -- WHERE
2515: -- ics.ind_rate_sch_revision_id = rate_sch_rev_id
2516: -- AND ics.organization_id = org_id
2517: -- AND ics.status = 'A'

Line 2535: pa_compiled_multipliers icpm

2531: indirect_cost_denom_sum,
2532: indirect_cost_acct_sum,
2533: indirect_cost_project_sum
2534: FROM pa_ind_compiled_sets ics,
2535: pa_compiled_multipliers icpm
2536: WHERE
2537: ics.ind_rate_sch_revision_id = rate_sch_rev_id
2538: AND ics.organization_id = org_id
2539: AND ics.status = 'A'

Line 7402: pa_compiled_multipliers icpm

7398:
7399: SELECT SUM(icpm.compiled_multiplier)
7400: INTO P_Compiled_multiplier
7401: FROM pa_ind_compiled_sets ics,
7402: pa_compiled_multipliers icpm
7403: WHERE ics.ind_rate_sch_revision_id = P_Rate_sch_rev_id
7404: AND ics.organization_id = P_Org_id
7405: AND ics.status = 'A'
7406: AND ics.ind_compiled_set_id = icpm.ind_compiled_set_id

Line 7432: FROM pa_compiled_multipliers icpm

7428: * which can be applied on the raw-cost to get the burden cost.
7429: */
7430: SELECT SUM(icpm.compiled_multiplier)
7431: INTO l_Compiled_multiplier
7432: FROM pa_compiled_multipliers icpm
7433: WHERE icpm.ind_compiled_set_id = P_Ind_Compiled_Set_Id;
7434: /*
7435: * No Compiled Multipliers available for the compiled set, passed.
7436: * Raise no_data_found exception explicitly.

Line 7489: DELETE pa_compiled_multipliers

7485: LOOP
7486:
7487: /* S.N. Bug 3946409
7488:
7489: DELETE pa_compiled_multipliers
7490: WHERE ind_compiled_set_id IN
7491: (SELECT ind_compiled_set_id
7492: FROM pa_ind_compiled_sets
7493: WHERE ind_rate_sch_revision_id = rate_sch_rev_id