DBA Data[Home] [Help]

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_RES_FORMATS_B

Line 1302: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;

1298: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1299: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1300: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1301:
1302: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1303: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1304: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1305: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1306: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;

Line 1303: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;

1299: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1300: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1301:
1302: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1303: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1304: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1305: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1306: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1307:

Line 1304: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;

1300: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1301:
1302: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1303: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1304: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1305: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1306: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1307:
1308: -- l_unlink_flag VARCHAR2(1) := 'N';

Line 1305: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;

1301:
1302: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1303: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1304: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1305: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1306: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1307:
1308: -- l_unlink_flag VARCHAR2(1) := 'N';
1309:

Line 1306: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;

1302: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1303: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1304: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1305: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1306: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1307:
1308: -- l_unlink_flag VARCHAR2(1) := 'N';
1309:
1310: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 1433: FROM pa_res_formats_b rf,

1429: CURSOR get_res_mand_attributes IS
1430: SELECT rf.res_format_id, rf.RES_TYPE_ENABLED_FLAG,
1431: rf.ORGN_ENABLED_FLAG, rf.FIN_CAT_ENABLED_FLAG,
1432: rf.ROLE_ENABLED_FLAG
1433: FROM pa_res_formats_b rf,
1434: pa_resource_list_members rlm
1435: WHERE rlm.res_format_id = rf.res_format_id
1436: AND rlm.resource_list_member_id = l_assignment_rec.resource_list_member_id;
1437: