DBA Data[Home] [Help]

APPS.PA_OPEN_ASSIGNMENT_PVT dependencies on PA_RES_FORMATS_B

Line 1171: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;

1167: l_cur_resource_list_member_id pa_project_assignments.resource_list_member_id%TYPE;
1168: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1169: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1170:
1171: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1172: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1173: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1174: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1175: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;

Line 1172: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;

1168: l_new_person_id pa_resource_txn_attributes.person_id%TYPE;
1169: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1170:
1171: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1172: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1173: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1174: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1175: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1176:

Line 1173: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;

1169: l_named_role pa_project_assignments.ASSIGNMENT_NAME%TYPE;
1170:
1171: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1172: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1173: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1174: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1175: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1176:
1177: -- l_unlink_flag VARCHAR2(1) := 'N';

Line 1174: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;

1170:
1171: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1172: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1173: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1174: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1175: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1176:
1177: -- l_unlink_flag VARCHAR2(1) := 'N';
1178:

Line 1175: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;

1171: l_cur_res_format_id pa_res_formats_b.res_format_id%TYPE;
1172: l_cur_res_type_flag pa_res_formats_b.res_type_enabled_flag%TYPE;
1173: l_cur_orgn_flag pa_res_formats_b.orgn_enabled_flag%TYPE;
1174: l_cur_fin_cat_flag pa_res_formats_b.fin_cat_enabled_flag%TYPE;
1175: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1176:
1177: -- l_unlink_flag VARCHAR2(1) := 'N';
1178:
1179: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 1297: FROM pa_res_formats_b rf,

1293: CURSOR get_res_mand_attributes IS
1294: SELECT rf.res_format_id, rf.RES_TYPE_ENABLED_FLAG,
1295: rf.ORGN_ENABLED_FLAG, rf.FIN_CAT_ENABLED_FLAG,
1296: rf.ROLE_ENABLED_FLAG
1297: FROM pa_res_formats_b rf,
1298: pa_resource_list_members rlm
1299: WHERE rlm.res_format_id = rf.res_format_id
1300: AND rlm.resource_list_member_id = l_assignment_rec.resource_list_member_id;
1301: