APPS.AR_GTA_SPLIT_TRX_PROC dependencies on DUAL

Line 789: SELECT ar_gta_trx_lines_all_s.NEXTVAL INTO l_gta_trx_line_new.gta_trx_line_id FROM dual;

785: --l_gta_trx_line_new.original_currency_amount := l_split_currency_amount;
786: l_gta_trx_line_new.original_currency_amount := round(l_split_currency_amount/nvl(l_gta_trx.trx_header.conversion_rate,1), 2);
787: --modified by Jixun for bug#16027677 end
788:
789: SELECT ar_gta_trx_lines_all_s.NEXTVAL INTO l_gta_trx_line_new.gta_trx_line_id FROM dual;
790:
791: -- add new line to VAT invoice
792: l_trx_lines_new.EXTEND;
793: l_trx_lines_new(l_trx_lines_new.COUNT) := l_gta_trx_line_new;

Line 899: dual;

895: AR_GTA_TRX_LINES_ALL_S.NEXTVAL
896: INTO
897: l_GTA_TRX_line_new.GTA_TRX_LINE_ID
898: FROM
899: dual;
900:
901: --l_GTA_TRX_line_new.GTA_TRX_LINE_ID := AR_GTA_TRX_LINES_ALL_S.NEXTVAL;
902: l_trx_lines_new.EXTEND;
903: l_trx_lines_new(l_trx_lines_new.COUNT) := l_GTA_TRX_line_new;

Line 1018: dual;

1014: AR_GTA_TRX_LINES_ALL_S.NEXTVAL
1015: INTO
1016: l_GTA_TRX_line_new.GTA_TRX_LINE_ID
1017: FROM
1018: dual;
1019: --l_GTA_TRX_line_new.GTA_TRX_LINE_ID := AR_GTA_TRX_LINES_ALL_S.NEXTVAL;
1020: l_trx_lines_new.EXTEND;
1021: l_trx_lines_new(l_trx_lines_new.COUNT) := l_GTA_TRX_line_new;
1022: -- ELSE l_quantity_limit =0 , then the old line is no change and new line is not needed

Line 1133: dual;

1129: AR_GTA_TRX_LINES_ALL_S.NEXTVAL
1130: INTO
1131: l_GTA_TRX_line_new.GTA_TRX_LINE_ID
1132: FROM
1133: dual;
1134: --l_GTA_TRX_line_new.GTA_TRX_LINE_ID := AR_GTA_TRX_LINES_ALL_S.NEXTVAL;
1135: l_trx_lines_new.EXTEND;
1136: l_trx_lines_new(l_trx_lines_new.COUNT) := l_GTA_TRX_line_new;
1137: -- ELSE l_quantity_limit =0 , then the old line is no change and new line is not needed

Line 1303: dual;

1299: AR_GTA_TRX_HEADERS_ALL_S.NEXTVAL
1300: INTO
1301: l_GTA_TRX_Header_Rec.gta_trx_header_id
1302: FROM
1303: dual;
1304: --x_GTA_TRX_Header_Rec.gta_trx_header_id := AR_GTA_TRX_HEADERS_ALL_S.NEXTVAL;
1305: -- use this if is due to the trx first split and
1306:
1307: l_GTA_TRX_Header_Rec.group_number := p_GTA_TRX_Header_Rec.group_number + 1;

Line 1472: dual;

1468: AR_Gta_Trx_Lines_All_s.NEXTVAL
1469: INTO
1470: x_gta_trx_rec.trx_lines(l_index).gta_trx_line_id
1471: FROM
1472: dual;
1473: x_gta_trx_rec.trx_lines(l_index).line_number := to_char(l_index);
1474: x_gta_trx_rec.trx_lines(l_index).gta_trx_header_id := x_gta_trx_rec.trx_header.gta_trx_header_id;
1475: l_index := x_gta_trx_rec.trx_lines.NEXT(l_index);
1476: END LOOP;

Line 1625: dual;

1621: , l_amount
1622: , NULL
1623: , l_gta_inv_num
1624: FROM
1625: dual;
1626: ELSIF l_warning_record_count = 1
1627: THEN
1628: UPDATE
1629: ar_gta_transfer_temp temp

Line 2491: dual;

2487: , NULL
2488: , l_error_string
2489: , NULL
2490: FROM
2491: dual;
2492: END;
2493: l_index := p_gta_trx_tbl.NEXT(l_index);
2494: END LOOP;/*l_index IS NOT NULL*/
2495: