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_OUTPUT_TAX dependencies on PA_PLSQL_DATATYPES

Line 383: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,

379: P_agreement_id IN NUMBER ,
380: P_Bill_to_site_use_id IN NUMBER ,
381: P_Ship_to_site_use_id IN NUMBER ,
382: P_Sets_of_books_id IN NUMBER ,
383: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
384: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,
385: P_User_Id IN NUMBER ,
386: P_Request_id IN NUMBER ,
387: P_No_of_rec IN NUMBER ,

Line 384: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,

380: P_Bill_to_site_use_id IN NUMBER ,
381: P_Ship_to_site_use_id IN NUMBER ,
382: P_Sets_of_books_id IN NUMBER ,
383: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
384: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,
385: P_User_Id IN NUMBER ,
386: P_Request_id IN NUMBER ,
387: P_No_of_rec IN NUMBER ,
388: X_Rec_upd OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 389: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

385: P_User_Id IN NUMBER ,
386: P_Request_id IN NUMBER ,
387: P_No_of_rec IN NUMBER ,
388: X_Rec_upd OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
389: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
390: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
391: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
392: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
393: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 390: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,

386: P_Request_id IN NUMBER ,
387: P_No_of_rec IN NUMBER ,
388: X_Rec_upd OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
389: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
390: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
391: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
392: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
393: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
394: p_retention_percentage IN VARCHAR2,

Line 391: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,

387: P_No_of_rec IN NUMBER ,
388: X_Rec_upd OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
389: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
390: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
391: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
392: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
393: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
394: p_retention_percentage IN VARCHAR2,
395: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 392: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

388: X_Rec_upd OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
389: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
390: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
391: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
392: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
393: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
394: p_retention_percentage IN VARCHAR2,
395: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
396: P_invoice_date IN VARCHAR2,

Line 393: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

389: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
390: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
391: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
392: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
393: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
394: p_retention_percentage IN VARCHAR2,
395: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
396: P_invoice_date IN VARCHAR2,
397: x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 395: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

391: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
392: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
393: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
394: p_retention_percentage IN VARCHAR2,
395: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
396: P_invoice_date IN VARCHAR2,
397: x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
398: )
399: IS

Line 417: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,

413: P_agreement_id IN NUMBER ,
414: P_Bill_to_site_use_id IN NUMBER ,
415: P_Ship_to_site_use_id IN NUMBER ,
416: P_Sets_of_books_id IN NUMBER ,
417: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
418: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,
419: P_User_Id IN NUMBER ,
420: P_Request_id IN NUMBER ,
421: P_No_of_rec IN NUMBER ,

Line 418: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,

414: P_Bill_to_site_use_id IN NUMBER ,
415: P_Ship_to_site_use_id IN NUMBER ,
416: P_Sets_of_books_id IN NUMBER ,
417: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp,
418: P_Line_num IN PA_PLSQL_DATATYPES.IdTabTyp,
419: P_User_Id IN NUMBER ,
420: P_Request_id IN NUMBER ,
421: P_No_of_rec IN NUMBER ,
422: X_Rec_upd OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 423: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

419: P_User_Id IN NUMBER ,
420: P_Request_id IN NUMBER ,
421: P_No_of_rec IN NUMBER ,
422: X_Rec_upd OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
423: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
424: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
425: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
426: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
427: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 424: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,

420: P_Request_id IN NUMBER ,
421: P_No_of_rec IN NUMBER ,
422: X_Rec_upd OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
423: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
424: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
425: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
426: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
427: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
428: p_retention_percentage IN VARCHAR2,

Line 425: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,

421: P_No_of_rec IN NUMBER ,
422: X_Rec_upd OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
423: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
424: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
425: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
426: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
427: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
428: p_retention_percentage IN VARCHAR2,
429: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 426: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

422: X_Rec_upd OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
423: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
424: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
425: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
426: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
427: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
428: p_retention_percentage IN VARCHAR2,
429: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
430: P_invoice_date IN VARCHAR2,

Line 427: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

423: P_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
424: P_bill_trans_invoice_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
425: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
426: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
427: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
428: p_retention_percentage IN VARCHAR2,
429: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
430: P_invoice_date IN VARCHAR2,
431: Pbill_to_customer_id IN NUMBER,

Line 429: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

425: P_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
426: P_invproc_invoice_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
427: P_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
428: p_retention_percentage IN VARCHAR2,
429: P_status_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
430: P_invoice_date IN VARCHAR2,
431: Pbill_to_customer_id IN NUMBER,
432: Pship_to_customer_id IN NUMBER,
433: P_shared_funds_consumption IN NUMBER, /* Federal */

Line 434: P_expenditure_item_date IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Federal */

430: P_invoice_date IN VARCHAR2,
431: Pbill_to_customer_id IN NUMBER,
432: Pship_to_customer_id IN NUMBER,
433: P_shared_funds_consumption IN NUMBER, /* Federal */
434: P_expenditure_item_date IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Federal */
435: x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
436: )
437: IS
438: loop_index NUMBER;

Line 474: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;

470: l_msg_count NUMBER;
471: l_msg_data VARCHAR2(240);
472:
473:
474: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
475: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
476: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
477: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
478:

Line 475: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;

471: l_msg_data VARCHAR2(240);
472:
473:
474: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
475: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
476: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
477: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
478:
479: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 476: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

472:
473:
474: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
475: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
476: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
477: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
478:
479: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
480: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 477: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;

473:
474: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
475: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
476: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
477: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
478:
479: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
480: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
481: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 479: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;

475: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
476: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
477: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
478:
479: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
480: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
481: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
482: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
483:

Line 480: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;

476: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
477: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
478:
479: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
480: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
481: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
482: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
483:
484: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 481: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;

