APPS.PA_FP_WEBADI_PKG dependencies on PA_RESOURCE_ASSIGNMENTS_S

Line 1857: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;

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

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

8902: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8903: END IF;
8904: -- Calling add_planning_transaction for those records for which RA doesnot exists
8905:
8906: --Note down the current value of pa_resource_assignments_s.nextval
8907: BEGIN
8908: --log1('----- STAGE PBL15-------');
8909: SELECT pa_resource_assignments_s.nextval
8910: INTO l_curr_ra_id_seq

Line 8909: SELECT pa_resource_assignments_s.nextval

8905:
8906: --Note down the current value of pa_resource_assignments_s.nextval
8907: BEGIN
8908: --log1('----- STAGE PBL15-------');
8909: SELECT pa_resource_assignments_s.nextval
8910: INTO l_curr_ra_id_seq
8911: FROM DUAL
8912: WHERE 1 = 1;
8913: --log1('----- STAGE PBL16-------');