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_PLAN_MATRIX dependencies on PA_BUDGET_LINES

Line 75: FROM pa_budget_lines pa_bdgt

71: SELECT min(pa_bdgt.start_date),
72: max(pa_bdgt.start_date)
73: INTO l_min_pa_bdgt_st_dt,
74: l_max_pa_bdgt_st_dt
75: FROM pa_budget_lines pa_bdgt
76: WHERE pa_bdgt.resource_assignment_id = l_resource_assignment_id
77: AND pa_bdgt.TXN_CURRENCY_CODE = l_transaction_currency_code
78: AND pa_bdgt.bucketing_period_code IS NULL;
79:

Line 335: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type; /* FPB2: MRC */

331: l_succ_proj_revenue NUMBER;
332: l_succ_proj_curr_code VARCHAR2(30);
333: l_debug_mode VARCHAR2(30);
334:
335: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type; /* FPB2: MRC */
336: l_version_type pa_budget_versions.version_type%TYPE;
337: l_raw_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
338: l_bd_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
339: l_rev_source pa_budget_lines.RAW_COST_SOURCE%TYPE;

Line 337: l_raw_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;

333: l_debug_mode VARCHAR2(30);
334:
335: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type; /* FPB2: MRC */
336: l_version_type pa_budget_versions.version_type%TYPE;
337: l_raw_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
338: l_bd_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
339: l_rev_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
340: l_qty_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
341: CURSOR Main_Tmp_Cur IS

Line 338: l_bd_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;

334:
335: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type; /* FPB2: MRC */
336: l_version_type pa_budget_versions.version_type%TYPE;
337: l_raw_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
338: l_bd_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
339: l_rev_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
340: l_qty_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
341: CURSOR Main_Tmp_Cur IS
342: SELECT DISTINCT Resource_Assignment_Id,

Line 339: l_rev_source pa_budget_lines.RAW_COST_SOURCE%TYPE;

335: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%type; /* FPB2: MRC */
336: l_version_type pa_budget_versions.version_type%TYPE;
337: l_raw_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
338: l_bd_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
339: l_rev_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
340: l_qty_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
341: CURSOR Main_Tmp_Cur IS
342: SELECT DISTINCT Resource_Assignment_Id,
343: Source_Txn_Currency_Code

Line 340: l_qty_source pa_budget_lines.RAW_COST_SOURCE%TYPE;

336: l_version_type pa_budget_versions.version_type%TYPE;
337: l_raw_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
338: l_bd_cost_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
339: l_rev_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
340: l_qty_source pa_budget_lines.RAW_COST_SOURCE%TYPE;
341: CURSOR Main_Tmp_Cur IS
342: SELECT DISTINCT Resource_Assignment_Id,
343: Source_Txn_Currency_Code
344: FROM Pa_Fin_Plan_Lines_Tmp;

Line 431: -- pa_budget_lines table and Pa_Proj_Period_Profiles table.

427: -- End Date - l_st_dt_4_end_pd
428:
429: -- Get The Period Name, Start Date and End Date from the GL_periods
430: -- Table for the minimum of start date and end date derived from the
431: -- pa_budget_lines table and Pa_Proj_Period_Profiles table.
432:
433: -- Assigning values from cursor to the local variable
434: l_resource_assignment_id := main_cur_rec.resource_assignment_id;
435: l_transaction_currency_code := main_cur_rec.source_txn_currency_code;

Line 445: UPDATE Pa_Budget_Lines

