APPS.PA_FP_WEBADI_PKG dependencies on PA_RESOURCE_ASSIGNMENTS_S

Line 1855: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;

1851:
1852: l_fixed_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
1853: l_fixed_spread_curve_name pa_spread_curves_tl.name%TYPE;
1854: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
1855: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
1856: l_not_null_period_cnt NUMBER;
1857: l_fix_sc_amt_pd_curr_index NUMBER; /* to get the period index for which amount is present if the spread curve */
1858: l_fix_sc_amt_pd_next_index NUMBER; /* associated with the resource is fixed date type */
1859:

Line 8742: --Note down the current value of pa_resource_assignments_s.nextval

8738: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8739: END IF;
8740: -- Calling add_planning_transaction for those records for which RA doesnot exists
8741:
8742: --Note down the current value of pa_resource_assignments_s.nextval
8743: BEGIN
8744: --log1('----- STAGE PBL15-------');
8745: SELECT pa_resource_assignments_s.nextval
8746: INTO l_curr_ra_id_seq

Line 8745: SELECT pa_resource_assignments_s.nextval

8741:
8742: --Note down the current value of pa_resource_assignments_s.nextval
8743: BEGIN
8744: --log1('----- STAGE PBL15-------');
8745: SELECT pa_resource_assignments_s.nextval
8746: INTO l_curr_ra_id_seq
8747: FROM DUAL
8748: WHERE 1 = 1;
8749: --log1('----- STAGE PBL16-------');