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_RETENTION_PKG dependencies on FND_GLOBAL

Line 152: l_program_id NUMBER:= fnd_global.conc_program_id;

148: p_funding_currency IN VARCHAR2,
149: p_funding_amount IN NUMBER) IS
150:
151: TmpFlag VARCHAR2(1):='N';
152: l_program_id NUMBER:= fnd_global.conc_program_id;
153: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
154: l_program_update_date DATE := sysdate;
155: l_last_update_date DATE := sysdate;
156: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 153: l_program_application_id NUMBER:= fnd_global.prog_appl_id;

149: p_funding_amount IN NUMBER) IS
150:
151: TmpFlag VARCHAR2(1):='N';
152: l_program_id NUMBER:= fnd_global.conc_program_id;
153: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
154: l_program_update_date DATE := sysdate;
155: l_last_update_date DATE := sysdate;
156: l_last_updated_by NUMBER:= fnd_global.user_id;
157: l_last_update_login NUMBER:= fnd_global.login_id;

Line 156: l_last_updated_by NUMBER:= fnd_global.user_id;

152: l_program_id NUMBER:= fnd_global.conc_program_id;
153: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
154: l_program_update_date DATE := sysdate;
155: l_last_update_date DATE := sysdate;
156: l_last_updated_by NUMBER:= fnd_global.user_id;
157: l_last_update_login NUMBER:= fnd_global.login_id;
158: l_project_retn_id NUMBER;
159:
160: ok_found EXCEPTION;

Line 157: l_last_update_login NUMBER:= fnd_global.login_id;

153: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
154: l_program_update_date DATE := sysdate;
155: l_last_update_date DATE := sysdate;
156: l_last_updated_by NUMBER:= fnd_global.user_id;
157: l_last_update_login NUMBER:= fnd_global.login_id;
158: l_project_retn_id NUMBER;
159:
160: ok_found EXCEPTION;
161: spr_found EXCEPTION;

Line 562: LastUpdatedBy NUMBER:= fnd_global.user_id;

558: PCCurRetainAmount NUMBER:=0;
559: FCCurRetainAmount NUMBER:=0;
560: BTCCurRetainAmount NUMBER:=0;
561:
562: LastUpdatedBy NUMBER:= fnd_global.user_id;
563: l_created_by NUMBER:= fnd_global.user_id;
564: l_program_id NUMBER:= fnd_global.conc_program_id;
565: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
566: l_program_update_date DATE := sysdate;

Line 563: l_created_by NUMBER:= fnd_global.user_id;

559: FCCurRetainAmount NUMBER:=0;
560: BTCCurRetainAmount NUMBER:=0;
561:
562: LastUpdatedBy NUMBER:= fnd_global.user_id;
563: l_created_by NUMBER:= fnd_global.user_id;
564: l_program_id NUMBER:= fnd_global.conc_program_id;
565: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
566: l_program_update_date DATE := sysdate;
567: l_last_update_date DATE := sysdate;

Line 564: l_program_id NUMBER:= fnd_global.conc_program_id;

560: BTCCurRetainAmount NUMBER:=0;
561:
562: LastUpdatedBy NUMBER:= fnd_global.user_id;
563: l_created_by NUMBER:= fnd_global.user_id;
564: l_program_id NUMBER:= fnd_global.conc_program_id;
565: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
566: l_program_update_date DATE := sysdate;
567: l_last_update_date DATE := sysdate;
568: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 565: l_program_application_id NUMBER:= fnd_global.prog_appl_id;

561:
562: LastUpdatedBy NUMBER:= fnd_global.user_id;
563: l_created_by NUMBER:= fnd_global.user_id;
564: l_program_id NUMBER:= fnd_global.conc_program_id;
565: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
566: l_program_update_date DATE := sysdate;
567: l_last_update_date DATE := sysdate;
568: l_last_updated_by NUMBER:= fnd_global.user_id;
569: l_last_update_login NUMBER:= fnd_global.login_id;

Line 568: l_last_updated_by NUMBER:= fnd_global.user_id;

