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 484: return_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date

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

Line 682: From PA_Billing_Cycles

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

Line 1157: From PA_Billing_Cycles

1153: l_cycle_type varchar2(30);
1154: l_value1 number;
1155: cursor get_cycle_info is
1156: Select Billing_Cycle_Type, Billing_Value1
1157: From PA_Billing_Cycles
1158: Where Billing_Cycle_ID = l_progress_cycle_id;
1159:
1160: BEGIN
1161: ---5226910(5212999)

Line 1224: l_return_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date

1220: FETCH cur_pa_proj_prg_attr INTO l_progress_cycle_id;
1221: CLOSE cur_pa_proj_prg_attr;
1222:
1223: if (l_progress_cycle_id is not null) then
1224: l_return_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date
1225: (X_Project_ID => p_Project_ID,
1226: X_Project_Start_Date => l_last_progress_date,
1227: X_Billing_Cycle_ID => l_progress_cycle_id,
1228: X_Billing_Offset_Days => 0,

Line 1380: From PA_Billing_Cycles

1376: l_cycle_type varchar2(30);
1377: l_value1 number;
1378: cursor get_cycle_info is
1379: Select Billing_Cycle_Type, Billing_Value1
1380: From PA_Billing_Cycles
1381: Where Billing_Cycle_ID = l_progress_cycle_id;
1382:
1383: BEGIN
1384: OPEN cur_pa_proj;

Line 1471: l_return_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date

1467: END IF;
1468:
1469: WHILE NVL( l_return_date, SYSDATE ) <= SYSDATE
1470: LOOP
1471: l_return_date := PA_Billing_Cycles_Pkg.Get_Next_Billing_Date
1472: (X_Project_ID => p_Project_ID,
1473: X_Project_Start_Date => l_last_progress_date,
1474: X_Billing_Cycle_ID => l_progress_cycle_id,
1475: X_Billing_Offset_Days => 0,