DBA Data[Home] [Help]

APPS.PA_RETENTION_PKG dependencies on PA_BILLING

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

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');
3171:

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

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');
3171:
3172:

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

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');
3171:
3172:
3173: BEGIN

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

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');
3171:
3172:
3173: BEGIN
3174: IF p_invoice_type ='RETENTION' THEN

Line 3322: pa_billing.getpaperiodname,

3318: di.INVPROC_CURRENCY_CODE ,
3319: di.PROJFUNC_INVTRANS_RATE_TYPE ,
3320: di.PROJFUNC_INVTRANS_RATE_DATE ,
3321: di.PROJFUNC_INVTRANS_EX_RATE ,
3322: pa_billing.getpaperiodname,
3323: pa_billing.getglperiodname ,
3324: di.RETENTION_INVOICE_FLAG,
3325: p_draft_invoice_num,
3326: 'Y', -- Added for Bug 2448872

Line 3323: pa_billing.getglperiodname ,

3319: di.PROJFUNC_INVTRANS_RATE_TYPE ,
3320: di.PROJFUNC_INVTRANS_RATE_DATE ,
3321: di.PROJFUNC_INVTRANS_EX_RATE ,
3322: pa_billing.getpaperiodname,
3323: pa_billing.getglperiodname ,
3324: di.RETENTION_INVOICE_FLAG,
3325: p_draft_invoice_num,
3326: 'Y', -- Added for Bug 2448872
3327: di.approved_by_person_id, -- Added for Bug 2448872