564: l_program_id NUMBER:= fnd_global.conc_program_id;
565: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
566: l_program_update_date DATE := sysdate;
567: l_last_update_date DATE := sysdate;
568: l_last_updated_by NUMBER:= fnd_global.user_id;
569: l_last_update_login NUMBER:= fnd_global.login_id;
570:
571: ProjectCurrency VARCHAR2(15);
572: ProjFuncCurrency VARCHAR2(15);

Line 569: l_last_update_login NUMBER:= fnd_global.login_id;

565: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
566: l_program_update_date DATE := sysdate;
567: l_last_update_date DATE := sysdate;
568: l_last_updated_by NUMBER:= fnd_global.user_id;
569: l_last_update_login NUMBER:= fnd_global.login_id;
570:
571: ProjectCurrency VARCHAR2(15);
572: ProjFuncCurrency VARCHAR2(15);
573: FundingCurrency VARCHAR2(15);

Line 1641: TmpUserId NUMBER:= fnd_global.user_id;

1637: Tmp_Output_exempt_reason_code VARCHAR2(30);
1638: TmpSetOfBooks NUMBER;
1639: TmpBillToAddressID NUMBER;
1640: TmpShipToAddressID NUMBER;
1641: TmpUserId NUMBER:= fnd_global.user_id;
1642: TmpBillToCustomerId NUMBER;
1643: TmpShipToCustomerId NUMBER;/*Added for customer account relation*/
1644: TmpSiteUSeId1 NUMBER;
1645: TmpSiteUSeId2 NUMBER;/*Added for bug 2938422*/

Line 2779: LastUpdatedBy NUMBER:= fnd_global.user_id;

