APPS.JMF_GTA_SPLIT_TRX_PROC dependencies on JMF_GTA_TRX_LINES_ALL_S

Line 581: JMF_GTA_TRX_LINES_ALL_S.NEXTVAL

577:
578: l_gta_trx_line_new.original_currency_amount := l_quantity_limit * l_GTA_TRX_line_new.unit_price;
579:
580: SELECT
581: JMF_GTA_TRX_LINES_ALL_S.NEXTVAL
582: INTO
583: l_GTA_TRX_line_new.GTA_TRX_LINE_ID
584: FROM
585: dual;

Line 587: --l_GTA_TRX_line_new.GTA_TRX_LINE_ID := JMF_GTA_TRX_LINES_ALL_S.NEXTVAL;

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;
590: -- ELSE l_quantity_limit =0 , then the old line is no change and new line is not needed
591: END IF;/*l_quantity_limit > 0*/

Line 667: JMF_GTA_TRX_LINES_ALL_S.NEXTVAL

663: -- 25-Apr-2006: Jogen Hu bug 5168852
664:
665: l_GTA_TRX_line_new.original_currency_amount := l_quantity_limit * l_GTA_TRX_line_new.unit_price;
666: SELECT
667: JMF_GTA_TRX_LINES_ALL_S.NEXTVAL
668: INTO
669: l_GTA_TRX_line_new.GTA_TRX_LINE_ID
670: FROM
671: dual;

Line 672: --l_GTA_TRX_line_new.GTA_TRX_LINE_ID := 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
676: END IF;/*l_quantity_limit > 0*/

Line 752: JMF_GTA_TRX_LINES_ALL_S.NEXTVAL

748: -- 25-Apr-2006: Jogen Hu bug 5168852
749:
750: l_gta_trx_line_new.original_currency_amount := l_quantity_limit * l_GTA_TRX_line_new.unit_price;
751: SELECT
752: JMF_GTA_TRX_LINES_ALL_S.NEXTVAL
753: INTO
754: l_GTA_TRX_line_new.GTA_TRX_LINE_ID
755: FROM
756: dual;

Line 757: --l_GTA_TRX_line_new.GTA_TRX_LINE_ID := 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
761: END IF;/*l_quantity_limit > 0*/

Line 1083: Jmf_Gta_Trx_Lines_All_s.NEXTVAL

1079: l_index := x_gta_trx_rec.trx_lines.FIRST;
1080: WHILE l_index IS NOT NULL
1081: LOOP
1082: SELECT
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;