DBA Data[Home] [Help]

APPS.PA_CI_TYPES_PVT dependencies on DUAL

Line 95: FROM sys.dual;

91:
92: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
93: SELECT pa_ci_types_b_s.NEXTVAL
94: INTO x_ci_type_id
95: FROM sys.dual;
96:
97: pa_ci_types_pkg.insert_row(
98: x_rowid => l_rowid,
99: x_ci_type_id => x_ci_type_id,

Line 140: FROM sys.dual;

136:
137: --Creating the distribution list
138: SELECT pa_distribution_lists_s.NEXTVAL
139: INTO x_dist_list_id
140: FROM sys.dual;
141:
142: l_dist_list_id := x_dist_list_id; -- Bug 4565156.
143:
144: pa_distribution_lists_pvt.create_dist_list (

Line 163: FROM sys.dual;

159:
160: -- Inserting record in pa_obj_status_lists
161: SELECT pa_obj_status_lists_s.NEXTVAL
162: INTO l_obj_status_list_id
163: FROM sys.dual;
164:
165: pa_obj_status_lists_pkg.INSERT_ROW (
166: X_ROWID => l_obj_sl_rowid,
167: X_OBJ_STATUS_LIST_ID => l_obj_status_list_id,