APPS.JMF_GTA_ARTRX_PROC dependencies on JMF_GTA_TRANSFER_TEMP

Line 433: jmf_gta_transfer_temp

429: IS
430: SELECT
431: transaction_id
432: FROM
433: jmf_gta_transfer_temp
434: WHERE SUCCEEDED='Y';
435:
436: -- for add the gta inv number
437: CURSOR get_gta_inv_number_c(p_ra_trx_id IN NUMBER)

Line 501: FROM JMF_gta_transfer_temp

497:
498: -- sum the count of successed , failed and warning trx
499: SELECT COUNT(*), SUM(nvl(amount, 0))
500: INTO l_succ_rows, l_succ_amount
501: FROM JMF_gta_transfer_temp
502: WHERE SUCCEEDED = 'Y';
503:
504: --12/04/2006 Jogen Hu bug 5144561
505: /*

Line 545: jmf_gta_transfer_temp

541: CLOSE get_gta_inv_number_c;--jogen Hu Apr-4, 2006 bug 5135169
542:
543: BEGIN
544: UPDATE
545: jmf_gta_transfer_temp
546: SET
547: gta_invoice_num = l_gta_inv_num_all
548: WHERE
549: transaction_id = l_transaction_id;

Line 574: FROM JMF_gta_transfer_temp

570: --end insert the gta invoice number into temp
571:
572: SELECT COUNT(*), SUM(nvl(amount, 0))
573: INTO l_failed_rows, l_failed_amount
574: FROM JMF_gta_transfer_temp
575: WHERE SUCCEEDED = 'N';
576:
577: SELECT COUNT(*), SUM(nvl(amount, 0))
578: INTO l_warning_rows, l_warning_amount

Line 579: FROM jmf_gta_transfer_temp

575: WHERE SUCCEEDED = 'N';
576:
577: SELECT COUNT(*), SUM(nvl(amount, 0))
578: INTO l_warning_rows, l_warning_amount
579: FROM jmf_gta_transfer_temp
580: WHERE SUCCEEDED = 'W';
581:
582: SELECT COUNT(*)
583: INTO l_GTA_rows

Line 584: FROM jmf_gta_transfer_temp

580: WHERE SUCCEEDED = 'W';
581:
582: SELECT COUNT(*)
583: INTO l_GTA_rows
584: FROM jmf_gta_transfer_temp
585: WHERE SUCCEEDED = 'W'
586: OR SUCCEEDED = 'Y';
587:
588: -- generate validate xml string

Line 643: FROM JMF_gta_transfer_temp

639: Amount AS "Amount",
640: FailedReason AS
641: "FailedReason"))))
642: INTO l_failed
643: FROM JMF_gta_transfer_temp
644: WHERE SUCCEEDED = 'N';
645:
646: -- generate the xmltype for warning inv
647: SELECT XMLElement("Invoices",

Line 660: FROM JMF_gta_transfer_temp

656: Amount AS "Amount",
657: FailedReason AS
658: "WarningReason"))))
659: INTO l_warning
660: FROM JMF_gta_transfer_temp
661: WHERE SUCCEEDED = 'W';
662:
663: --generate the xmltype for succ inv
664: SELECT XMLElement("Invoices",

Line 681: FROM JMF_gta_transfer_temp

677: "GTAInvoiceNum"
678: --12/04/2006 Jogen Hu bug 5144561
679: ))))
680: INTO l_succeeded
681: FROM JMF_gta_transfer_temp
682: WHERE SUCCEEDED = 'Y';
683:
684: --generate the final report
685: SELECT xmlelement("TransferReport",

Line 2973: from jmf_gta_transfer_temp temp

2969: l_error_string);
2970: END IF;
2971:
2972: delete
2973: from jmf_gta_transfer_temp temp
2974: WHERE temp.transaction_id = l_customer_trx_id
2975: AND temp.succeeded = 'W'
2976: and temp.tax_reg_num=l_tp_registration_number;--Modified by Yao Zhang for bug 7684662
2977:

Line 2980: INSERT INTO jmf_gta_transfer_temp t

2976: and temp.tax_reg_num=l_tp_registration_number;--Modified by Yao Zhang for bug 7684662
2977:
2978:
2979:
2980: INSERT INTO jmf_gta_transfer_temp t
2981: (t.seq,
2982: t.transaction_id,
2983: t.succeeded,
2984: t.transaction_num,

Line 2991: SELECT jmf_gta_transfer_temp_s.NEXTVAL,

2987: t.amount,
2988: t.failedreason,
2989: t.gta_invoice_num,
2990: t.tax_reg_num)
2991: SELECT jmf_gta_transfer_temp_s.NEXTVAL,
2992: l_customer_trx_id,
2993: 'W',
2994: l_trx_number,
2995: l_ctt_class,

Line 3820: --delete warning data from jmf_gta_transfer_temp

3816: */
3817: --Jogen Hu 2006.2.17
3818: EXCEPTION
3819: WHEN l_normal_exception THEN
3820: --delete warning data from jmf_gta_transfer_temp
3821: DELETE jmf_gta_transfer_temp temp
3822: WHERE temp.transaction_id = l_customer_trx_id
3823: AND temp.succeeded = 'W';
3824:

Line 3821: DELETE jmf_gta_transfer_temp temp

3817: --Jogen Hu 2006.2.17
3818: EXCEPTION
3819: WHEN l_normal_exception THEN
3820: --delete warning data from jmf_gta_transfer_temp
3821: DELETE jmf_gta_transfer_temp temp
3822: WHERE temp.transaction_id = l_customer_trx_id
3823: AND temp.succeeded = 'W';
3824:
3825: INSERT INTO jmf_gta_transfer_temp t

Line 3825: INSERT INTO jmf_gta_transfer_temp t

3821: DELETE jmf_gta_transfer_temp temp
3822: WHERE temp.transaction_id = l_customer_trx_id
3823: AND temp.succeeded = 'W';
3824:
3825: INSERT INTO jmf_gta_transfer_temp t
3826: (t.seq,
3827: t.transaction_id,
3828: t.succeeded,
3829: t.transaction_num,

Line 3835: SELECT jmf_gta_transfer_temp_s.NEXTVAL,

3831: t.customer_name,
3832: t.amount,
3833: t.failedreason,
3834: t.gta_invoice_num)
3835: SELECT jmf_gta_transfer_temp_s.NEXTVAL,
3836: l_customer_trx_id,
3837: 'N',
3838: l_trx_number,
3839: l_ctt_class,