APPS.JMF_GTA_SPLIT_TRX_PROC dependencies on DUAL

Line 585: dual;

581: JMF_GTA_TRX_LINES_ALL_S.NEXTVAL
582: INTO
583: l_GTA_TRX_line_new.GTA_TRX_LINE_ID
584: FROM
585: dual;
586:
587: --l_GTA_TRX_line_new.GTA_TRX_LINE_ID := JMF_GTA_TRX_LINES_ALL_S.NEXTVAL;
588: l_trx_lines_new.EXTEND;
589: l_trx_lines_new(l_trx_lines_new.COUNT) := l_GTA_TRX_line_new;

Line 671: dual;

667: JMF_GTA_TRX_LINES_ALL_S.NEXTVAL
668: INTO
669: l_GTA_TRX_line_new.GTA_TRX_LINE_ID
670: FROM
671: dual;
672: --l_GTA_TRX_line_new.GTA_TRX_LINE_ID := JMF_GTA_TRX_LINES_ALL_S.NEXTVAL;
673: l_trx_lines_new.EXTEND;
674: l_trx_lines_new(l_trx_lines_new.COUNT) := l_GTA_TRX_line_new;
675: -- ELSE l_quantity_limit =0 , then the old line is no change and new line is not needed

Line 756: dual;

752: JMF_GTA_TRX_LINES_ALL_S.NEXTVAL
753: INTO
754: l_GTA_TRX_line_new.GTA_TRX_LINE_ID
755: FROM
756: dual;
757: --l_GTA_TRX_line_new.GTA_TRX_LINE_ID := JMF_GTA_TRX_LINES_ALL_S.NEXTVAL;
758: l_trx_lines_new.EXTEND;
759: l_trx_lines_new(l_trx_lines_new.COUNT) := l_GTA_TRX_line_new;
760: -- ELSE l_quantity_limit =0 , then the old line is no change and new line is not needed

Line 918: dual;

914: JMF_GTA_TRX_HEADERS_ALL_S.NEXTVAL
915: INTO
916: l_GTA_TRX_Header_Rec.gta_trx_header_id
917: FROM
918: dual;
919: --x_GTA_TRX_Header_Rec.gta_trx_header_id := JMF_GTA_TRX_HEADERS_ALL_S.NEXTVAL;
920: -- use this if is due to the trx first split and
921:
922: l_GTA_TRX_Header_Rec.group_number := p_GTA_TRX_Header_Rec.group_number + 1;

Line 1087: dual;

1083: Jmf_Gta_Trx_Lines_All_s.NEXTVAL
1084: INTO
1085: x_gta_trx_rec.trx_lines(l_index).gta_trx_line_id
1086: FROM
1087: dual;
1088: x_gta_trx_rec.trx_lines(l_index).line_number := to_char(l_index);
1089: x_gta_trx_rec.trx_lines(l_index).gta_trx_header_id := x_gta_trx_rec.trx_header.gta_trx_header_id;
1090: l_index := x_gta_trx_rec.trx_lines.NEXT(l_index);
1091: END LOOP;

Line 1239: dual;

1235: , l_amount
1236: , NULL
1237: , l_gta_inv_num
1238: FROM
1239: dual;
1240: ELSIF l_warning_record_count = 1
1241: THEN
1242: UPDATE
1243: jmf_gta_transfer_temp temp

Line 2079: dual;

2075: , NULL
2076: , l_error_string
2077: , NULL
2078: FROM
2079: dual;
2080: END;
2081: l_index := p_gta_trx_tbl.NEXT(l_index);
2082: END LOOP;/*l_index IS NOT NULL*/
2083: