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

Line 503: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;

499: l_ra NUMBER;
500: l_org_id NUMBER;
501: l_set_of_books_id NUMBER;
502: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
503: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;
504: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
505: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
506: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
507: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 504: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;

500: l_org_id NUMBER;
501: l_set_of_books_id NUMBER;
502: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
503: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;
504: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
505: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
506: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
507: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
508: l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 505: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;

501: l_set_of_books_id NUMBER;
502: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
503: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;
504: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
505: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
506: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
507: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
508: l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
509: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 506: l_quantity_tab pa_plsql_datatypes.NumTabTyp;

502: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
503: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;
504: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
505: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
506: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
507: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
508: l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
509: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
510: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 507: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

503: l_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;
504: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
505: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
506: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
507: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
508: l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
509: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
510: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
511: l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 508: l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;

504: l_txn_currency_code_tab pa_plsql_datatypes.Char30TabTyp;
505: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
506: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
507: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
508: l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
509: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
510: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
511: l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
512: l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 509: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;

505: l_period_name_tab pa_plsql_datatypes.Char30TabTyp;
506: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
507: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
508: l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
509: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
510: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
511: l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
512: l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
513: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 510: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

506: l_quantity_tab pa_plsql_datatypes.NumTabTyp;
507: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
508: l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
509: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
510: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
511: l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
512: l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
513: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
514: l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;

Line 511: l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;

507: l_txn_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
508: l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
509: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
510: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
511: l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
512: l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
513: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
514: l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
515: l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;

Line 512: l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;

508: l_txn_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
509: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
510: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
511: l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
512: l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
513: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
514: l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
515: l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
516: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

Line 513: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

509: l_txn_revenue_tab pa_plsql_datatypes.NumTabTyp;
510: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
511: l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
512: l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
513: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
514: l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
515: l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
516: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
517: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

Line 514: l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;

510: l_proj_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
511: l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
512: l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
513: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
514: l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
515: l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
516: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
517: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
518: l_start_date Date;

Line 515: l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;

511: l_proj_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
512: l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
513: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
514: l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
515: l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
516: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
517: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
518: l_start_date Date;
519: l_end_date Date;

Line 516: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

512: l_proj_revenue_tab pa_plsql_datatypes.NumTabTyp;
513: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
514: l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
515: l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
516: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
517: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
518: l_start_date Date;
519: l_end_date Date;
520:

Line 517: l_end_date_tab pa_plsql_datatypes.DateTabTyp;

513: l_pou_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
514: l_pou_brdn_cost_tab pa_plsql_datatypes.NumTabTyp;
515: l_pou_revenue_tab pa_plsql_datatypes.NumTabTyp;
516: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
517: l_end_date_tab pa_plsql_datatypes.DateTabTyp;
518: l_start_date Date;
519: l_end_date Date;
520:
521: l_amt_dtls_tbl pa_fp_maintain_actual_pub.l_amt_dtls_tbl_typ;

Line 527: l_res_asg_id_tmp_tab pa_plsql_datatypes.IdTabTyp;

523: l_count_no_rlm NUMBER;
524: l_rate_based_flag VARCHAR2(1);
525: l_uncategorized_flag VARCHAR2(1);
526: l_rev_gen_method VARCHAR2(3);
527: l_res_asg_id_tmp_tab pa_plsql_datatypes.IdTabTyp;
528:
529: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
530: l_txn_currency_flag VARCHAR2(1) := 'Y';
531: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.fin_plan_type_id%TYPE;

Line 1319: l_task_id_tab pa_plsql_datatypes.IdTabTyp;

1315: GROUP BY nvl(tmp1.task_id,0),
1316: tmp1.resource_list_member_id,
1317: NVL(c_gen_etc_source_code, NULL);
1318:
1319: l_task_id_tab pa_plsql_datatypes.IdTabTyp;
1320: l_rlm_id_tab pa_plsql_datatypes.IdTabTyp;
1321: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
1322: l_completion_date_tab pa_plsql_datatypes.DateTabTyp;
1323: l_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp;

Line 1320: l_rlm_id_tab pa_plsql_datatypes.IdTabTyp;

1316: tmp1.resource_list_member_id,
1317: NVL(c_gen_etc_source_code, NULL);
1318:
1319: l_task_id_tab pa_plsql_datatypes.IdTabTyp;
1320: l_rlm_id_tab pa_plsql_datatypes.IdTabTyp;
1321: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
1322: l_completion_date_tab pa_plsql_datatypes.DateTabTyp;
1323: l_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp;
1324: l_proj_start_date DATE;

Line 1321: l_start_date_tab pa_plsql_datatypes.DateTabTyp;

1317: NVL(c_gen_etc_source_code, NULL);
1318:
1319: l_task_id_tab pa_plsql_datatypes.IdTabTyp;
1320: l_rlm_id_tab pa_plsql_datatypes.IdTabTyp;
1321: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
1322: l_completion_date_tab pa_plsql_datatypes.DateTabTyp;
1323: l_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp;
1324: l_proj_start_date DATE;
1325: l_proj_completion_date DATE;

Line 1322: l_completion_date_tab pa_plsql_datatypes.DateTabTyp;

1318:
1319: l_task_id_tab pa_plsql_datatypes.IdTabTyp;
1320: l_rlm_id_tab pa_plsql_datatypes.IdTabTyp;
1321: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
1322: l_completion_date_tab pa_plsql_datatypes.DateTabTyp;
1323: l_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp;
1324: l_proj_start_date DATE;
1325: l_proj_completion_date DATE;
1326:

Line 1323: l_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp;

1319: l_task_id_tab pa_plsql_datatypes.IdTabTyp;
1320: l_rlm_id_tab pa_plsql_datatypes.IdTabTyp;
1321: l_start_date_tab pa_plsql_datatypes.DateTabTyp;
1322: l_completion_date_tab pa_plsql_datatypes.DateTabTyp;
1323: l_etc_src_code_tab pa_plsql_datatypes.Char30TabTyp;
1324: l_proj_start_date DATE;
1325: l_proj_completion_date DATE;
1326:
1327: l_gen_etc_source_code_override VARCHAR2(30);