477: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
478:
479: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
480: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
481: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
482: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
483:
484: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
485: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 482: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;

478:
479: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
480: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
481: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
482: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
483:
484: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
485: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
486: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 484: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

480: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
481: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
482: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
483:
484: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
485: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
486: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
487: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
488: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 485: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

481: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
482: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
483:
484: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
485: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
486: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
487: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
488: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
489:

Line 486: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

482: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
483:
484: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
485: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
486: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
487: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
488: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
489:
490: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 487: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

483:
484: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
485: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
486: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
487: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
488: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
489:
490: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
491: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 488: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

484: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
485: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
486: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
487: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
488: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
489:
490: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
491: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
492: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 490: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

486: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
487: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
488: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
489:
490: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
491: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
492: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
493: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
494:

Line 491: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

487: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
488: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
489:
490: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
491: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
492: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
493: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
494:
495: tmp_project_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 492: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

488: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
489:
490: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
491: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
492: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
493: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
494:
495: tmp_project_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
496: tmp_projfunc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 493: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

489:
490: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
491: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
492: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
493: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
494:
495: tmp_project_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
496: tmp_projfunc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
497: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 495: tmp_project_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

491: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
492: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
493: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
494:
495: tmp_project_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
496: tmp_projfunc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
497: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
498: tmp_funding_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
499:

Line 496: tmp_projfunc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

492: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
493: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
494:
495: tmp_project_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
496: tmp_projfunc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
497: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
498: tmp_funding_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
499:
500: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 497: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

493: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
494:
495: tmp_project_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
496: tmp_projfunc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
497: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
498: tmp_funding_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
499:
500: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
501: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 498: tmp_funding_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

494:
495: tmp_project_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
496: tmp_projfunc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
497: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
498: tmp_funding_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
499:
500: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
501: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
502: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 500: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

496: tmp_projfunc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
497: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
498: tmp_funding_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
499:
500: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
501: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
502: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
503: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
504:

Line 501: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

497: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
498: tmp_funding_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
499:
500: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
501: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
502: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
503: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
504:
505: tmp_project_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 502: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

498: tmp_funding_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
499:
500: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
501: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
502: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
503: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
504:
505: tmp_project_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
506: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 503: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

499:
500: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
501: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
502: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
503: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
504:
505: tmp_project_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
506: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
507: tmp_projfunc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 505: tmp_project_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

501: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
502: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
503: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
504:
505: tmp_project_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
506: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
507: tmp_projfunc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
508: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
509: tmp_invproc_currency_type VARCHAR2(30);

Line 506: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

502: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
503: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
504:
505: tmp_project_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
506: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
507: tmp_projfunc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
508: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
509: tmp_invproc_currency_type VARCHAR2(30);
510:

Line 507: tmp_projfunc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

503: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
504:
505: tmp_project_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
506: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
507: tmp_projfunc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
508: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
509: tmp_invproc_currency_type VARCHAR2(30);
510:
511: tmp_invoice_eligible_flag VARCHAR2(1) :='Y';

Line 508: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

504:
505: tmp_project_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
506: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
507: tmp_projfunc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
508: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
509: tmp_invproc_currency_type VARCHAR2(30);
510:
511: tmp_invoice_eligible_flag VARCHAR2(1) :='Y';
512:

Line 525: tmp_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;

521: /* Federal Changes */
522:
523: l_agreement_start_date DATE;
524: l_agreement_exp_date DATE;
525: tmp_expenditure_item_date PA_PLSQL_DATATYPES.DateTabTyp;
526:
527: BEGIN
528:
529: -- Multicurrency Related Changes

Line 1254: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp ,

1250: P_Customer_Id IN number ,
1251: P_Bill_to_site_use_id IN number ,
1252: P_Ship_to_site_use_id IN number ,
1253: P_Set_of_books_id IN number ,
1254: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1255: P_User_Id IN NUMBER ,
1256: P_Request_id IN NUMBER ,
1257: P_No_of_records IN NUMBER ,
1258: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

Line 1258: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

1254: P_Expenditure_item_id IN PA_PLSQL_DATATYPES.IdTabTyp ,
1255: P_User_Id IN NUMBER ,
1256: P_Request_id IN NUMBER ,
1257: P_No_of_records IN NUMBER ,
1258: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1259: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1260: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1261: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1262: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 1259: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

1255: P_User_Id IN NUMBER ,
1256: P_Request_id IN NUMBER ,
1257: P_No_of_records IN NUMBER ,
1258: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1259: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1260: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1261: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1262: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1263: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,

Line 1260: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

1256: P_Request_id IN NUMBER ,
1257: P_No_of_records IN NUMBER ,
1258: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1259: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1260: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1261: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1262: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1263: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,
1264: Pbill_to_customer_id IN NUMBER,

Line 1261: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,

1257: P_No_of_records IN NUMBER ,
1258: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1259: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1260: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1261: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1262: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1263: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,
1264: Pbill_to_customer_id IN NUMBER,
1265: Pship_to_customer_id IN NUMBER)

Line 1262: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

1258: P_Compute_flag IN OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1259: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1260: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1261: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1262: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1263: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,
1264: Pbill_to_customer_id IN NUMBER,
1265: Pship_to_customer_id IN NUMBER)
1266: IS

Line 1263: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,

1259: P_Error_Code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1260: X_Output_tax_code OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1261: X_Output_tax_exempt_flag OUT NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,
1262: X_Output_tax_exempt_number OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
1263: X_Output_exempt_reason_code OUT NOCOPY PA_PLSQL_DATATYPES.Char80TabTyp,
1264: Pbill_to_customer_id IN NUMBER,
1265: Pship_to_customer_id IN NUMBER)
1266: IS
1267: BEGIN