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.1 2005/08/08 10:51:26 sbharath noship $
3: -----------------------------------------------------------------------------
4: procedure copy_multipliers (x_return_status IN OUT NOCOPY number,
5: x_stage IN OUT NOCOPY number,

Line 30: delete from pa_ind_cost_multipliers

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

Line 35: insert into pa_ind_cost_multipliers (ind_rate_sch_revision_id,

31: where
32: ind_rate_sch_revision_id = x_ind_rate_sch_rev_id_to
33: and ready_to_compile_flag = 'X';
34:
35: insert into pa_ind_cost_multipliers (ind_rate_sch_revision_id,
36: organization_id,
37: ind_cost_code,
38: multiplier,
39: last_update_date,

Line 55: from pa_ind_cost_multipliers m

51: x_created_by,
52: SYSDATE,
53: x_last_update_login,
54: 'Y'
55: from pa_ind_cost_multipliers m
56: where m.ind_rate_sch_revision_id = x_ind_rate_sch_rev_id_from
57: and nvl(m.ready_to_compile_flag, 'N') <> 'X';
58:
59: COMMIT;

Line 93: from pa_ind_cost_multipliers m

89: into x_dummy
90: from sys.dual
91: where not exists
92: (select 1
93: from pa_ind_cost_multipliers m
94: where m.ind_rate_sch_revision_id =
95: x_ind_rate_sch_revision_id
96: and nvl(m.ready_to_compile_flag,'N') <> 'X');
97:

Line 115: end PA_IND_COST_MULTIPLIERS_PKG;

111:
112: end check_references;
113: ----------------------------------------------------------------------------
114:
115: end PA_IND_COST_MULTIPLIERS_PKG;