DBA Data[Home] [Help]

APPS.PA_RETENTION_PKG dependencies on PA_BILLING

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

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:

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

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:

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

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

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

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

Line 3285: pa_billing.getpaperiodname,

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

Line 3286: pa_billing.getglperiodname ,

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