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 170: l_program_id NUMBER:= fnd_global.conc_program_id;

166: p_funding_currency IN VARCHAR2,
167: p_funding_amount IN NUMBER) IS
168:
169: TmpFlag VARCHAR2(1):='N';
170: l_program_id NUMBER:= fnd_global.conc_program_id;
171: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
172: l_program_update_date DATE := sysdate;
173: l_last_update_date DATE := sysdate;
174: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 171: l_program_application_id NUMBER:= fnd_global.prog_appl_id;

167: p_funding_amount IN NUMBER) IS
168:
169: TmpFlag VARCHAR2(1):='N';
170: l_program_id NUMBER:= fnd_global.conc_program_id;
171: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
172: l_program_update_date DATE := sysdate;
173: l_last_update_date DATE := sysdate;
174: l_last_updated_by NUMBER:= fnd_global.user_id;
175: l_last_update_login NUMBER:= fnd_global.login_id;

Line 174: l_last_updated_by NUMBER:= fnd_global.user_id;

170: l_program_id NUMBER:= fnd_global.conc_program_id;
171: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
172: l_program_update_date DATE := sysdate;
173: l_last_update_date DATE := sysdate;
174: l_last_updated_by NUMBER:= fnd_global.user_id;
175: l_last_update_login NUMBER:= fnd_global.login_id;
176: l_project_retn_id NUMBER;
177:
178: ok_found EXCEPTION;

Line 175: l_last_update_login NUMBER:= fnd_global.login_id;

171: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
172: l_program_update_date DATE := sysdate;
173: l_last_update_date DATE := sysdate;
174: l_last_updated_by NUMBER:= fnd_global.user_id;
175: l_last_update_login NUMBER:= fnd_global.login_id;
176: l_project_retn_id NUMBER;
177:
178: ok_found EXCEPTION;
179: spr_found EXCEPTION;

Line 580: LastUpdatedBy NUMBER:= fnd_global.user_id;

576: PCCurRetainAmount NUMBER:=0;
577: FCCurRetainAmount NUMBER:=0;
578: BTCCurRetainAmount NUMBER:=0;
579:
580: LastUpdatedBy NUMBER:= fnd_global.user_id;
581: l_created_by NUMBER:= fnd_global.user_id;
582: l_program_id NUMBER:= fnd_global.conc_program_id;
583: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
584: l_program_update_date DATE := sysdate;

Line 581: l_created_by NUMBER:= fnd_global.user_id;

577: FCCurRetainAmount NUMBER:=0;
578: BTCCurRetainAmount NUMBER:=0;
579:
580: LastUpdatedBy NUMBER:= fnd_global.user_id;
581: l_created_by NUMBER:= fnd_global.user_id;
582: l_program_id NUMBER:= fnd_global.conc_program_id;
583: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
584: l_program_update_date DATE := sysdate;
585: l_last_update_date DATE := sysdate;

Line 582: l_program_id NUMBER:= fnd_global.conc_program_id;

578: BTCCurRetainAmount NUMBER:=0;
579:
580: LastUpdatedBy NUMBER:= fnd_global.user_id;
581: l_created_by NUMBER:= fnd_global.user_id;
582: l_program_id NUMBER:= fnd_global.conc_program_id;
583: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
584: l_program_update_date DATE := sysdate;
585: l_last_update_date DATE := sysdate;
586: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 583: l_program_application_id NUMBER:= fnd_global.prog_appl_id;

579:
580: LastUpdatedBy NUMBER:= fnd_global.user_id;
581: l_created_by NUMBER:= fnd_global.user_id;
582: l_program_id NUMBER:= fnd_global.conc_program_id;
583: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
584: l_program_update_date DATE := sysdate;
585: l_last_update_date DATE := sysdate;
586: l_last_updated_by NUMBER:= fnd_global.user_id;
587: l_last_update_login NUMBER:= fnd_global.login_id;

Line 586: l_last_updated_by NUMBER:= fnd_global.user_id;

582: l_program_id NUMBER:= fnd_global.conc_program_id;
583: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
584: l_program_update_date DATE := sysdate;
585: l_last_update_date DATE := sysdate;
586: l_last_updated_by NUMBER:= fnd_global.user_id;
587: l_last_update_login NUMBER:= fnd_global.login_id;
588:
589: ProjectCurrency VARCHAR2(15);
590: ProjFuncCurrency VARCHAR2(15);

