[Home] [Help]
1659: IF P_DEBUG_MODE THEN
1660: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1150:Get Expenditure Id from sequence');
1661: END IF;
1662: select pa_expenditures_s.nextval
1663: into exp_id from dual;
1664: stage := 170; -- Creating burden expenditure
1665:
1666: l_curr_expenditure_id := exp_id ; -- Bug 3551106
1667:
1782: IF P_DEBUG_MODE THEN
1783: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '1400:Get Expenditure Item Id from Sequence');
1784: END IF;
1785: select pa_expenditure_items_s.nextval
1786: into exp_item_id from dual;
1787: i := i +1;
1788:
1789:
1790:
2337: IF P_DEBUG_MODE THEN
2338: pa_cc_utils.log_message('create_burden_expenditure_item: ' || '2100:Process Last set .. Get Exp item id from sequence');
2339: END IF;
2340: select pa_expenditure_items_s.nextval
2341: into exp_item_id from dual;
2342:
2343: /* Moved the derivation of work type id to here for bug 2607781 as it needs to be passed to pa_transactions_pub.validate_transaction */
2344: IF ( NVL(pa_utils4.is_exp_work_type_enabled, 'N') = 'Y' )
2345: THEN
2883: else
2884:
2885: select pa_burden_sum_run_s.nextval
2886: into current_run_id
2887: from dual;
2888: /*
2889: * Bug 2838499: commented this stray sql. (nothing related to the bug.)
2890: * select set_of_books_id
2891: * into sob_id
3005:
3006: begin
3007: select pa_commitment_txns_s.nextval
3008: into l_cmt_line_id
3009: from dual;
3010:
3011: -- Getting expenditure_item_date as the end_date for that pa period
3012: stage := 235; -- Getting expenditure_item_date
3013: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);
3201: if l_denom_burdened_cost <> 0 then
3202: begin
3203: select pa_commitment_txns_s.nextval
3204: into l_cmt_line_id
3205: from dual;
3206:
3207: -- Getting expenditure_item_date as the end_date for that pa period
3208: stage := 245; -- Getting expenditure_item_date
3209: l_pa_end_date := pa_utils.get_pa_end_date(prev_bcc_rec.dest_pa_period);