[Home] [Help]
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');
3134:
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');
3134:
3135:
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');
3134:
3135:
3136: BEGIN
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');
3134:
3135:
3136: BEGIN
3137: IF p_invoice_type ='RETENTION' THEN
3281: di.INVPROC_CURRENCY_CODE ,
3282: di.PROJFUNC_INVTRANS_RATE_TYPE ,
3283: di.PROJFUNC_INVTRANS_RATE_DATE ,
3284: di.PROJFUNC_INVTRANS_EX_RATE ,
3285: pa_billing.getpaperiodname,
3286: pa_billing.getglperiodname ,
3287: di.RETENTION_INVOICE_FLAG,
3288: p_draft_invoice_num,
3289: 'Y', -- Added for Bug 2448872
3282: di.PROJFUNC_INVTRANS_RATE_TYPE ,
3283: di.PROJFUNC_INVTRANS_RATE_DATE ,
3284: di.PROJFUNC_INVTRANS_EX_RATE ,
3285: pa_billing.getpaperiodname,
3286: pa_billing.getglperiodname ,
3287: di.RETENTION_INVOICE_FLAG,
3288: p_draft_invoice_num,
3289: 'Y', -- Added for Bug 2448872
3290: di.approved_by_person_id, -- Added for Bug 2448872