eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BILLING_CORE dependencies on PA_SUMMARY_PROJECT_FUNDINGS

Line 57: pa_summary_project_fundings f

53: from sys.dual
54: where not exists
55: (select 1
56: from pa_agreements_all a,
57: pa_summary_project_fundings f
58: where f.project_id = x_project_id
59: and nvl(f.task_id, 0) = x_task_id
60: and ( ( nvl(f.total_baselined_amount, 0)
61: + f.total_unbaselined_amount

Line 75: pa_summary_project_fundings f

71: from sys.dual
72: where not exists
73: (select 1
74: from pa_agreements_all a,
75: pa_summary_project_fundings f
76: where f.project_id = x_project_id
77: and nvl(f.task_id, 0) = x_task_id
78: and ( ( nvl(f.projfunc_baselined_amount, 0)
79: + f.projfunc_unbaselined_amount

Line 88: pa_summary_project_fundings f

84: and a.revenue_limit_flag = 'Y')
85: and not exists
86: (select 1
87: from pa_agreements_all a,
88: pa_summary_project_fundings f
89: where f.project_id = x_project_id
90: and nvl(f.task_id, 0) = x_task_id
91: and ( ( nvl(f.invproc_baselined_amount, 0)
92: + f.invproc_unbaselined_amount

Line 163: select 1 from pa_summary_project_fundings PSPF,

159: where PPC.project_id= x_project_id
160: and PPC.customer_bill_split > 0 /* Added for Bug2453912 */
161: and not exists
162: (
163: select 1 from pa_summary_project_fundings PSPF,
164: pa_agreements_all PAA
165: where PPC.customer_id = PAA.customer_id
166: and PAA.agreement_id = PSPF.agreement_id
167: and PPC.project_id= PSPF.project_id

Line 631: update pa_summary_project_fundings

627: -- update summary funding
628: x_err_stage := 'update summary funding <' || to_char(x_project_id)
629: || '>';
630:
631: update pa_summary_project_fundings
632: set total_baselined_amount = total_unbaselined_amount +
633: nvl(total_baselined_amount, 0),
634: total_unbaselined_amount = 0,
635: /* MCB2 code begins */

Line 685: UPDATE pa_summary_project_fundings

681: last_updated_by = x_created_by,
682: last_update_login = x_last_update_login
683: WHERE project_funding_id = reval_rec.project_funding_id;
684:
685: UPDATE pa_summary_project_fundings
686: SET projfunc_baselined_amount = projfunc_baselined_amount +
687: NVL(reval_rec.projfunc_allocated_amount, 0),
688: projfunc_unbaselined_amount = projfunc_unbaselined_amount -
689: NVL(reval_rec.projfunc_allocated_amount,0),

Line 760: UPDATE pa_summary_project_fundings

756: WHERE project_funding_id = Agreement_rec.project_funding_id;
757:
758: -- Update the Project summary fundings of PFC, Invoice and revenue
759: -- baselined and unbaselined amounts
760: UPDATE pa_summary_project_fundings
761: SET projfunc_baselined_amount = projfunc_baselined_amount +
762: NVL(Agreement_rec.projfunc_allocated_amount, 0),
763: projfunc_unbaselined_amount = projfunc_unbaselined_amount -
764: NVL(Agreement_rec.projfunc_allocated_amount,0),

Line 839: from pa_summary_project_fundings

835: is
836:
837: cursor proj is
838: select 1
839: from pa_summary_project_fundings
840: where project_id = x_project_id
841: and task_id is null
842: and nvl(total_baselined_amount, 0) + total_unbaselined_amount > 0;
843:

Line 846: from pa_summary_project_fundings

842: and nvl(total_baselined_amount, 0) + total_unbaselined_amount > 0;
843:
844: cursor task is
845: select 1
846: from pa_summary_project_fundings
847: where project_id = x_project_id
848: and task_id is not null
849: and nvl(total_baselined_amount, 0) + total_unbaselined_amount > 0;
850:

Line 866: select 1 from pa_summary_project_fundings

862: having sum(allocated_amount) = 0;
863:
864: -- Added cursors project_negation and task_negation for bug 1286536
865: cursor project_negation is
866: select 1 from pa_summary_project_fundings
867: where project_id = x_project_id
868: and task_id is null
869: and total_unbaselined_amount = nvl(total_baselined_amount,0)*(-1)
870: and total_unbaselined_amount <> 0;

Line 873: select 1 from pa_summary_project_fundings

869: and total_unbaselined_amount = nvl(total_baselined_amount,0)*(-1)
870: and total_unbaselined_amount <> 0;
871:
872: cursor task_negation is
873: select 1 from pa_summary_project_fundings
874: where project_id = x_project_id
875: and task_id is not null
876: and total_unbaselined_amount = nvl(total_baselined_amount,0)*(-1)
877: and total_unbaselined_amount <> 0;

Line 1042: from pa_summary_project_fundings

1038: /* Check if any funding exists at all */
1039:
1040: begin
1041: select 'Y' into l_fund_exists
1042: from pa_summary_project_fundings
1043: where project_id = x_orig_project_id
1044: and nvl(total_baselined_amount, 0) + total_unbaselined_amount > 0;
1045:
1046: exception

Line 1196: (SELECT F.agreement_id from pa_summary_project_fundings F

1192: and c2.customer_bill_split = 100
1193: and c2.customer_id = a.customer_id);
1194: */
1195: AND A.agreement_id IN
1196: (SELECT F.agreement_id from pa_summary_project_fundings F
1197: WHERE F.project_id = x_orig_project_id)
1198: AND exists
1199: (select null
1200: from pa_project_customers c2

Line 1703: x_err_stage := 'Insert or update pa_summary_project_fundings';

1699: /*end if; Commented for bug 5140179*/
1700:
1701: if x_err_code = 0 then
1702:
1703: x_err_stage := 'Insert or update pa_summary_project_fundings';
1704:
1705: INSERT INTO pa_summary_project_fundings(
1706: agreement_id,
1707: project_id,

Line 1705: INSERT INTO pa_summary_project_fundings(

1701: if x_err_code = 0 then
1702:
1703: x_err_stage := 'Insert or update pa_summary_project_fundings';
1704:
1705: INSERT INTO pa_summary_project_fundings(
1706: agreement_id,
1707: project_id,
1708: task_id,
1709: total_baselined_amount,

Line 1794: from pa_summary_project_fundings spf

1790: BEGIN
1791: select 'Y' into l_fund_exists
1792: from dual
1793: where exists(select null
1794: from pa_summary_project_fundings spf
1795: where spf.project_id = x_project_id);
1796:
1797: EXCEPTION
1798: WHEN no_data_found THEN

Line 1850: From PA_summary_Project_Fundings

1846:
1847: begin
1848: Select 'N'
1849: Into l_Exist_Flag
1850: From PA_summary_Project_Fundings
1851: Where Project_ID = P_Project_ID
1852: HAVING ( sum(nvl(Total_Baselined_Amount,0)) > 0 OR sum(nvl(Total_Unbaselined_Amount,0)) > 0 );
1853:
1854: Return l_Exist_Flag;

Line 1917: From PA_Summary_Project_Fundings

1913: -- Case 1 : If it has any project level funding (baselined or unbaselined)
1914: begin
1915: Select 'N'
1916: Into l_Exist_Flag
1917: From PA_Summary_Project_Fundings
1918: Where Project_ID = P_Project_ID
1919: and Task_ID IS NULL
1920: HAVING ( sum(Total_Baselined_Amount) > 0 OR sum(Total_Unbaselined_Amount) > 0 );
1921:

Line 1936: From PA_Summary_Project_Fundings

1932:
1933: l_Check_Next_Condition := 'N'; --Added for bug3703094
1934: Select 'N'
1935: Into l_Exist_Flag
1936: From PA_Summary_Project_Fundings
1937: Where Project_ID = P_Project_ID
1938: and Task_ID IS NOT NULL
1939: HAVING sum(Total_Billed_Amount) > 0;
1940:

Line 1969: From PA_Summary_Project_Fundings

1965:
1966: begin
1967: Select 'N'
1968: Into l_Exist_Flag
1969: From PA_Summary_Project_Fundings
1970: Where Project_ID = P_Project_ID
1971: HAVING ( sum(Total_Billed_Amount) > 0 OR
1972: sum(Total_Accrued_Amount) > 0 ); --Added for Bug3729634
1973: Exception When Others then

Line 2012: From PA_Summary_Project_Fundings

2008:
2009: begin
2010: Select 'N'
2011: Into l_Exist_Flag
2012: From PA_Summary_Project_Fundings
2013: Where Project_ID = P_Project_ID
2014: AND Task_ID = P_Task_ID
2015: HAVING (sum(Total_Baselined_Amount) <> 0
2016: OR sum(Total_UnBaselined_Amount) <> 0

Line 2089: From PA_Summary_Project_Fundings

2085: BEGIN
2086: begin
2087: Select 'N'
2088: Into l_Exist_Flag
2089: From PA_Summary_Project_Fundings
2090: Where Project_ID = P_Project_ID
2091: AND Task_ID = P_Task_ID
2092: HAVING sum(Total_Billed_Amount) > 0;
2093: Exception When Others then