2775: PROCEDURE Proj_Invoice_Credit_Memo(p_request_id IN NUMBER,
2776: p_project_id IN NUMBER,
2777: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
2778: LastLineNum NUMBER:=0;
2779: LastUpdatedBy NUMBER:= fnd_global.user_id;
2780: l_created_by NUMBER:= fnd_global.user_id;
2781: l_program_id NUMBER:= fnd_global.conc_program_id;
2782: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2783: l_program_update_date DATE := sysdate;

Line 2780: l_created_by NUMBER:= fnd_global.user_id;

2776: p_project_id IN NUMBER,
2777: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
2778: LastLineNum NUMBER:=0;
2779: LastUpdatedBy NUMBER:= fnd_global.user_id;
2780: l_created_by NUMBER:= fnd_global.user_id;
2781: l_program_id NUMBER:= fnd_global.conc_program_id;
2782: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2783: l_program_update_date DATE := sysdate;
2784: l_last_update_date DATE := sysdate;

Line 2781: l_program_id NUMBER:= fnd_global.conc_program_id;

2777: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
2778: LastLineNum NUMBER:=0;
2779: LastUpdatedBy NUMBER:= fnd_global.user_id;
2780: l_created_by NUMBER:= fnd_global.user_id;
2781: l_program_id NUMBER:= fnd_global.conc_program_id;
2782: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2783: l_program_update_date DATE := sysdate;
2784: l_last_update_date DATE := sysdate;
2785: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 2782: l_program_application_id NUMBER:= fnd_global.prog_appl_id;

2778: LastLineNum NUMBER:=0;
2779: LastUpdatedBy NUMBER:= fnd_global.user_id;
2780: l_created_by NUMBER:= fnd_global.user_id;
2781: l_program_id NUMBER:= fnd_global.conc_program_id;
2782: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2783: l_program_update_date DATE := sysdate;
2784: l_last_update_date DATE := sysdate;
2785: l_last_updated_by NUMBER:= fnd_global.user_id;
2786: l_last_update_login NUMBER:= fnd_global.login_id;

Line 2785: l_last_updated_by NUMBER:= fnd_global.user_id;

2781: l_program_id NUMBER:= fnd_global.conc_program_id;
2782: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2783: l_program_update_date DATE := sysdate;
2784: l_last_update_date DATE := sysdate;
2785: l_last_updated_by NUMBER:= fnd_global.user_id;
2786: l_last_update_login NUMBER:= fnd_global.login_id;
2787:
2788: ProjectCurrency VARCHAR2(15);
2789: l_credit_invoice_num NUMBER:=0;

Line 2786: l_last_update_login NUMBER:= fnd_global.login_id;

2782: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2783: l_program_update_date DATE := sysdate;
2784: l_last_update_date DATE := sysdate;
2785: l_last_updated_by NUMBER:= fnd_global.user_id;
2786: l_last_update_login NUMBER:= fnd_global.login_id;
2787:
2788: ProjectCurrency VARCHAR2(15);
2789: l_credit_invoice_num NUMBER:=0;
2790: l_org_invoice_num NUMBER:=0;

Line 3122: LastUpdatedBy NUMBER:= fnd_global.user_id;

3118: p_project_id IN NUMBER,
3119: p_draft_invoice_num IN NUMBER,
3120: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
3121: TmpInvoiceNum NUMBER:=0;
3122: LastUpdatedBy NUMBER:= fnd_global.user_id;
3123: l_created_by NUMBER:= fnd_global.user_id;
3124: l_program_id NUMBER:= fnd_global.conc_program_id;
3125: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3126: l_program_update_date DATE := sysdate;

Line 3123: l_created_by NUMBER:= fnd_global.user_id;

3119: p_draft_invoice_num IN NUMBER,
3120: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
3121: TmpInvoiceNum NUMBER:=0;
3122: LastUpdatedBy NUMBER:= fnd_global.user_id;
3123: l_created_by NUMBER:= fnd_global.user_id;
3124: l_program_id NUMBER:= fnd_global.conc_program_id;
3125: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3126: l_program_update_date DATE := sysdate;
3127: l_last_update_date DATE := sysdate;

Line 3124: l_program_id NUMBER:= fnd_global.conc_program_id;

3120: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
3121: TmpInvoiceNum NUMBER:=0;
3122: LastUpdatedBy NUMBER:= fnd_global.user_id;
3123: l_created_by NUMBER:= fnd_global.user_id;
3124: l_program_id NUMBER:= fnd_global.conc_program_id;
3125: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3126: l_program_update_date DATE := sysdate;
3127: l_last_update_date DATE := sysdate;
3128: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 3125: l_program_application_id NUMBER:= fnd_global.prog_appl_id;

3121: TmpInvoiceNum NUMBER:=0;
3122: LastUpdatedBy NUMBER:= fnd_global.user_id;
3123: l_created_by NUMBER:= fnd_global.user_id;
3124: l_program_id NUMBER:= fnd_global.conc_program_id;
3125: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3126: l_program_update_date DATE := sysdate;
3127: l_last_update_date DATE := sysdate;
3128: l_last_updated_by NUMBER:= fnd_global.user_id;
3129: l_last_update_login NUMBER:= fnd_global.login_id;

Line 3128: l_last_updated_by NUMBER:= fnd_global.user_id;

3124: l_program_id NUMBER:= fnd_global.conc_program_id;
3125: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3126: l_program_update_date DATE := sysdate;
3127: l_last_update_date DATE := sysdate;
3128: l_last_updated_by NUMBER:= fnd_global.user_id;
3129: l_last_update_login NUMBER:= fnd_global.login_id;
3130: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate,'YYYY/MM/DD');
3131: TmpBillThruDate DATE:= TO_DATE(pa_billing.globvars.BillThruDate,'YYYY/MM/DD');
3132: TmpPADate DATE:= TO_DATE(pa_billing.globvars.PADate,'YYYY/MM/DD');

Line 3129: l_last_update_login NUMBER:= fnd_global.login_id;

3125: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3126: l_program_update_date DATE := sysdate;
3127: l_last_update_date DATE := sysdate;
3128: l_last_updated_by NUMBER:= fnd_global.user_id;
3129: l_last_update_login NUMBER:= fnd_global.login_id;
3130: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate,'YYYY/MM/DD');
3131: TmpBillThruDate DATE:= TO_DATE(pa_billing.globvars.BillThruDate,'YYYY/MM/DD');
3132: TmpPADate DATE:= TO_DATE(pa_billing.globvars.PADate,'YYYY/MM/DD');
3133: TmpGLDate DATE:= TO_DATE(pa_billing.globvars.GLDate,'YYYY/MM/DD');