APPS.PA_COST_BASES_PKG dependencies on PA_COST_BASE_COST_CODES

Line 56: from pa_cost_base_cost_codes cbicc

52: into x_dummy
53: from sys.dual
54: where not exists
55: (select 1
56: from pa_cost_base_cost_codes cbicc
57: where cbicc.cost_base = x_cost_base);
58:
59: x_return_status := 0; -- ie. value does not exist is child table
60: -- delete allowed.

Line 102: -- as a FK in 3 tables, PA_COMPILED_MULTIPLIERS, PA_COST_BASE_COST_CODES

98:
99: ----------------------------------------------------------------------------
100: ----------------------------------------------------------------------------
101: -- this procedure will do a referential integrity check. Cost base appears
102: -- as a FK in 3 tables, PA_COMPILED_MULTIPLIERS, PA_COST_BASE_COST_CODES
103: -- and PA_COST_BASE_EXP_TYPES. However we may not check these tables in
104: -- all cases as it may not be logically relevant. So we will check against
105: -- the following. We will check against PA_COST_BASE_EXP_TYPES and
106: -- PA_COST_BASE_COST_CODES.

Line 106: -- PA_COST_BASE_COST_CODES.

102: -- as a FK in 3 tables, PA_COMPILED_MULTIPLIERS, PA_COST_BASE_COST_CODES
103: -- and PA_COST_BASE_EXP_TYPES. However we may not check these tables in
104: -- all cases as it may not be logically relevant. So we will check against
105: -- the following. We will check against PA_COST_BASE_EXP_TYPES and
106: -- PA_COST_BASE_COST_CODES.
107: -- Also if data exists in PA_COST_BASE_COST_CODES, we will check further
108: -- to see if the exp item has been costed.
109:
110: procedure check_references(x_return_status IN OUT NOCOPY number,

Line 107: -- Also if data exists in PA_COST_BASE_COST_CODES, we will check further

103: -- and PA_COST_BASE_EXP_TYPES. However we may not check these tables in
104: -- all cases as it may not be logically relevant. So we will check against
105: -- the following. We will check against PA_COST_BASE_EXP_TYPES and
106: -- PA_COST_BASE_COST_CODES.
107: -- Also if data exists in PA_COST_BASE_COST_CODES, we will check further
108: -- to see if the exp item has been costed.
109:
110: procedure check_references(x_return_status IN OUT NOCOPY number,
111: x_stage IN OUT NOCOPY number,

Line 127: from pa_cost_base_cost_codes cbicc

123: into x_dummy
124: from sys.dual
125: where not exists
126: (select 1
127: from pa_cost_base_cost_codes cbicc
128: where cbicc.cost_base = x_cost_base
129: and cbicc.cost_base_type = x_cost_base_type);
130:
131: x_return_status := 0; -- ie. value does not exist is child table

Line 148: from pa_cost_base_cost_codes cbicc,

144: -- have not been costed, the cost bases
145: -- exist in cbicc.
146: select 1
147: into x_dummy
148: from pa_cost_base_cost_codes cbicc,
149: pa_ind_cost_multipliers mul,
150: pa_ind_compiled_sets ics,
151: pa_expenditure_items ei
152: where cbicc.cost_base = x_cost_base