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_RETN_BILLING_PKG dependencies on PA_BILLING

Line 134: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate , 'YYYY/MM/DD');

130: X_Output_exempt_reason_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
131: ) IS
132:
133: TmpCustBillSplit NUMBER;
134: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate , 'YYYY/MM/DD');
135: TmpBillThruDate DATE:= TO_DATE(pa_billing.globvars.BillThruDate, 'YYYY/MM/DD');
136: TmpPADate DATE:= TO_DATE(pa_billing.globvars.PADate, 'YYYY/MM/DD');
137: TmpGLDate DATE:= TO_DATE(pa_billing.globvars.GLDate, 'YYYY/MM/DD');
138: TmpDraftInvoiceNUm NUMBER:=0;

Line 135: TmpBillThruDate DATE:= TO_DATE(pa_billing.globvars.BillThruDate, 'YYYY/MM/DD');

131: ) IS
132:
133: TmpCustBillSplit NUMBER;
134: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate , 'YYYY/MM/DD');
135: TmpBillThruDate DATE:= TO_DATE(pa_billing.globvars.BillThruDate, 'YYYY/MM/DD');
136: TmpPADate DATE:= TO_DATE(pa_billing.globvars.PADate, 'YYYY/MM/DD');
137: TmpGLDate DATE:= TO_DATE(pa_billing.globvars.GLDate, 'YYYY/MM/DD');
138: TmpDraftInvoiceNUm NUMBER:=0;
139: TmpInvoiceSetId NUMBER;

Line 136: TmpPADate DATE:= TO_DATE(pa_billing.globvars.PADate, 'YYYY/MM/DD');

132:
133: TmpCustBillSplit NUMBER;
134: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate , 'YYYY/MM/DD');
135: TmpBillThruDate DATE:= TO_DATE(pa_billing.globvars.BillThruDate, 'YYYY/MM/DD');
136: TmpPADate DATE:= TO_DATE(pa_billing.globvars.PADate, 'YYYY/MM/DD');
137: TmpGLDate DATE:= TO_DATE(pa_billing.globvars.GLDate, 'YYYY/MM/DD');
138: TmpDraftInvoiceNUm NUMBER:=0;
139: TmpInvoiceSetId NUMBER;
140: TmpInvoiceComment VARCHAR2(240);

Line 137: TmpGLDate DATE:= TO_DATE(pa_billing.globvars.GLDate, 'YYYY/MM/DD');

133: TmpCustBillSplit NUMBER;
134: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate , 'YYYY/MM/DD');
135: TmpBillThruDate DATE:= TO_DATE(pa_billing.globvars.BillThruDate, 'YYYY/MM/DD');
136: TmpPADate DATE:= TO_DATE(pa_billing.globvars.PADate, 'YYYY/MM/DD');
137: TmpGLDate DATE:= TO_DATE(pa_billing.globvars.GLDate, 'YYYY/MM/DD');
138: TmpDraftInvoiceNUm NUMBER:=0;
139: TmpInvoiceSetId NUMBER;
140: TmpInvoiceComment VARCHAR2(240);
141: TmpInvCurrency VARCHAR2(15);

Line 418: IF pa_billing.Globvars.InvoiceSetId IS NULL THEN

414: TmpInvCurrency);
415:
416: pa_retn_billing_pkg.G_Inv_By_Bill_Trans_Currency := TmpInvByBtc;
417:
418: IF pa_billing.Globvars.InvoiceSetId IS NULL THEN
419:
420: -- Generate a set id, happens only user run the retention invoice generation
421:
422: SELECT PA_DRAFT_INVOICES_S.NEXTVAL

Line 427: TmpInvoiceSetId := pa_billing.Globvars.InvoiceSetId;

423: INTO TmpInvoiceSetId
424: FROM DUAL;
425:
426: ELSE
427: TmpInvoiceSetId := pa_billing.Globvars.InvoiceSetId;
428: END IF;
429:
430: IF g1_debug_mode = 'Y' THEN
431: pa_retention_util.write_log('Build_Retn_Invoice_Header: ' || 'TmpInvoiceSetId : ' || TmpInvoiceSetId);

Line 508: pa_retention_util.write_log('Build_Retn_Invoice_Header: ' || 'Bill Thru Date : ' || pa_billing.GetBillThruDate);

504: END IF;
505: END IF;
506: IF g1_debug_mode = 'Y' THEN
507: pa_retention_util.write_log('Build_Retn_Invoice_Header: ' || 'Invoice Currency : ' || TmpInvCurrency);
508: pa_retention_util.write_log('Build_Retn_Invoice_Header: ' || 'Bill Thru Date : ' || pa_billing.GetBillThruDate);
509: END IF;
510:
511: IF TmpCreditHold ='Y' OR NVL(TmpRetnBillInvFmtID,0) = 0 THEN
512:

