APPS.PA_PROGRESS_UTILS dependencies on PA_BILLING_CYCLES

Line 198: x_next_reporting_date := PA_Billing_Cycles_Pkg.Get_Billing_Date(l_Object_Id

194: if (l_next_reporting_date is null) then
195: l_next_reporting_date := trunc(sysdate);
196: end if;
197:
198: x_next_reporting_date := PA_Billing_Cycles_Pkg.Get_Billing_Date(l_Object_Id
199: ,l_next_reporting_date+1
200: ,l_Report_Cycle_Id
201: ,sysdate
202: ,l_next_reporting_date);

Line 275: l_reporting_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date(

271:
272: if ( l_reporting_date is not null and l_reporting_date < l_sysdate
273: and l_cycle_id is not null ) then
274: while (l_reporting_date < l_sysdate) Loop
275: l_reporting_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date(
276: p_project_id
277: ,l_reporting_date
278: ,l_cycle_id
279: ,l_offset_days

Line 482: return_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date

478:
479: prev_return_date := return_date;
480:
481: IF X_Billing_Cycle_ID IS NOT NULL THEN
482: return_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date
483: (X_Project_ID => X_Project_ID,
484: X_Project_Start_Date => X_Project_Start_Date,
485: X_Billing_Cycle_ID => X_Billing_Cycle_ID,
486: X_Billing_Offset_Days => X_Billing_Offset_Days,

Line 680: From PA_Billing_Cycles

676: l_cycle_type varchar2(30);
677: l_value1 number;
678: cursor get_cycle_info is
679: Select Billing_Cycle_Type, Billing_Value1
680: From PA_Billing_Cycles
681: Where Billing_Cycle_ID = X_Billing_Cycle_ID;
682:
683: begin
684:

Line 1151: From PA_Billing_Cycles

1147: l_cycle_type varchar2(30);
1148: l_value1 number;
1149: cursor get_cycle_info is
1150: Select Billing_Cycle_Type, Billing_Value1
1151: From PA_Billing_Cycles
1152: Where Billing_Cycle_ID = l_progress_cycle_id;
1153:
1154: BEGIN
1155: ---5226910(5212999)

Line 1218: l_return_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date

1214: FETCH cur_pa_proj_prg_attr INTO l_progress_cycle_id;
1215: CLOSE cur_pa_proj_prg_attr;
1216:
1217: if (l_progress_cycle_id is not null) then
1218: l_return_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date
1219: (X_Project_ID => p_Project_ID,
1220: X_Project_Start_Date => l_last_progress_date,
1221: X_Billing_Cycle_ID => l_progress_cycle_id,
1222: X_Billing_Offset_Days => 0,

Line 1371: From PA_Billing_Cycles

1367: l_cycle_type varchar2(30);
1368: l_value1 number;
1369: cursor get_cycle_info is
1370: Select Billing_Cycle_Type, Billing_Value1
1371: From PA_Billing_Cycles
1372: Where Billing_Cycle_ID = l_progress_cycle_id;
1373:
1374: BEGIN
1375: OPEN cur_pa_proj;

Line 1462: l_return_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date

1458: END IF;
1459:
1460: WHILE NVL( l_return_date, SYSDATE ) <= SYSDATE
1461: LOOP
1462: l_return_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date
1463: (X_Project_ID => p_Project_ID,
1464: X_Project_Start_Date => l_last_progress_date,
1465: X_Billing_Cycle_ID => l_progress_cycle_id,
1466: X_Billing_Offset_Days => 0,