DBA Data[Home] [Help]

APPS.PA_CI_TYPES_PVT dependencies on DUAL

Line 117: FROM sys.dual;

113:
114: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
115: SELECT pa_ci_types_b_s.NEXTVAL
116: INTO x_ci_type_id
117: FROM sys.dual;
118:
119: pa_ci_types_pkg.insert_row(
120: x_rowid => l_rowid,
121: x_ci_type_id => x_ci_type_id,

Line 176: FROM sys.dual;

172:
173: --Creating the distribution list
174: SELECT pa_distribution_lists_s.NEXTVAL
175: INTO x_dist_list_id
176: FROM sys.dual;
177:
178: l_dist_list_id := x_dist_list_id; -- Bug 4565156.
179:
180: pa_distribution_lists_pvt.create_dist_list (

Line 199: FROM sys.dual;

195:
196: -- Inserting record in pa_obj_status_lists
197: SELECT pa_obj_status_lists_s.NEXTVAL
198: INTO l_obj_status_list_id
199: FROM sys.dual;
200:
201: pa_obj_status_lists_pkg.INSERT_ROW (
202: X_ROWID => l_obj_sl_rowid,
203: X_OBJ_STATUS_LIST_ID => l_obj_status_list_id,