APPS.GMS_COST_PLUS_EXTN dependencies on GMS_ADJUSTMENTS_ID_S

Line 1823: select gms_adjustments_id_s.NEXTVAL

1819: x_we_are_done := TRUE ;
1820: END IF ;
1821:
1822: IF x_adjustment_id IS NULL THEN
1823: select gms_adjustments_id_s.NEXTVAL
1824: INTO x_adjustment_id
1825: FROM dual ;
1826: END IF ;
1827:

Line 2069: select gms_adjustments_id_s.NEXTVAL

2065:
2066: IF x_dummy <> 0 THEN
2067:
2068: IF x_adjustment_id IS NULL THEN
2069: select gms_adjustments_id_s.NEXTVAL
2070: INTO x_adjustment_id
2071: FROM dual ;
2072: END IF ;
2073:

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

2228:
2229: x_tot_raw := x_tot_raw + p_amount ;
2230: x_tot_burden:= x_tot_burden + p_burden ;
2231:
2232: select gms_adjustments_id_s.NEXTVAL into l_calc_sequence from dual;
2233:
2234: UPDATE gms_bc_packets
2235: set burdenable_raw_cost = p_burden,
2236: burden_calculation_seq = l_calc_sequence

Line 2840: select gms_adjustments_id_s.NEXTVAL

2836:
2837: x_run_total := x_run_total + x_dummy ;
2838:
2839: IF x_adjustment_id IS NULL THEN
2840: select gms_adjustments_id_s.NEXTVAL
2841: INTO x_adjustment_id
2842: FROM dual ;
2843: END IF ;
2844:

Line 3211: select gms_adjustments_id_s.NEXTVAL

3207:
3208: IF ap_adj_amount <> 0 THEN
3209:
3210: IF x_adjustment_id IS NULL THEN
3211: select gms_adjustments_id_s.NEXTVAL
3212: INTO x_adjustment_id
3213: FROM dual ;
3214: END IF ;
3215: x_line_num := NVL(x_line_num,0) + 1 ;

Line 3319: select gms_adjustments_id_s.NEXTVAL

3315:
3316: IF burden_raw_cost <> 0 THEN
3317:
3318: IF x_adjustment_id IS NULL THEN
3319: select gms_adjustments_id_s.NEXTVAL
3320: INTO x_adjustment_id
3321: FROM dual ;
3322: END IF ;
3323: x_line_num := NVL(x_line_num,0) + 1 ;

Line 3878: select gms_adjustments_id_s.NEXTVAL

3874: gms_error_pkg.gms_debug (g_error_procedure_name||':X_burden_amt_to_update_on_txn:'||X_burden_amt_to_update_on_txn,'C');
3875: END IF;
3876:
3877: -- A.4 Get burden_calculation_seq (adjustment_id) and set values (Common)
3878: select gms_adjustments_id_s.NEXTVAL
3879: INTO x_adjustment_id
3880: FROM dual ;
3881:
3882: x_rec_log.packet_id := p_packet_id ;

Line 4083: select gms_adjustments_id_s.NEXTVAL into l_burden_calc_seq from dual;

4079: -------------------------------------------------------------------- */
4080:
4081: /*bug 11845832 Adding the update statement for burden calculation seq*/
4082:
4083: select gms_adjustments_id_s.NEXTVAL into l_burden_calc_seq from dual;
4084:
4085: UPDATE gms_bc_packets gbc
4086: SET burden_calculation_seq = l_burden_calc_seq
4087: WHERE