APPS.PA_IND_COST_MULTIPLIERS_PKG dependencies on PA_IND_COST_MULTIPLIERS

Line 1: package body PA_IND_COST_MULTIPLIERS_PKG as

1: package body PA_IND_COST_MULTIPLIERS_PKG as
2: -- $Header: PAXCMULB.pls 120.2 2009/05/08 07:28:57 sgottimu ship $
3: -----------------------------------------------------------------------------
4: procedure copy_multipliers (x_return_status IN OUT NOCOPY number,
5: x_stage IN OUT NOCOPY number,

Line 31: delete from pa_ind_cost_multipliers

27: Inserting only those multipliers with ready_to_compile_flag <> 'X'.
28: Also added the statement to delete multipliers with ready_to_compile_flag as 'X'
29: prior to insertion. */
30:
31: delete from pa_ind_cost_multipliers
32: where
33: ind_rate_sch_revision_id = x_ind_rate_sch_rev_id_to
34: and ready_to_compile_flag = 'X';
35:

Line 38: insert into pa_ind_cost_multipliers (ind_rate_sch_revision_id,

34: and ready_to_compile_flag = 'X';
35:
36: /* Changes for 7391889 start here */
37: IF x_calling_module = 'CAP_INT' THEN
38: insert into pa_ind_cost_multipliers (ind_rate_sch_revision_id,
39: organization_id,
40: ind_cost_code,
41: multiplier,
42: last_update_date,

Line 58: from pa_ind_cost_multipliers m

54: x_created_by,
55: SYSDATE,
56: x_last_update_login,
57: 'Y'
58: from pa_ind_cost_multipliers m
59: where m.ind_rate_sch_revision_id = x_ind_rate_sch_rev_id_from
60: and nvl(m.ready_to_compile_flag, 'N') <> 'X';
61:
62: ELSE /* Changes for 7391889 end here */

Line 64: insert into pa_ind_cost_multipliers (ind_rate_sch_revision_id,

60: and nvl(m.ready_to_compile_flag, 'N') <> 'X';
61:
62: ELSE /* Changes for 7391889 end here */
63:
64: insert into pa_ind_cost_multipliers (ind_rate_sch_revision_id,
65: organization_id,
66: ind_cost_code,
67: multiplier,
68: last_update_date,

Line 84: from pa_ind_cost_multipliers m

80: x_created_by,
81: SYSDATE,
82: x_last_update_login,
83: 'Y'
84: from pa_ind_cost_multipliers m
85: where m.ind_rate_sch_revision_id = x_ind_rate_sch_rev_id_from
86: and nvl(m.ready_to_compile_flag, 'N') <> 'X';
87:
88: END IF; /* Added for 7391889 */

Line 124: from pa_ind_cost_multipliers m

120: into x_dummy
121: from sys.dual
122: where not exists
123: (select 1
124: from pa_ind_cost_multipliers m
125: where m.ind_rate_sch_revision_id =
126: x_ind_rate_sch_revision_id
127: and nvl(m.ready_to_compile_flag,'N') <> 'X');
128:

Line 146: end PA_IND_COST_MULTIPLIERS_PKG;

142:
143: end check_references;
144: ----------------------------------------------------------------------------
145:
146: end PA_IND_COST_MULTIPLIERS_PKG;