APPS.GMS_COST_PLUS_EXTN dependencies on GMS_ADJUSTMENTS_ID_S

Line 1556: select gms_adjustments_id_s.NEXTVAL

1552: x_we_are_done := TRUE ;
1553: END IF ;
1554:
1555: IF x_adjustment_id IS NULL THEN
1556: select gms_adjustments_id_s.NEXTVAL
1557: INTO x_adjustment_id
1558: FROM dual ;
1559: END IF ;
1560:

Line 1802: select gms_adjustments_id_s.NEXTVAL

1798:
1799: IF x_dummy <> 0 THEN
1800:
1801: IF x_adjustment_id IS NULL THEN
1802: select gms_adjustments_id_s.NEXTVAL
1803: INTO x_adjustment_id
1804: FROM dual ;
1805: END IF ;
1806:

Line 1965: select gms_adjustments_id_s.NEXTVAL into l_calc_sequence from dual;

1961:
1962: x_tot_raw := x_tot_raw + p_amount ;
1963: x_tot_burden:= x_tot_burden + p_burden ;
1964:
1965: select gms_adjustments_id_s.NEXTVAL into l_calc_sequence from dual;
1966:
1967: UPDATE gms_bc_packets
1968: set burdenable_raw_cost = p_burden,
1969: burden_calculation_seq = l_calc_sequence

Line 2540: select gms_adjustments_id_s.NEXTVAL

2536:
2537: x_run_total := x_run_total + x_dummy ;
2538:
2539: IF x_adjustment_id IS NULL THEN
2540: select gms_adjustments_id_s.NEXTVAL
2541: INTO x_adjustment_id
2542: FROM dual ;
2543: END IF ;
2544:

Line 2847: select gms_adjustments_id_s.NEXTVAL

2843:
2844: IF ap_adj_amount <> 0 THEN
2845:
2846: IF x_adjustment_id IS NULL THEN
2847: select gms_adjustments_id_s.NEXTVAL
2848: INTO x_adjustment_id
2849: FROM dual ;
2850: END IF ;
2851: x_line_num := NVL(x_line_num,0) + 1 ;

Line 2955: select gms_adjustments_id_s.NEXTVAL

2951:
2952: IF burden_raw_cost <> 0 THEN
2953:
2954: IF x_adjustment_id IS NULL THEN
2955: select gms_adjustments_id_s.NEXTVAL
2956: INTO x_adjustment_id
2957: FROM dual ;
2958: END IF ;
2959: x_line_num := NVL(x_line_num,0) + 1 ;

Line 3514: select gms_adjustments_id_s.NEXTVAL

3510: gms_error_pkg.gms_debug (g_error_procedure_name||':X_burden_amt_to_update_on_txn:'||X_burden_amt_to_update_on_txn,'C');
3511: END IF;
3512:
3513: -- A.4 Get burden_calculation_seq (adjustment_id) and set values (Common)
3514: select gms_adjustments_id_s.NEXTVAL
3515: INTO x_adjustment_id
3516: FROM dual ;
3517:
3518: x_rec_log.packet_id := p_packet_id ;