DBA Data[Home] [Help]

APPS.PA_OPEN_ASSIGNMENT_PVT dependencies on PA_RES_FORMATS_B

Line 1177: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;

1173: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1174: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1175: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1176:
1177: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1178: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1179: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1180: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1181: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;

Line 1178: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;

1174: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1175: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1176:
1177: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1178: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1179: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1180: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1181: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1182:

Line 1179: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;

1175: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1176:
1177: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1178: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1179: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1180: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1181: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1182:
1183: -- l_unlink_flag VARCHAR2(1) := 'N';

Line 1180: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;

1176:
1177: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1178: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1179: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1180: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1181: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1182:
1183: -- l_unlink_flag VARCHAR2(1) := 'N';
1184:

Line 1181: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;

1177: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1178: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1179: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1180: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1181: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1182:
1183: -- l_unlink_flag VARCHAR2(1) := 'N';
1184:
1185: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 1303: FROM pa_res_formats_b rf,

1299: CURSOR get_res_mand_attributes IS
1300: SELECT rf.res_format_id, rf.RES_TYPE_ENABLED_FLAG,
1301: rf.ORGN_ENABLED_FLAG, rf.FIN_CAT_ENABLED_FLAG,
1302: rf.ROLE_ENABLED_FLAG
1303: FROM pa_res_formats_b rf,
1304: pa_resource_list_members rlm
1305: WHERE rlm.res_format_id = rf.res_format_id
1306: AND rlm.resource_list_member_id = l_assignment_rec.resource_list_member_id;
1307: