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_FIN_PLAN_UTILS2 dependencies on PA_VARCHAR2_2000_TBL_TYPE

Line 393: ,x_cost_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

389: ,p_budget_version_id IN Number
390: ,p_start_date IN Date
391: ,p_end_date IN Date
392: ,x_period_name_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
393: ,x_cost_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
394: ,x_burden_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
395: ,x_revenue_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
396: ,x_pc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
397: ,x_pfc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 394: ,x_burden_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

390: ,p_start_date IN Date
391: ,p_end_date IN Date
392: ,x_period_name_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
393: ,x_cost_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
394: ,x_burden_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
395: ,x_revenue_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
396: ,x_pc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
397: ,x_pfc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
398: ,x_other_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 395: ,x_revenue_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

391: ,p_end_date IN Date
392: ,x_period_name_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
393: ,x_cost_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
394: ,x_burden_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
395: ,x_revenue_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
396: ,x_pc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
397: ,x_pfc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
398: ,x_other_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
399: ,x_return_status OUT NOCOPY Varchar2

Line 396: ,x_pc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

392: ,x_period_name_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
393: ,x_cost_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
394: ,x_burden_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
395: ,x_revenue_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
396: ,x_pc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
397: ,x_pfc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
398: ,x_other_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
399: ,x_return_status OUT NOCOPY Varchar2
400: ) IS

Line 397: ,x_pfc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

393: ,x_cost_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
394: ,x_burden_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
395: ,x_revenue_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
396: ,x_pc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
397: ,x_pfc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
398: ,x_other_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
399: ,x_return_status OUT NOCOPY Varchar2
400: ) IS
401: l_stage VARCHAR2(2000);

Line 398: ,x_other_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

394: ,x_burden_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
395: ,x_revenue_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
396: ,x_pc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
397: ,x_pfc_conv_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
398: ,x_other_rejection_data_tab OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
399: ,x_return_status OUT NOCOPY Varchar2
400: ) IS
401: l_stage VARCHAR2(2000);
402: l_tab_project_id SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 414: l_tab_cost_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

410: l_tab_revn_rejection_code SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
411: l_tab_pc_rejection_code SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
412: l_tab_pfc_rejection_code SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
413: l_tab_othr_rejection_code SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
414: l_tab_cost_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
415: l_tab_burd_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
416: l_tab_revn_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
417: l_tab_pc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
418: l_tab_pfc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

Line 415: l_tab_burd_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

411: l_tab_pc_rejection_code SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
412: l_tab_pfc_rejection_code SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
413: l_tab_othr_rejection_code SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
414: l_tab_cost_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
415: l_tab_burd_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
416: l_tab_revn_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
417: l_tab_pc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
418: l_tab_pfc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
419: l_tab_othr_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

Line 416: l_tab_revn_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

412: l_tab_pfc_rejection_code SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
413: l_tab_othr_rejection_code SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
414: l_tab_cost_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
415: l_tab_burd_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
416: l_tab_revn_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
417: l_tab_pc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
418: l_tab_pfc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
419: l_tab_othr_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
420:

Line 417: l_tab_pc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

413: l_tab_othr_rejection_code SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
414: l_tab_cost_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
415: l_tab_burd_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
416: l_tab_revn_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
417: l_tab_pc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
418: l_tab_pfc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
419: l_tab_othr_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
420:
421: l_proc_name varchar2(100) := 'Get_BdgtLineRejctions';

Line 418: l_tab_pfc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

414: l_tab_cost_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
415: l_tab_burd_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
416: l_tab_revn_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
417: l_tab_pc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
418: l_tab_pfc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
419: l_tab_othr_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
420:
421: l_proc_name varchar2(100) := 'Get_BdgtLineRejctions';
422:

Line 419: l_tab_othr_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

415: l_tab_burd_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
416: l_tab_revn_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
417: l_tab_pc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
418: l_tab_pfc_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
419: l_tab_othr_rejection_data SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
420:
421: l_proc_name varchar2(100) := 'Get_BdgtLineRejctions';
422:
423: CURSOR cur_BdgtRejctions IS

Line 464: x_cost_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();

460:
461: x_return_status := 'S';
462: /* Initialize the out varrys */
463: x_period_name_tab := system.PA_VARCHAR2_80_TBL_TYPE();
464: x_cost_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
465: x_burden_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
466: x_revenue_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
467: x_pc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
468: x_pfc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();

Line 465: x_burden_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();

461: x_return_status := 'S';
462: /* Initialize the out varrys */
463: x_period_name_tab := system.PA_VARCHAR2_80_TBL_TYPE();
464: x_cost_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
465: x_burden_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
466: x_revenue_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
467: x_pc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
468: x_pfc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
469: x_other_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();

Line 466: x_revenue_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();

462: /* Initialize the out varrys */
463: x_period_name_tab := system.PA_VARCHAR2_80_TBL_TYPE();
464: x_cost_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
465: x_burden_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
466: x_revenue_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
467: x_pc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
468: x_pfc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
469: x_other_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
470:

Line 467: x_pc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();

463: x_period_name_tab := system.PA_VARCHAR2_80_TBL_TYPE();
464: x_cost_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
465: x_burden_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
466: x_revenue_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
467: x_pc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
468: x_pfc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
469: x_other_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
470:
471:

Line 468: x_pfc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();

464: x_cost_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
465: x_burden_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
466: x_revenue_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
467: x_pc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
468: x_pfc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
469: x_other_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
470:
471:
472: OPEN cur_BdgtRejctions;

Line 469: x_other_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();

465: x_burden_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
466: x_revenue_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
467: x_pc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
468: x_pfc_conv_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
469: x_other_rejection_data_tab := system.PA_VARCHAR2_2000_TBL_TYPE();
470:
471:
472: OPEN cur_BdgtRejctions;
473: FETCH cur_BdgtRejctions BULK COLLECT INTO

Line 2628: l_rowid_tab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

2624: l_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2625: l_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2626: l_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2627: l_ra_date_tab SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2628: l_rowid_tab SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
2629: x_rw_cost_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2630: x_burden_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2631: x_bill_rate_override_tab SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2632: