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_BILLING dependencies on PA_PROJECTS_ALL

Line 115: l_project_type pa_projects_all.project_type%type;

111: x_error_message IN OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
112: c INTEGER;
113: row_processed INTEGER;
114: proc_stmt VARCHAR2(1000);
115: l_project_type pa_projects_all.project_type%type;
116: l_distribution_rule pa_projects_all.distribution_rule%type;
117: cursor get_procedure is
118: select be.procedure_name proc_name, bea.billing_assignment_id bea_id,
119: bea.billing_extension_id be_id, bea.top_task_id task_id,

Line 116: l_distribution_rule pa_projects_all.distribution_rule%type;

112: c INTEGER;
113: row_processed INTEGER;
114: proc_stmt VARCHAR2(1000);
115: l_project_type pa_projects_all.project_type%type;
116: l_distribution_rule pa_projects_all.distribution_rule%type;
117: cursor get_procedure is
118: select be.procedure_name proc_name, bea.billing_assignment_id bea_id,
119: bea.billing_extension_id be_id, bea.top_task_id task_id,
120: decode(be.amount_reqd_flag, 'Y', nvl(bea.amount, 0), 0) amt,

Line 232: FROM pa_projects_all

228:
229: /* Added below select statement for bug 3643409 */
230: SELECT project_type,distribution_rule
231: INTO l_project_type,l_distribution_rule
232: FROM pa_projects_all
233: WHERE project_id = x_project_id;
234:
235: FOR get_rec IN get_procedure LOOP
236: -- Loop for each assigned Billing Extension

Line 404: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;

400:
401: ccrev_error EXCEPTION;
402:
403: /* MCB related changes */
404: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
405: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
406: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
407: l_invproc_currency_code VARCHAR2(30);
408: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 405: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;

401: ccrev_error EXCEPTION;
402:
403: /* MCB related changes */
404: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
405: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
406: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
407: l_invproc_currency_code VARCHAR2(30);
408: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
409: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 406: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

402:
403: /* MCB related changes */
404: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
405: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
406: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
407: l_invproc_currency_code VARCHAR2(30);
408: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
409: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
410: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 408: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

404: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
405: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
406: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
407: l_invproc_currency_code VARCHAR2(30);
408: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
409: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
410: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
411: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
412: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 409: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

405: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
406: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
407: l_invproc_currency_code VARCHAR2(30);
408: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
409: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
410: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
411: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
412: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
413: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 410: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

406: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
407: l_invproc_currency_code VARCHAR2(30);
408: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
409: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
410: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
411: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
412: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
413: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
414: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 411: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

407: l_invproc_currency_code VARCHAR2(30);
408: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
409: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
410: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
411: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
412: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
413: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
414: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
415: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 412: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

408: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
409: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
410: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
411: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
412: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
413: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
414: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
415: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
416: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 413: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

409: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
410: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
411: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
412: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
413: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
414: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
415: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
416: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
417: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 414: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

410: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
411: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
412: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
413: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
414: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
415: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
416: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
417: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
418: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 415: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

411: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
412: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
413: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
414: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
415: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
416: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
417: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
418: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
419: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 416: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

412: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
413: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
414: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
415: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
416: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
417: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
418: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
419: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
420: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 417: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

413: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
414: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
415: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
416: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
417: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
418: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
419: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
420: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
421: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 418: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

414: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
415: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
416: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
417: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
418: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
419: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
420: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
421: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
422: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 419: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

415: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
416: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
417: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
418: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
419: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
420: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
421: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
422: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
423: l_return_status VARCHAR2(30);

Line 420: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

416: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
417: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
418: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
419: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
420: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
421: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
422: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
423: l_return_status VARCHAR2(30);
424: l_msg_count NUMBER;

Line 421: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

417: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
418: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
419: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
420: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
421: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
422: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
423: l_return_status VARCHAR2(30);
424: l_msg_count NUMBER;
425: l_msg_data VARCHAR2(30);

Line 422: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

418: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
419: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
420: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
421: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
422: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
423: l_return_status VARCHAR2(30);
424: l_msg_count NUMBER;
425: l_msg_data VARCHAR2(30);
426: /* Till Here */

Line 1804: /* Bug 2638840 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */

1800: /* Commenting the following line for bug 2638840
1801: rev_amount( j ) := to_char(l_ind_cost_denm); */
1802:
1803: /* Changes for bug 2638840 */
1804: /* Bug 2638840 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */
1805: BEGIN
1806:
1807: /* Added the following nvl so that code doesn't break even if upgrade script fails - For bug 2724185 */
1808:

Line 1811: from pa_projects_all

1807: /* Added the following nvl so that code doesn't break even if upgrade script fails - For bug 2724185 */
1808:
1809: select nvl(BTC_COST_BASE_REV_CODE,'EXP_TRANS_CURR')
1810: into l_mcb_cost_flag
1811: from pa_projects_all
1812: where project_id =(select project_id from pa_expenditure_items_all where expenditure_item_id=ei_id(j));
1813:
1814: EXCEPTION
1815: WHEN NO_DATA_FOUND THEN