Line 587: l_last_update_login NUMBER:= fnd_global.login_id;

583: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
584: l_program_update_date DATE := sysdate;
585: l_last_update_date DATE := sysdate;
586: l_last_updated_by NUMBER:= fnd_global.user_id;
587: l_last_update_login NUMBER:= fnd_global.login_id;
588:
589: ProjectCurrency VARCHAR2(15);
590: ProjFuncCurrency VARCHAR2(15);
591: FundingCurrency VARCHAR2(15);

Line 1659: TmpUserId NUMBER:= fnd_global.user_id;

1655: Tmp_Output_exempt_reason_code VARCHAR2(30);
1656: TmpSetOfBooks NUMBER;
1657: TmpBillToAddressID NUMBER;
1658: TmpShipToAddressID NUMBER;
1659: TmpUserId NUMBER:= fnd_global.user_id;
1660: TmpBillToCustomerId NUMBER;
1661: TmpShipToCustomerId NUMBER;/*Added for customer account relation*/
1662: TmpSiteUSeId1 NUMBER;
1663: TmpSiteUSeId2 NUMBER;/*Added for bug 2938422*/

Line 2816: LastUpdatedBy NUMBER:= fnd_global.user_id;

2812: PROCEDURE Proj_Invoice_Credit_Memo(p_request_id IN NUMBER,
2813: p_project_id IN NUMBER,
2814: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
2815: LastLineNum NUMBER:=0;
2816: LastUpdatedBy NUMBER:= fnd_global.user_id;
2817: l_created_by NUMBER:= fnd_global.user_id;
2818: l_program_id NUMBER:= fnd_global.conc_program_id;
2819: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2820: l_program_update_date DATE := sysdate;

Line 2817: l_created_by NUMBER:= fnd_global.user_id;

2813: p_project_id IN NUMBER,
2814: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
2815: LastLineNum NUMBER:=0;
2816: LastUpdatedBy NUMBER:= fnd_global.user_id;
2817: l_created_by NUMBER:= fnd_global.user_id;
2818: l_program_id NUMBER:= fnd_global.conc_program_id;
2819: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2820: l_program_update_date DATE := sysdate;
2821: l_last_update_date DATE := sysdate;

Line 2818: l_program_id NUMBER:= fnd_global.conc_program_id;

2814: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
2815: LastLineNum NUMBER:=0;
2816: LastUpdatedBy NUMBER:= fnd_global.user_id;
2817: l_created_by NUMBER:= fnd_global.user_id;
2818: l_program_id NUMBER:= fnd_global.conc_program_id;
2819: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2820: l_program_update_date DATE := sysdate;
2821: l_last_update_date DATE := sysdate;
2822: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 2819: l_program_application_id NUMBER:= fnd_global.prog_appl_id;

2815: LastLineNum NUMBER:=0;
2816: LastUpdatedBy NUMBER:= fnd_global.user_id;
2817: l_created_by NUMBER:= fnd_global.user_id;
2818: l_program_id NUMBER:= fnd_global.conc_program_id;
2819: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2820: l_program_update_date DATE := sysdate;
2821: l_last_update_date DATE := sysdate;
2822: l_last_updated_by NUMBER:= fnd_global.user_id;
2823: l_last_update_login NUMBER:= fnd_global.login_id;

Line 2822: l_last_updated_by NUMBER:= fnd_global.user_id;

2818: l_program_id NUMBER:= fnd_global.conc_program_id;
2819: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2820: l_program_update_date DATE := sysdate;
2821: l_last_update_date DATE := sysdate;
2822: l_last_updated_by NUMBER:= fnd_global.user_id;
2823: l_last_update_login NUMBER:= fnd_global.login_id;
2824:
2825: ProjectCurrency VARCHAR2(15);
2826: l_credit_invoice_num NUMBER:=0;

Line 2823: l_last_update_login NUMBER:= fnd_global.login_id;

2819: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
2820: l_program_update_date DATE := sysdate;
2821: l_last_update_date DATE := sysdate;
2822: l_last_updated_by NUMBER:= fnd_global.user_id;
2823: l_last_update_login NUMBER:= fnd_global.login_id;
2824:
2825: ProjectCurrency VARCHAR2(15);
2826: l_credit_invoice_num NUMBER:=0;
2827: l_org_invoice_num NUMBER:=0;

Line 3159: LastUpdatedBy NUMBER:= fnd_global.user_id;

3155: p_project_id IN NUMBER,
3156: p_draft_invoice_num IN NUMBER,
3157: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
3158: TmpInvoiceNum NUMBER:=0;
3159: LastUpdatedBy NUMBER:= fnd_global.user_id;
3160: l_created_by NUMBER:= fnd_global.user_id;
3161: l_program_id NUMBER:= fnd_global.conc_program_id;
3162: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3163: l_program_update_date DATE := sysdate;

Line 3160: l_created_by NUMBER:= fnd_global.user_id;

3156: p_draft_invoice_num IN NUMBER,
3157: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
3158: TmpInvoiceNum NUMBER:=0;
3159: LastUpdatedBy NUMBER:= fnd_global.user_id;
3160: l_created_by NUMBER:= fnd_global.user_id;
3161: l_program_id NUMBER:= fnd_global.conc_program_id;
3162: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3163: l_program_update_date DATE := sysdate;
3164: l_last_update_date DATE := sysdate;

Line 3161: l_program_id NUMBER:= fnd_global.conc_program_id;

3157: x_return_status OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
3158: TmpInvoiceNum NUMBER:=0;
3159: LastUpdatedBy NUMBER:= fnd_global.user_id;
3160: l_created_by NUMBER:= fnd_global.user_id;
3161: l_program_id NUMBER:= fnd_global.conc_program_id;
3162: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3163: l_program_update_date DATE := sysdate;
3164: l_last_update_date DATE := sysdate;
3165: l_last_updated_by NUMBER:= fnd_global.user_id;

Line 3162: l_program_application_id NUMBER:= fnd_global.prog_appl_id;

3158: TmpInvoiceNum NUMBER:=0;
3159: LastUpdatedBy NUMBER:= fnd_global.user_id;
3160: l_created_by NUMBER:= fnd_global.user_id;
3161: l_program_id NUMBER:= fnd_global.conc_program_id;
3162: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3163: l_program_update_date DATE := sysdate;
3164: l_last_update_date DATE := sysdate;
3165: l_last_updated_by NUMBER:= fnd_global.user_id;
3166: l_last_update_login NUMBER:= fnd_global.login_id;

Line 3165: l_last_updated_by NUMBER:= fnd_global.user_id;

3161: l_program_id NUMBER:= fnd_global.conc_program_id;
3162: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3163: l_program_update_date DATE := sysdate;
3164: l_last_update_date DATE := sysdate;
3165: l_last_updated_by NUMBER:= fnd_global.user_id;
3166: l_last_update_login NUMBER:= fnd_global.login_id;
3167: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate,'YYYY/MM/DD');
3168: TmpBillThruDate DATE:= TO_DATE(pa_billing.globvars.BillThruDate,'YYYY/MM/DD');
3169: TmpPADate DATE:= TO_DATE(pa_billing.globvars.PADate,'YYYY/MM/DD');

Line 3166: l_last_update_login NUMBER:= fnd_global.login_id;

3162: l_program_application_id NUMBER:= fnd_global.prog_appl_id;
3163: l_program_update_date DATE := sysdate;
3164: l_last_update_date DATE := sysdate;
3165: l_last_updated_by NUMBER:= fnd_global.user_id;
3166: l_last_update_login NUMBER:= fnd_global.login_id;
3167: TmpInvoiceDate DATE:= TO_DATE(pa_billing.globvars.InvoiceDate,'YYYY/MM/DD');
3168: TmpBillThruDate DATE:= TO_DATE(pa_billing.globvars.BillThruDate,'YYYY/MM/DD');
3169: TmpPADate DATE:= TO_DATE(pa_billing.globvars.PADate,'YYYY/MM/DD');
3170: TmpGLDate DATE:= TO_DATE(pa_billing.globvars.GLDate,'YYYY/MM/DD');