Line 578: pa_billing.GetPaDate,

574: p_agreement_id, SYSDATE,
575: TmpUserId, SYSDATE,
576: TmpUserId, 'P',
577: DECODE(TmpCreditHold,'Y','Y','N',DECODE(TmpRetnBillInvFmtId,0,'Y','N')),
578: pa_billing.GetPaDate,
579: p_request_id,
580: TmpProgApplId,
581: TmpProgId, SYSDATE,
582: TO_DATE(pa_billing.GetBillThruDate, 'YYYY/MM/DD'),

Line 582: TO_DATE(pa_billing.GetBillThruDate, 'YYYY/MM/DD'),

578: pa_billing.GetPaDate,
579: p_request_id,
580: TmpProgApplId,
581: TmpProgId, SYSDATE,
582: TO_DATE(pa_billing.GetBillThruDate, 'YYYY/MM/DD'),
583: /*DECODE(TmpCreditHold,'Y','Y','N',DECODE(TmpRetnBillInvFmtId,0,
584: TmpWarningMsg,Null)),*/
585: DECODE(TmpCreditHold,'Y',TmpWarningMsg,'N',DECODE(TmpRetnBillInvFmtId,0, TmpWarningMsg,Null)),
586: null, NULL,

Line 599: pa_billing.GetGlDate,

595: TmpLanguage,
596: NVL(TmpInvProcCurrency,TmpFundingCurrency),
597: TRUNC(TmpInvoiceDate),
598: --TRUNC(TO_DATE(TmpInvoiceDate, 'YYYY/MM/DD')),
599: pa_billing.GetGlDate,
600: pa_billing.getpaperiodname,
601: pa_billing.getglperiodname,
602: 'Y',
603: TmpCustomerid,

Line 600: pa_billing.getpaperiodname,

596: NVL(TmpInvProcCurrency,TmpFundingCurrency),
597: TRUNC(TmpInvoiceDate),
598: --TRUNC(TO_DATE(TmpInvoiceDate, 'YYYY/MM/DD')),
599: pa_billing.GetGlDate,
600: pa_billing.getpaperiodname,
601: pa_billing.getglperiodname,
602: 'Y',
603: TmpCustomerid,
604: TmpBilltocustomerid,

Line 601: pa_billing.getglperiodname,

597: TRUNC(TmpInvoiceDate),
598: --TRUNC(TO_DATE(TmpInvoiceDate, 'YYYY/MM/DD')),
599: pa_billing.GetGlDate,
600: pa_billing.getpaperiodname,
601: pa_billing.getglperiodname,
602: 'Y',
603: TmpCustomerid,
604: TmpBilltocustomerid,
605: TmpShiptocustomerid,

Line 1265: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate, 'YYYY/MM/DD');

1261: TmpProjectId NUMBER;
1262:
1263: /* R12 : ATG changes : removed to_date function */
1264:
1265: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate, 'YYYY/MM/DD');
1266:
1267: /* Bug 3258465 Added this temporary variable to fetch the Bill through date*/
1268: TmpBillThruDate DATE := TO_DATE(pa_billing.globvars.BillThruDate,'YYYY/MM/DD');
1269:

Line 1268: TmpBillThruDate DATE := TO_DATE(pa_billing.globvars.BillThruDate,'YYYY/MM/DD');

1264:
1265: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate, 'YYYY/MM/DD');
1266:
1267: /* Bug 3258465 Added this temporary variable to fetch the Bill through date*/
1268: TmpBillThruDate DATE := TO_DATE(pa_billing.globvars.BillThruDate,'YYYY/MM/DD');
1269:
1270: CurRetained NUMBER:=0;
1271: CurBillAmount NUMBER:=0;
1272: TmpBillAmount NUMBER:=0;

Line 1342: pa_billing_cycles cy,

1338: cy.billing_cycle_name billing_cycle_name,
1339: lk.meaning billingMethodDesc,
1340: retn1.task_id task_id
1341: FROM pa_proj_retn_bill_rules retn1,
1342: pa_billing_cycles cy,
1343: pa_lookups lk
1344: WHERE retn1.project_id = TmpProjectId
1345: AND retn1.customer_id= TmpCustomerId
1346: AND lk.lookup_code = retn1.billing_method_code

Line 1683: TO_DATE(pa_billing.globvars.billthrudate,'YYYY/MM/DD'),

1679: IF pa_retention_util.IsBillingCycleQualified(
1680: p_project_id => TmpProjectId,
1681: p_task_id => TmpTaskId,
1682: P_bill_thru_date =>
1683: TO_DATE(pa_billing.globvars.billthrudate,'YYYY/MM/DD'),
1684: p_billing_cycle_id =>
1685: RetnRuleRec.billing_cycle_id) ='Y'
1686: THEN
1687: