APPS.JMF_GTA_TRX_UTIL dependencies on JMF_GTA_TRX_LINES_ALL

Line 439: -- AND JMF_GTA_TRX_LINES_ALL.

435: --
436: -- DESCRIPTION:
437: --
438: -- This package can insert a set of trx to JMF_GTA_TRX_HEADS_ALL
439: -- AND JMF_GTA_TRX_LINES_ALL.
440: --
441: -- PARAMETERS:
442: -- In: p_gta_trxs trx_tbl_type
443: --

Line 642: jmf_gta_trx_lines_all_pkg.insert_row

638: log( 'begin create_trx_line '||p_gta_trx.trx_lines(l_count).ar_trx_line_id);
639: END IF;
640: -- end log
641:
642: jmf_gta_trx_lines_all_pkg.insert_row
643: (p_rowid => line_row_id
644: ,p_org_id => p_gta_trx.trx_lines(l_count).org_id
645: ,p_gta_trx_header_id => p_gta_trx.trx_lines(l_count).gta_trx_header_id
646: ,p_gta_trx_line_id => p_gta_trx.trx_lines(l_count).gta_trx_line_id

Line 771: jmf_gta_trx_lines_all

767: SUM(nvl(amount,0))
768: INTO
769: l_ret
770: FROM
771: jmf_gta_trx_lines_all
772: WHERE gta_trx_header_id = p_header_id
773: AND enabled_flag = 'Y';
774:
775: RETURN l_ret;

Line 810: jmf_gta_trx_lines_all

806: CURSOR c_original_amount IS
807: SELECT
808: SUM(nvl(original_currency_amount,0))
809: FROM
810: jmf_gta_trx_lines_all
811: WHERE gta_trx_header_id = p_header_id
812: AND enabled_flag = 'Y';
813: BEGIN
814: OPEN c_original_amount;

Line 849: DELETE jmf_gta_trx_lines_all

845: (p_gta_trx_header_id IN NUMBER)
846: IS
847: BEGIN
848: --Delete lines
849: DELETE jmf_gta_trx_lines_all
850: WHERE gta_trx_header_id = p_gta_trx_header_id;
851:
852: --Delete Headers
853: DELETE jmf_gta_trx_headers_all