441:
442: /* FPB2: MRC No changes done as no amount columns are being updated.
443: DO NOT ADD ANY AMOUNT COLUMNS TO THIS UPDATE. ELSE MAKE CALL TO MRC !!!!
444: */
445: UPDATE Pa_Budget_Lines
446: SET Bucketing_Period_Code = NULL
447: WHERE Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
448: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
449: AND ( Pa_Budget_Lines.Bucketing_period_code = 'PE' -- Bug 2810094. update the SE records where

Line 447: WHERE Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id

443: DO NOT ADD ANY AMOUNT COLUMNS TO THIS UPDATE. ELSE MAKE CALL TO MRC !!!!
444: */
445: UPDATE Pa_Budget_Lines
446: SET Bucketing_Period_Code = NULL
447: WHERE Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
448: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
449: AND ( Pa_Budget_Lines.Bucketing_period_code = 'PE' -- Bug 2810094. update the SE records where
450: OR -- start_date < period profile start period start date
451: (Pa_Budget_Lines.Bucketing_period_code = 'SE' AND -- with bucketing period code as null

Line 448: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code

444: */
445: UPDATE Pa_Budget_Lines
446: SET Bucketing_Period_Code = NULL
447: WHERE Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
448: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
449: AND ( Pa_Budget_Lines.Bucketing_period_code = 'PE' -- Bug 2810094. update the SE records where
450: OR -- start_date < period profile start period start date
451: (Pa_Budget_Lines.Bucketing_period_code = 'SE' AND -- with bucketing period code as null
452: Pa_Budget_Lines.start_date < p_st_dt_4_st_pd

Line 449: AND ( Pa_Budget_Lines.Bucketing_period_code = 'PE' -- Bug 2810094. update the SE records where

445: UPDATE Pa_Budget_Lines
446: SET Bucketing_Period_Code = NULL
447: WHERE Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
448: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
449: AND ( Pa_Budget_Lines.Bucketing_period_code = 'PE' -- Bug 2810094. update the SE records where
450: OR -- start_date < period profile start period start date
451: (Pa_Budget_Lines.Bucketing_period_code = 'SE' AND -- with bucketing period code as null
452: Pa_Budget_Lines.start_date < p_st_dt_4_st_pd
453: )

Line 451: (Pa_Budget_Lines.Bucketing_period_code = 'SE' AND -- with bucketing period code as null

447: WHERE Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
448: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
449: AND ( Pa_Budget_Lines.Bucketing_period_code = 'PE' -- Bug 2810094. update the SE records where
450: OR -- start_date < period profile start period start date
451: (Pa_Budget_Lines.Bucketing_period_code = 'SE' AND -- with bucketing period code as null
452: Pa_Budget_Lines.start_date < p_st_dt_4_st_pd
453: )
454: );
455: -- Getting the Preceding period start date, end date and period name

Line 452: Pa_Budget_Lines.start_date < p_st_dt_4_st_pd

448: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
449: AND ( Pa_Budget_Lines.Bucketing_period_code = 'PE' -- Bug 2810094. update the SE records where
450: OR -- start_date < period profile start period start date
451: (Pa_Budget_Lines.Bucketing_period_code = 'SE' AND -- with bucketing period code as null
452: Pa_Budget_Lines.start_date < p_st_dt_4_st_pd
453: )
454: );
455: -- Getting the Preceding period start date, end date and period name
456:

Line 558: UPDATE Pa_Budget_Lines

554: BEGIN
555:
556: l_budget_line_id := Null; /* FPB2 */
557: -- updation of amount has been commented for bug#2817407
558: UPDATE Pa_Budget_Lines
559: SET
560: Period_Name = l_bdgt_prec_per_name,
561: Start_Date = l_bdgt_prec_per_st_dt,
562: End_Date = l_bdgt_prec_per_end_dt,

Line 577: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code

573: LAST_UPDATE_LOGIN = l_last_update_login,
574: LAST_UPDATED_BY = l_last_updated_by,
575: LAST_UPDATE_DATE = l_last_update_date
576: WHERE resource_assignment_id = main_cur_rec.resource_assignment_id
577: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
578: AND Pa_Budget_Lines.bucketing_period_code = l_bucketing_period_code
579: AND budget_version_id = l_budget_version_id
580: returning budget_line_id into l_budget_line_id; /* FPB2: MRC */
581:

Line 578: AND Pa_Budget_Lines.bucketing_period_code = l_bucketing_period_code

574: LAST_UPDATED_BY = l_last_updated_by,
575: LAST_UPDATE_DATE = l_last_update_date
576: WHERE resource_assignment_id = main_cur_rec.resource_assignment_id
577: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
578: AND Pa_Budget_Lines.bucketing_period_code = l_bucketing_period_code
579: AND budget_version_id = l_budget_version_id
580: returning budget_line_id into l_budget_line_id; /* FPB2: MRC */
581:
582: IF SQL%ROWCOUNT = 0 THEN

Line 584: select pa_budget_lines_s.nextval

580: returning budget_line_id into l_budget_line_id; /* FPB2: MRC */
581:
582: IF SQL%ROWCOUNT = 0 THEN
583:
584: select pa_budget_lines_s.nextval
585: into l_budget_line_id
586: from dual;
587:
588: INSERT INTO PA_BUDGET_LINES

Line 588: INSERT INTO PA_BUDGET_LINES

584: select pa_budget_lines_s.nextval
585: into l_budget_line_id
586: from dual;
587:
588: INSERT INTO PA_BUDGET_LINES
589: (budget_line_id, /* FPB2 */
590: budget_version_id, /* FPB2 */
591: Resource_Assignment_Id,
592: Start_Date,

Line 698: UPDATE Pa_Budget_Lines

694: -- the start period from the period profile table
695:
696: /* FPB2 : MRC DO NOT ADD AMOUNT COLUMNS TO THE UPDATE OR CONSIDER MRC IMPACT !!! */
697:
698: UPDATE Pa_Budget_Lines
699: SET Bucketing_Period_Code = 'PE'
700: WHERE Pa_Budget_Lines.START_DATE < l_st_dt_4_st_pd
701: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
702: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code

Line 700: WHERE Pa_Budget_Lines.START_DATE < l_st_dt_4_st_pd

696: /* FPB2 : MRC DO NOT ADD AMOUNT COLUMNS TO THE UPDATE OR CONSIDER MRC IMPACT !!! */
697:
698: UPDATE Pa_Budget_Lines
699: SET Bucketing_Period_Code = 'PE'
700: WHERE Pa_Budget_Lines.START_DATE < l_st_dt_4_st_pd
701: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
702: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
703: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;
704:

Line 701: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id

697:
698: UPDATE Pa_Budget_Lines
699: SET Bucketing_Period_Code = 'PE'
700: WHERE Pa_Budget_Lines.START_DATE < l_st_dt_4_st_pd
701: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
702: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
703: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;
704:
705: END IF; -- End of if for bucketing period code PD

Line 702: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code

698: UPDATE Pa_Budget_Lines
699: SET Bucketing_Period_Code = 'PE'
700: WHERE Pa_Budget_Lines.START_DATE < l_st_dt_4_st_pd
701: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
702: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
703: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;
704:
705: END IF; -- End of if for bucketing period code PD
706:

Line 703: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;

699: SET Bucketing_Period_Code = 'PE'
700: WHERE Pa_Budget_Lines.START_DATE < l_st_dt_4_st_pd
701: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
702: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
703: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;
704:
705: END IF; -- End of if for bucketing period code PD
706:
707: IF (l_bucketing_period_code = 'SD') THEN

Line 716: UPDATE Pa_Budget_Lines

712:
713: /* FPB2 : Please note that if the following update is modified to udpate
714: amount columns MRC api call needs to be made appropirately */
715:
716: UPDATE Pa_Budget_Lines
717: SET Bucketing_Period_Code = NULL
718: WHERE Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
719: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
720: AND ( Pa_Budget_Lines.Bucketing_period_code = 'SE' -- Bug 2810094. update the PE records where

Line 718: WHERE Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id

714: amount columns MRC api call needs to be made appropirately */
715:
716: UPDATE Pa_Budget_Lines
717: SET Bucketing_Period_Code = NULL
718: WHERE Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
719: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
720: AND ( Pa_Budget_Lines.Bucketing_period_code = 'SE' -- Bug 2810094. update the PE records where
721: OR -- start_date > period profile end period start date
722: ( -- with bucketing period code as null

Line 719: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code

715:
716: UPDATE Pa_Budget_Lines
717: SET Bucketing_Period_Code = NULL
718: WHERE Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
719: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
720: AND ( Pa_Budget_Lines.Bucketing_period_code = 'SE' -- Bug 2810094. update the PE records where
721: OR -- start_date > period profile end period start date
722: ( -- with bucketing period code as null
723: Pa_Budget_Lines.Bucketing_period_code = 'PE'

Line 720: AND ( Pa_Budget_Lines.Bucketing_period_code = 'SE' -- Bug 2810094. update the PE records where

716: UPDATE Pa_Budget_Lines
717: SET Bucketing_Period_Code = NULL
718: WHERE Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
719: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
720: AND ( Pa_Budget_Lines.Bucketing_period_code = 'SE' -- Bug 2810094. update the PE records where
721: OR -- start_date > period profile end period start date
722: ( -- with bucketing period code as null
723: Pa_Budget_Lines.Bucketing_period_code = 'PE'
724: AND Pa_Budget_Lines.Start_Date > l_st_dt_4_end_pd

Line 723: Pa_Budget_Lines.Bucketing_period_code = 'PE'

719: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
720: AND ( Pa_Budget_Lines.Bucketing_period_code = 'SE' -- Bug 2810094. update the PE records where
721: OR -- start_date > period profile end period start date
722: ( -- with bucketing period code as null
723: Pa_Budget_Lines.Bucketing_period_code = 'PE'
724: AND Pa_Budget_Lines.Start_Date > l_st_dt_4_end_pd
725: )
726: );
727: -- Getting the Succeeding period start date, end date and period name

Line 724: AND Pa_Budget_Lines.Start_Date > l_st_dt_4_end_pd

720: AND ( Pa_Budget_Lines.Bucketing_period_code = 'SE' -- Bug 2810094. update the PE records where
721: OR -- start_date > period profile end period start date
722: ( -- with bucketing period code as null
723: Pa_Budget_Lines.Bucketing_period_code = 'PE'
724: AND Pa_Budget_Lines.Start_Date > l_st_dt_4_end_pd
725: )
726: );
727: -- Getting the Succeeding period start date, end date and period name
728:

Line 831: UPDATE Pa_Budget_Lines

827: BEGIN
828:
829: l_budget_line_id := Null; /* FPB2 */
830: -- updation of amount has been commented for bug#2817407
831: UPDATE Pa_Budget_Lines
832: SET
833: Period_Name = l_bdgt_succ_per_name,
834: Start_Date = l_bdgt_succ_per_st_dt,
835: End_Date = l_bdgt_succ_per_end_dt,

Line 850: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code

846: LAST_UPDATE_LOGIN = l_last_update_login,
847: LAST_UPDATED_BY = l_last_updated_by,
848: LAST_UPDATE_DATE = l_last_update_date
849: WHERE resource_assignment_id = main_cur_rec.resource_assignment_id
850: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
851: AND Pa_Budget_Lines.bucketing_period_code = l_bucketing_period_code
852: AND budget_version_id = l_budget_version_id
853: returning budget_line_id into l_budget_line_id;
854:

Line 851: AND Pa_Budget_Lines.bucketing_period_code = l_bucketing_period_code

847: LAST_UPDATED_BY = l_last_updated_by,
848: LAST_UPDATE_DATE = l_last_update_date
849: WHERE resource_assignment_id = main_cur_rec.resource_assignment_id
850: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
851: AND Pa_Budget_Lines.bucketing_period_code = l_bucketing_period_code
852: AND budget_version_id = l_budget_version_id
853: returning budget_line_id into l_budget_line_id;
854:
855: -- Bug Fix: 4569365. Removed MRC code.

Line 884: select pa_budget_lines_s.nextval

880: END IF;
881: */
882: ELSE
883: /*IF SQL%ROWCOUNT = 0 THEN*/
884: select pa_budget_lines_s.nextval
885: into l_budget_line_id
886: from dual;
887:
888: INSERT INTO PA_BUDGET_LINES

Line 888: INSERT INTO PA_BUDGET_LINES

884: select pa_budget_lines_s.nextval
885: into l_budget_line_id
886: from dual;
887:
888: INSERT INTO PA_BUDGET_LINES
889: (Budget_Line_id, /* FPB2 */
890: Budget_Version_id, /* FPB2 */
891: Resource_Assignment_Id,
892: Start_Date,

Line 997: UPDATE Pa_Budget_Lines

993: -- Updating the Budget Line Tables to store the Values for
994: -- Succeeding Entered l_st_dt_4_end_pd is the start date of
995: -- the end period from the period profile table
996:
997: UPDATE Pa_Budget_Lines
998: SET Bucketing_Period_Code = 'SE'
999: WHERE Pa_Budget_Lines.START_DATE > l_st_dt_4_end_pd
1000: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
1001: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code

Line 999: WHERE Pa_Budget_Lines.START_DATE > l_st_dt_4_end_pd

995: -- the end period from the period profile table
996:
997: UPDATE Pa_Budget_Lines
998: SET Bucketing_Period_Code = 'SE'
999: WHERE Pa_Budget_Lines.START_DATE > l_st_dt_4_end_pd
1000: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
1001: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
1002: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;
1003: END IF; -- End of if for bucketing period code SD

Line 1000: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id

996:
997: UPDATE Pa_Budget_Lines
998: SET Bucketing_Period_Code = 'SE'
999: WHERE Pa_Budget_Lines.START_DATE > l_st_dt_4_end_pd
1000: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
1001: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
1002: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;
1003: END IF; -- End of if for bucketing period code SD
1004: END LOOP;

Line 1001: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code

997: UPDATE Pa_Budget_Lines
998: SET Bucketing_Period_Code = 'SE'
999: WHERE Pa_Budget_Lines.START_DATE > l_st_dt_4_end_pd
1000: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
1001: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
1002: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;
1003: END IF; -- End of if for bucketing period code SD
1004: END LOOP;
1005: EXCEPTION

Line 1002: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;

998: SET Bucketing_Period_Code = 'SE'
999: WHERE Pa_Budget_Lines.START_DATE > l_st_dt_4_end_pd
1000: AND Pa_Budget_Lines.resource_assignment_id = main_cur_rec.resource_assignment_id
1001: AND Pa_Budget_Lines.TXN_CURRENCY_CODE = main_cur_rec.source_txn_currency_code
1002: AND Pa_Budget_Lines.Bucketing_period_code IS NULL;
1003: END IF; -- End of if for bucketing period code SD
1004: END LOOP;
1005: EXCEPTION
1006: WHEN OTHERS THEN

Line 1033: l_start_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1029: p_debug_mode IN VARCHAR2,
1030: p_add_msg_in_stack IN VARCHAR2,
1031: p_calling_module IN VARCHAR2) IS
1032:
1033: l_start_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1034: l_st_dt_4_st_pd DATE;
1035: l_end_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1036: l_st_dt_4_end_pd DATE;
1037: l_period_name1 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1035: l_end_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1031: p_calling_module IN VARCHAR2) IS
1032:
1033: l_start_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1034: l_st_dt_4_st_pd DATE;
1035: l_end_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1036: l_st_dt_4_end_pd DATE;
1037: l_period_name1 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1038: l_period_name2 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1039: l_period_name3 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1037: l_period_name1 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1033: l_start_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1034: l_st_dt_4_st_pd DATE;
1035: l_end_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1036: l_st_dt_4_end_pd DATE;
1037: l_period_name1 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1038: l_period_name2 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1039: l_period_name3 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1040: l_period_name4 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1041: l_period_name5 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1038: l_period_name2 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1034: l_st_dt_4_st_pd DATE;
1035: l_end_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1036: l_st_dt_4_end_pd DATE;
1037: l_period_name1 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1038: l_period_name2 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1039: l_period_name3 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1040: l_period_name4 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1041: l_period_name5 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1042: l_period_name6 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1039: l_period_name3 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1035: l_end_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1036: l_st_dt_4_end_pd DATE;
1037: l_period_name1 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1038: l_period_name2 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1039: l_period_name3 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1040: l_period_name4 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1041: l_period_name5 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1042: l_period_name6 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1043: l_period_name7 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1040: l_period_name4 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1036: l_st_dt_4_end_pd DATE;
1037: l_period_name1 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1038: l_period_name2 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1039: l_period_name3 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1040: l_period_name4 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1041: l_period_name5 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1042: l_period_name6 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1043: l_period_name7 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1044: l_period_name8 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1041: l_period_name5 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1037: l_period_name1 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1038: l_period_name2 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1039: l_period_name3 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1040: l_period_name4 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1041: l_period_name5 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1042: l_period_name6 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1043: l_period_name7 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1044: l_period_name8 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1045: l_period_name9 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1042: l_period_name6 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1038: l_period_name2 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1039: l_period_name3 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1040: l_period_name4 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1041: l_period_name5 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1042: l_period_name6 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1043: l_period_name7 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1044: l_period_name8 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1045: l_period_name9 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1046: l_period_name10 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1043: l_period_name7 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1039: l_period_name3 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1040: l_period_name4 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1041: l_period_name5 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1042: l_period_name6 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1043: l_period_name7 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1044: l_period_name8 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1045: l_period_name9 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1046: l_period_name10 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1047: l_period_name11 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1044: l_period_name8 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1040: l_period_name4 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1041: l_period_name5 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1042: l_period_name6 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1043: l_period_name7 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1044: l_period_name8 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1045: l_period_name9 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1046: l_period_name10 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1047: l_period_name11 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1048: l_period_name12 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1045: l_period_name9 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1041: l_period_name5 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1042: l_period_name6 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1043: l_period_name7 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1044: l_period_name8 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1045: l_period_name9 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1046: l_period_name10 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1047: l_period_name11 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1048: l_period_name12 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1049: l_period_name13 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1046: l_period_name10 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1042: l_period_name6 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1043: l_period_name7 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1044: l_period_name8 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1045: l_period_name9 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1046: l_period_name10 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1047: l_period_name11 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1048: l_period_name12 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1049: l_period_name13 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1050: l_period_name14 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1047: l_period_name11 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1043: l_period_name7 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1044: l_period_name8 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1045: l_period_name9 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1046: l_period_name10 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1047: l_period_name11 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1048: l_period_name12 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1049: l_period_name13 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1050: l_period_name14 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1051: l_period_name15 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1048: l_period_name12 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1044: l_period_name8 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1045: l_period_name9 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1046: l_period_name10 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1047: l_period_name11 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1048: l_period_name12 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1049: l_period_name13 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1050: l_period_name14 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1051: l_period_name15 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1052: l_period_name16 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1049: l_period_name13 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1045: l_period_name9 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1046: l_period_name10 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1047: l_period_name11 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1048: l_period_name12 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1049: l_period_name13 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1050: l_period_name14 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1051: l_period_name15 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1052: l_period_name16 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1053: l_period_name17 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1050: l_period_name14 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1046: l_period_name10 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1047: l_period_name11 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1048: l_period_name12 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1049: l_period_name13 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1050: l_period_name14 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1051: l_period_name15 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1052: l_period_name16 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1053: l_period_name17 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1054: l_period_name18 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1051: l_period_name15 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1047: l_period_name11 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1048: l_period_name12 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1049: l_period_name13 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1050: l_period_name14 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1051: l_period_name15 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1052: l_period_name16 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1053: l_period_name17 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1054: l_period_name18 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1055: l_period_name19 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1052: l_period_name16 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1048: l_period_name12 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1049: l_period_name13 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1050: l_period_name14 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1051: l_period_name15 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1052: l_period_name16 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1053: l_period_name17 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1054: l_period_name18 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1055: l_period_name19 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1056: l_period_name20 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1053: l_period_name17 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1049: l_period_name13 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1050: l_period_name14 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1051: l_period_name15 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1052: l_period_name16 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1053: l_period_name17 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1054: l_period_name18 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1055: l_period_name19 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1056: l_period_name20 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1057: l_period_name21 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1054: l_period_name18 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1050: l_period_name14 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1051: l_period_name15 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1052: l_period_name16 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1053: l_period_name17 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1054: l_period_name18 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1055: l_period_name19 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1056: l_period_name20 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1057: l_period_name21 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1058: l_period_name22 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1055: l_period_name19 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1051: l_period_name15 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1052: l_period_name16 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1053: l_period_name17 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1054: l_period_name18 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1055: l_period_name19 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1056: l_period_name20 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1057: l_period_name21 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1058: l_period_name22 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1059: l_period_name23 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1056: l_period_name20 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1052: l_period_name16 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1053: l_period_name17 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1054: l_period_name18 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1055: l_period_name19 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1056: l_period_name20 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1057: l_period_name21 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1058: l_period_name22 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1059: l_period_name23 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1060: l_period_name24 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1057: l_period_name21 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1053: l_period_name17 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1054: l_period_name18 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1055: l_period_name19 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1056: l_period_name20 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1057: l_period_name21 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1058: l_period_name22 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1059: l_period_name23 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1060: l_period_name24 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1061: l_period_name25 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1058: l_period_name22 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1054: l_period_name18 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1055: l_period_name19 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1056: l_period_name20 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1057: l_period_name21 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1058: l_period_name22 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1059: l_period_name23 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1060: l_period_name24 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1061: l_period_name25 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1062: l_period_name26 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1059: l_period_name23 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1055: l_period_name19 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1056: l_period_name20 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1057: l_period_name21 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1058: l_period_name22 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1059: l_period_name23 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1060: l_period_name24 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1061: l_period_name25 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1062: l_period_name26 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1063: l_period_name27 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1060: l_period_name24 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1056: l_period_name20 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1057: l_period_name21 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1058: l_period_name22 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1059: l_period_name23 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1060: l_period_name24 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1061: l_period_name25 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1062: l_period_name26 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1063: l_period_name27 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1064: l_period_name28 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1061: l_period_name25 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1057: l_period_name21 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1058: l_period_name22 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1059: l_period_name23 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1060: l_period_name24 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1061: l_period_name25 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1062: l_period_name26 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1063: l_period_name27 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1064: l_period_name28 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1065: l_period_name29 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1062: l_period_name26 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1058: l_period_name22 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1059: l_period_name23 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1060: l_period_name24 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1061: l_period_name25 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1062: l_period_name26 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1063: l_period_name27 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1064: l_period_name28 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1065: l_period_name29 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1066: l_period_name30 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1063: l_period_name27 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1059: l_period_name23 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1060: l_period_name24 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1061: l_period_name25 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1062: l_period_name26 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1063: l_period_name27 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1064: l_period_name28 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1065: l_period_name29 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1066: l_period_name30 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1067: l_period_name31 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1064: l_period_name28 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1060: l_period_name24 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1061: l_period_name25 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1062: l_period_name26 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1063: l_period_name27 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1064: l_period_name28 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1065: l_period_name29 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1066: l_period_name30 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1067: l_period_name31 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1068: l_period_name32 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1065: l_period_name29 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1061: l_period_name25 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1062: l_period_name26 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1063: l_period_name27 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1064: l_period_name28 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1065: l_period_name29 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1066: l_period_name30 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1067: l_period_name31 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1068: l_period_name32 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1069: l_period_name33 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1066: l_period_name30 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1062: l_period_name26 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1063: l_period_name27 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1064: l_period_name28 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1065: l_period_name29 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1066: l_period_name30 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1067: l_period_name31 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1068: l_period_name32 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1069: l_period_name33 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1070: l_period_name34 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1067: l_period_name31 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1063: l_period_name27 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1064: l_period_name28 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1065: l_period_name29 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1066: l_period_name30 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1067: l_period_name31 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1068: l_period_name32 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1069: l_period_name33 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1070: l_period_name34 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1071: l_period_name35 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1068: l_period_name32 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1064: l_period_name28 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1065: l_period_name29 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1066: l_period_name30 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1067: l_period_name31 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1068: l_period_name32 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1069: l_period_name33 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1070: l_period_name34 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1071: l_period_name35 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1072: l_period_name36 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1069: l_period_name33 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1065: l_period_name29 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1066: l_period_name30 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1067: l_period_name31 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1068: l_period_name32 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1069: l_period_name33 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1070: l_period_name34 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1071: l_period_name35 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1072: l_period_name36 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1073: l_period_name37 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1070: l_period_name34 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1066: l_period_name30 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1067: l_period_name31 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1068: l_period_name32 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1069: l_period_name33 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1070: l_period_name34 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1071: l_period_name35 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1072: l_period_name36 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1073: l_period_name37 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1074: l_period_name38 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1071: l_period_name35 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1067: l_period_name31 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1068: l_period_name32 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1069: l_period_name33 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1070: l_period_name34 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1071: l_period_name35 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1072: l_period_name36 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1073: l_period_name37 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1074: l_period_name38 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1075: l_period_name39 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1072: l_period_name36 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1068: l_period_name32 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1069: l_period_name33 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1070: l_period_name34 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1071: l_period_name35 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1072: l_period_name36 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1073: l_period_name37 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1074: l_period_name38 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1075: l_period_name39 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1076: l_period_name40 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1073: l_period_name37 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1069: l_period_name33 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1070: l_period_name34 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1071: l_period_name35 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1072: l_period_name36 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1073: l_period_name37 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1074: l_period_name38 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1075: l_period_name39 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1076: l_period_name40 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1077: l_period_name41 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1074: l_period_name38 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1070: l_period_name34 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1071: l_period_name35 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1072: l_period_name36 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1073: l_period_name37 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1074: l_period_name38 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1075: l_period_name39 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1076: l_period_name40 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1077: l_period_name41 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1078: l_period_name42 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1075: l_period_name39 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1071: l_period_name35 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1072: l_period_name36 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1073: l_period_name37 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1074: l_period_name38 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1075: l_period_name39 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1076: l_period_name40 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1077: l_period_name41 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1078: l_period_name42 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1079: l_period_name43 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1076: l_period_name40 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1072: l_period_name36 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1073: l_period_name37 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1074: l_period_name38 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1075: l_period_name39 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1076: l_period_name40 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1077: l_period_name41 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1078: l_period_name42 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1079: l_period_name43 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1080: l_period_name44 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1077: l_period_name41 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1073: l_period_name37 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1074: l_period_name38 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1075: l_period_name39 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1076: l_period_name40 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1077: l_period_name41 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1078: l_period_name42 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1079: l_period_name43 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1080: l_period_name44 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1081: l_period_name45 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1078: l_period_name42 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1074: l_period_name38 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1075: l_period_name39 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1076: l_period_name40 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1077: l_period_name41 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1078: l_period_name42 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1079: l_period_name43 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1080: l_period_name44 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1081: l_period_name45 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1082: l_period_name46 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1079: l_period_name43 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1075: l_period_name39 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1076: l_period_name40 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1077: l_period_name41 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1078: l_period_name42 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1079: l_period_name43 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1080: l_period_name44 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1081: l_period_name45 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1082: l_period_name46 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1083: l_period_name47 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1080: l_period_name44 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1076: l_period_name40 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1077: l_period_name41 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1078: l_period_name42 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1079: l_period_name43 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1080: l_period_name44 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1081: l_period_name45 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1082: l_period_name46 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1083: l_period_name47 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1084: l_period_name48 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1081: l_period_name45 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1077: l_period_name41 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1078: l_period_name42 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1079: l_period_name43 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1080: l_period_name44 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1081: l_period_name45 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1082: l_period_name46 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1083: l_period_name47 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1084: l_period_name48 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1085: l_period_name49 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1082: l_period_name46 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1078: l_period_name42 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1079: l_period_name43 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1080: l_period_name44 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1081: l_period_name45 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1082: l_period_name46 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1083: l_period_name47 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1084: l_period_name48 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1085: l_period_name49 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1086: l_period_name50 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1083: l_period_name47 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1079: l_period_name43 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1080: l_period_name44 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1081: l_period_name45 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1082: l_period_name46 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1083: l_period_name47 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1084: l_period_name48 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1085: l_period_name49 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1086: l_period_name50 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1087: l_period_name51 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1084: l_period_name48 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1080: l_period_name44 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1081: l_period_name45 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1082: l_period_name46 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1083: l_period_name47 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1084: l_period_name48 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1085: l_period_name49 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1086: l_period_name50 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1087: l_period_name51 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1088: l_period_name52 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

Line 1085: l_period_name49 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1081: l_period_name45 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1082: l_period_name46 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1083: l_period_name47 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1084: l_period_name48 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1085: l_period_name49 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1086: l_period_name50 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1087: l_period_name51 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1088: l_period_name52 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1089: l_period1_start_date DATE;

Line 1086: l_period_name50 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1082: l_period_name46 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1083: l_period_name47 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1084: l_period_name48 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1085: l_period_name49 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1086: l_period_name50 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1087: l_period_name51 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1088: l_period_name52 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1089: l_period1_start_date DATE;
1090: l_period2_start_date DATE;

Line 1087: l_period_name51 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1083: l_period_name47 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1084: l_period_name48 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1085: l_period_name49 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1086: l_period_name50 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1087: l_period_name51 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1088: l_period_name52 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1089: l_period1_start_date DATE;
1090: l_period2_start_date DATE;
1091: l_period3_start_date DATE;

Line 1088: l_period_name52 PA_BUDGET_LINES.PERIOD_NAME%TYPE;

1084: l_period_name48 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1085: l_period_name49 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1086: l_period_name50 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1087: l_period_name51 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1088: l_period_name52 PA_BUDGET_LINES.PERIOD_NAME%TYPE;
1089: l_period1_start_date DATE;
1090: l_period2_start_date DATE;
1091: l_period3_start_date DATE;
1092: l_period4_start_date DATE;

Line 2543: Pa_Budget_Lines bl WHERE

2539: l_prev_txn_burd_cost,
2540: l_prev_txn_revenue,
2541: l_prev_quantity
2542: FROM
2543: Pa_Budget_Lines bl WHERE
2544: bl.Resource_Assignment_Id = main_cur_rec.resource_assignment_id AND
2545: bl.Txn_Currency_Code = main_cur_rec.source_txn_currency_code AND
2546: bl.bucketing_period_code in ('PE','PD')
2547: AND budget_version_id = p_budget_version_id;

Line 2566: Pa_Budget_Lines bl WHERE

2562: l_prev_proj_raw_cost,
2563: l_prev_proj_burd_cost,
2564: l_prev_proj_revenue
2565: FROM
2566: Pa_Budget_Lines bl WHERE
2567: bl.Resource_Assignment_Id = main_cur_rec.resource_assignment_id AND
2568: bl.bucketing_period_code in ('PE','PD')
2569: AND budget_version_id = p_budget_version_id;
2570:

Line 2583: Pa_Budget_Lines bl WHERE

2579: l_next_txn_burd_cost,
2580: l_next_txn_revenue,
2581: l_next_quantity
2582: FROM
2583: Pa_Budget_Lines bl WHERE
2584: bl.Resource_Assignment_Id = main_cur_rec.resource_assignment_id AND
2585: bl.Txn_Currency_Code = main_cur_rec.source_txn_currency_code AND
2586: bl.bucketing_period_code in ('SE','SD')
2587: AND budget_version_id = p_budget_version_id;

Line 2605: Pa_Budget_Lines bl WHERE

2601: l_next_proj_raw_cost,
2602: l_next_proj_burd_cost,
2603: l_next_proj_revenue
2604: FROM
2605: Pa_Budget_Lines bl WHERE
2606: bl.Resource_Assignment_Id = main_cur_rec.resource_assignment_id AND
2607: bl.bucketing_period_code in ('SE','SD')
2608: AND budget_version_id = p_budget_version_id;
2609: END IF; --For Financial Planning call