DBA Data[Home] [Help]

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_RES_FORMATS_B

Line 1271: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;

1267: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1268: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1269: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1270:
1271: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1272: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1273: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1274: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1275: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;

Line 1272: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;

1268: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1269: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1270:
1271: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1272: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1273: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1274: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1275: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1276:

Line 1273: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;

1269: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1270:
1271: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1272: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1273: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1274: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1275: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1276:
1277: -- l_unlink_flag VARCHAR2(1) := 'N';

Line 1274: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;

1270:
1271: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1272: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1273: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1274: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1275: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1276:
1277: -- l_unlink_flag VARCHAR2(1) := 'N';
1278:

Line 1275: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;

1271: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1272: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1273: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1274: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1275: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1276:
1277: -- l_unlink_flag VARCHAR2(1) := 'N';
1278:
1279: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 1402: FROM pa_res_formats_b rf,

1398: CURSOR get_res_mand_attributes IS
1399: SELECT rf.res_format_id, rf.RES_TYPE_ENABLED_FLAG,
1400: rf.ORGN_ENABLED_FLAG, rf.FIN_CAT_ENABLED_FLAG,
1401: rf.ROLE_ENABLED_FLAG
1402: FROM pa_res_formats_b rf,
1403: pa_resource_list_members rlm
1404: WHERE rlm.res_format_id = rf.res_format_id
1405: AND rlm.resource_list_member_id = l_assignment_rec.resource_list_member_id;
1406: