[Home] [Help]
1523: IF P_DEBUG_MODE THEN
1524: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1150:Get Expenditure Id from sequence');
1525: END IF;
1526: select pa_expenditures_s.nextval
1527: into exp_id from dual;
1528: stage := 170; -- Creating burden expenditure
1529:
1530: l_curr_expenditure_id := exp_id ; -- Bug 3551106
1531:
1643: IF P_DEBUG_MODE THEN
1644: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1400:Get Expenditure Item Id from Sequence');
1645: END IF;
1646: select pa_expenditure_items_s.nextval
1647: into exp_item_id from dual;
1648: i := i +1;
1649:
1650:
1651:
2195: IF P_DEBUG_MODE THEN
2196: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2100:Process Last set .. Get Exp item id from sequence');
2197: END IF;
2198: select pa_expenditure_items_s.nextval
2199: into exp_item_id from dual;
2200:
2201: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
2202: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2203: THEN
2739: else
2740:
2741: select pa_burden_sum_run_s.nextval
2742: into current_run_id
2743: from dual;
2744: /*
2745: * Bug 2838499: commented this stray sql. (nothing related to the bug.)
2746: * select set_of_books_id
2747: * into sob_id
2861:
2862: begin
2863: select pa_commitment_txns_s.nextval
2864: into l_cmt_line_id
2865: from dual;
2866:
2867: -- Getting expenditure_item_date as the end_date for that pa period
2868: stage := 235; -- Getting expenditure_item_date
2869: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);
3057: if l_denom_burdened_cost <> 0 then
3058: begin
3059: select pa_commitment_txns_s.nextval
3060: into l_cmt_line_id
3061: from dual;
3062:
3063: -- Getting expenditure_item_date as the end_date for that pa period
3064: stage := 245; -- Getting expenditure_item_date
3065: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);