APPS.PA_CI_TYPES_PVT dependencies on PA_OBJ_STATUS_LISTS

Line 196: -- Inserting record in pa_obj_status_lists

192: x_msg_data => x_msg_data);
193:
194: x_dist_list_id := l_dist_list_id; -- Bug 4565156.
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:

Line 197: SELECT pa_obj_status_lists_s.NEXTVAL

193:
194: x_dist_list_id := l_dist_list_id; -- Bug 4565156.
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 (

Line 201: pa_obj_status_lists_pkg.INSERT_ROW (

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,
204: X_OBJECT_TYPE => 'PA_CI_TYPES',
205: X_OBJECT_ID => x_ci_type_id,

Line 953: pa_obj_status_lists_pkg.UPDATE_ROW (

949: X_DIR_REG_REV_COL_FLAG => P_DIR_REG_REV_COL_FLAG);
950: --|end 29-APR-2009 cklee R12.1.2 setup ehancement v2
951:
952:
953: pa_obj_status_lists_pkg.UPDATE_ROW (
954: X_OBJ_STATUS_LIST_ID => p_obj_status_list_id,
955: X_OBJECT_TYPE => 'PA_CI_TYPES',
956: X_OBJECT_ID => p_ci_type_id,
957: X_STATUS_LIST_ID => p_status_list_id,

Line 1041: FROM pa_obj_status_lists

1037: WHERE ci_type_id = p_ci_type_id;
1038:
1039: CURSOR c_obj_status_lists IS
1040: SELECT *
1041: FROM pa_obj_status_lists
1042: WHERE obj_status_list_id = p_obj_status_list_id;
1043:
1044: l_temp VARCHAR2(1);
1045: BEGIN

Line 1147: --Deleting the association from pa_obj_status_lists

1143: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
1144: pa_ci_types_pkg.delete_row(
1145: x_ci_type_id => p_ci_type_id);
1146:
1147: --Deleting the association from pa_obj_status_lists
1148: pa_obj_status_lists_pkg.delete_row(
1149: x_obj_status_list_id => p_obj_status_list_id);
1150: END IF;
1151:

Line 1148: pa_obj_status_lists_pkg.delete_row(

1144: pa_ci_types_pkg.delete_row(
1145: x_ci_type_id => p_ci_type_id);
1146:
1147: --Deleting the association from pa_obj_status_lists
1148: pa_obj_status_lists_pkg.delete_row(
1149: x_obj_status_list_id => p_obj_status_list_id);
1150: END IF;
1151:
1152: IF p_commit = fnd_api.g_true THEN