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 2407: pa_compiled_multipliers icpm

2403: --
2404: SELECT SUM(PA_CURRENCY.ROUND_CURRENCY_AMT((direct_cost * icpm.compiled_multiplier)))
2405: into indirect_cost_sum
2406: FROM pa_ind_compiled_sets ics,
2407: pa_compiled_multipliers icpm
2408: WHERE
2409: ics.ind_rate_sch_revision_id = rate_sch_rev_id
2410: AND ics.organization_id = org_id
2411: AND ics.status = 'A'

Line 2483: -- pa_compiled_multipliers icpm

2479: -- indirect_cost_denom_sum,
2480: -- indirect_cost_acct_sum,
2481: -- indirect_cost_project_sum
2482: -- FROM pa_ind_compiled_sets ics,
2483: -- pa_compiled_multipliers icpm
2484: -- WHERE
2485: -- ics.ind_rate_sch_revision_id = rate_sch_rev_id
2486: -- AND ics.organization_id = org_id
2487: -- AND ics.status = 'A'

Line 2505: pa_compiled_multipliers icpm

2501: indirect_cost_denom_sum,
2502: indirect_cost_acct_sum,
2503: indirect_cost_project_sum
2504: FROM pa_ind_compiled_sets ics,
2505: pa_compiled_multipliers icpm
2506: WHERE
2507: ics.ind_rate_sch_revision_id = rate_sch_rev_id
2508: AND ics.organization_id = org_id
2509: AND ics.status = 'A'

Line 7175: pa_compiled_multipliers icpm

7171:
7172: SELECT SUM(icpm.compiled_multiplier)
7173: INTO P_Compiled_multiplier
7174: FROM pa_ind_compiled_sets ics,
7175: pa_compiled_multipliers icpm
7176: WHERE ics.ind_rate_sch_revision_id = P_Rate_sch_rev_id
7177: AND ics.organization_id = P_Org_id
7178: AND ics.status = 'A'
7179: AND ics.ind_compiled_set_id = icpm.ind_compiled_set_id

Line 7205: FROM pa_compiled_multipliers icpm

7201: * which can be applied on the raw-cost to get the burden cost.
7202: */
7203: SELECT SUM(icpm.compiled_multiplier)
7204: INTO l_Compiled_multiplier
7205: FROM pa_compiled_multipliers icpm
7206: WHERE icpm.ind_compiled_set_id = P_Ind_Compiled_Set_Id;
7207: /*
7208: * No Compiled Multipliers available for the compiled set, passed.
7209: * Raise no_data_found exception explicitly.

Line 7262: DELETE pa_compiled_multipliers

7258: LOOP
7259:
7260: /* S.N. Bug 3946409
7261:
7262: DELETE pa_compiled_multipliers
7263: WHERE ind_compiled_set_id IN
7264: (SELECT ind_compiled_set_id
7265: FROM pa_ind_compiled_sets
7266: WHERE ind_rate_sch_revision_id = rate_sch_rev_id