APPS.GMS_COST_PLUS_EXTN dependencies on DUAL

Line 1751: from dual ;

1747: decode( p_doc_type, 'REQ', x_rec_award_exp_tot.req_burdenable_cost,
1748: 'PO', x_rec_award_exp_tot.po_burdenable_cost,
1749: 'ENC', x_rec_award_exp_tot.enc_burdenable_cost, 1 )
1750: into x_adj_allowed
1751: from dual ;
1752:
1753: IF g_debug = 'Y' THEN
1754: gms_error_pkg.gms_debug (g_error_procedure_name||':x_adj_allowed:'||x_adj_allowed,'C');
1755: END IF;

Line 1825: FROM dual ;

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:
1828: x_line_num := x_line_num + 1 ;
1829: x_rec_log.adjustment_id := x_adjustment_id ;

Line 2071: FROM dual ;

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:
2074: x_line_num := NVL(x_line_num,0) + 1 ; -- BRC.1
2075: x_rec_log.adjustment_id := x_adjustment_id ;

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 2842: FROM dual ;

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:
2845: x_line_num := x_line_num + 1 ;
2846: x_rec_log.adjustment_id := x_adjustment_id ;

Line 3213: FROM dual ;

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 ;
3216:
3217: x_rec_log.adjustment_id := x_adjustment_id ;

Line 3321: FROM dual ;

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 ;
3324:
3325: x_rec_log.adjustment_id := x_adjustment_id ;

Line 3880: FROM dual ;

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 ;
3883: x_rec_log.award_id := x.award_id;
3884: x_rec_log.expenditure_type := x.expenditure_type ;

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

Line 4196: from dual where exists

4192:
4193: Begin
4194:
4195: Select 1 into l_count
4196: from dual where exists
4197: (select 1 from gms_bc_packets bcp
4198: where bcp.packet_id = p_packet_id
4199: and bcp.award_id = p_award_id
4200: and bcp.expenditure_type = p_expenditure_type

Line 4321: select 'A' into g_actual_flag from dual where exists

4317: If p_mode in ('U','C','E') then
4318: g_actual_flag := 'E';
4319: Elsif p_mode in ('R') then
4320: Begin
4321: select 'A' into g_actual_flag from dual where exists
4322: (select 1 from gms_bc_packets where packet_id = x_packet_id
4323: and document_type = 'EXP');
4324: Exception
4325: When no_data_found then