DBA Data[Home] [Help]

APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on JMF_GTA_TRX_UTIL

Line 532: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;

528: l_num_of_Invoices NUMBER;
529: l_num_of_lines NUMBER;
530: l_GTA_Invoice_num Jmf_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;
531: l_org_id NUMBER;
532: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
533: l_trx_header_rec JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
534: l_trx_line_rec JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
535: l_trx_line_tbl JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE
536: :=JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();

Line 533: l_trx_header_rec JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;

529: l_num_of_lines NUMBER;
530: l_GTA_Invoice_num Jmf_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;
531: l_org_id NUMBER;
532: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
533: l_trx_header_rec JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
534: l_trx_line_rec JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
535: l_trx_line_tbl JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE
536: :=JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();
537: l_error_msg VARCHAR2(2000);

Line 534: l_trx_line_rec JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;

530: l_GTA_Invoice_num Jmf_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;
531: l_org_id NUMBER;
532: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
533: l_trx_header_rec JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
534: l_trx_line_rec JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
535: l_trx_line_tbl JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE
536: :=JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();
537: l_error_msg VARCHAR2(2000);
538: l_fix_field VARCHAR2(100);

Line 535: l_trx_line_tbl JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE

531: l_org_id NUMBER;
532: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
533: l_trx_header_rec JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
534: l_trx_line_rec JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
535: l_trx_line_tbl JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE
536: :=JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();
537: l_error_msg VARCHAR2(2000);
538: l_fix_field VARCHAR2(100);
539: l_str VARCHAR2(100);

Line 536: :=JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();

532: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
533: l_trx_header_rec JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
534: l_trx_line_rec JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
535: l_trx_line_tbl JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE
536: :=JMF_GTA_TRX_UTIL.TRX_line_Tbl_TYPE();
537: l_error_msg VARCHAR2(2000);
538: l_fix_field VARCHAR2(100);
539: l_str VARCHAR2(100);
540: l_failed BOOLEAN;

Line 1031: jmf_gta_trx_util.create_Trx(P_GTA_Trx => l_trx_rec);

1027: l_trx_rec.trx_lines:=l_trx_line_tbl;
1028:
1029: --insert into GTA table
1030: BEGIN
1031: jmf_gta_trx_util.create_Trx(P_GTA_Trx => l_trx_rec);
1032:
1033: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1034: , SUCCEEDED
1035: , Customer_Name

Line 1250: ,JMF_GTA_TRX_UTIL.To_Xsd_Date_String(Invoice_date)AS "InvoiceDate"

1246: ,Taxpayer_ID AS "TaxpayerID"
1247: ,Invoice_Num AS "InvoiceNum"
1248: --Jogen 20-Sep-2006 bug5521629
1249: --Format date to XSD Date format
1250: ,JMF_GTA_TRX_UTIL.To_Xsd_Date_String(Invoice_date)AS "InvoiceDate"
1251: --,Invoice_date AS "InvoiceDate"
1252: --Jogen 20-Sep-2006 bug5521629
1253: ,Amount AS "Amount"
1254: ,Status AS "Status"

Line 1277: ,JMF_GTA_TRX_UTIL.To_Xsd_Date_String(Invoice_date)AS "InvoiceDate"

1273: ,Taxpayer_ID AS "TaxpayerID"
1274: ,Invoice_Num AS "InvoiceNum"
1275: --Jogen 20-Sep-2006 bug5521629
1276: --Format date to XSD Date format
1277: ,JMF_GTA_TRX_UTIL.To_Xsd_Date_String(Invoice_date)AS "InvoiceDate"
1278: --,Invoice_date AS "InvoiceDate"
1279: --Jogen 20-Sep-2006 bug5521629
1280: ,Amount AS "Amount"
1281: ,FailedReason AS "Reason"

Line 1307: JMF_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);

1303: )
1304: INTO l_report_XML
1305: FROM dual;
1306:
1307: JMF_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);
1308:
1309: clear_imp_temp_table;
1310:
1311: --log for debug

Line 1365: l_invoice JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;

1361: , p_dup_record_tbl IN dup_record_tbl
1362: )
1363: IS
1364: l_procedure_name VARCHAR2(20):='Export_invoice';
1365: l_invoice JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1366: l_TRX_Line_REC JMF_GTA_TRX_UTIL.TRX_LINE_REC_TYPE;
1367: l_lines_num NUMBER:=0;
1368: l_header_output VARCHAR2(1000);
1369:

Line 1366: l_TRX_Line_REC JMF_GTA_TRX_UTIL.TRX_LINE_REC_TYPE;

1362: )
1363: IS
1364: l_procedure_name VARCHAR2(20):='Export_invoice';
1365: l_invoice JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1366: l_TRX_Line_REC JMF_GTA_TRX_UTIL.TRX_LINE_REC_TYPE;
1367: l_lines_num NUMBER:=0;
1368: l_header_output VARCHAR2(1000);
1369:
1370: ln_ta_trx_id NUMBER;

Line 1659: p_GTA_trx_header JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;

1655: lb_num_flag BOOLEAN:=TRUE;
1656:
1657: ln_notification_num NUMBER:=0;
1658:
1659: p_GTA_trx_header JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1660:
1661: lt_dup_record_tbl dup_record_tbl := dup_record_tbl();
1662: --------------------------------------------------------------------------
1663: --add by Lv Xiao on 9-Dec-2008 for bug#7626503, end

Line 3029: ( p_gta_trx_header IN JMF_GTA_TRX_UTIL.TRX_HEADER_REC_TYPE

3025: -- 09/12/2008 Lv Xiao Modified for bug#7626503
3026: -- 26/12/2008 Yao Zhang Modified for bug#7670310
3027: --===========================================================================
3028: FUNCTION Check_Header
3029: ( p_gta_trx_header IN JMF_GTA_TRX_UTIL.TRX_HEADER_REC_TYPE
3030: )
3031: RETURN PLS_INTEGER
3032: IS
3033:

Line 3157: ( p_GTA_trx_line IN JMF_GTA_TRX_UTIL.TRX_LINE_REC_TYPE

3153: -- CHANGE HISTORY:
3154: -- 05/12/05 Jogen Hu Created
3155: --===========================================================================
3156: FUNCTION Check_Line_Length
3157: ( p_GTA_trx_line IN JMF_GTA_TRX_UTIL.TRX_LINE_REC_TYPE
3158: )
3159: RETURN BOOLEAN
3160: IS
3161: l_len_before_dot_qty NUMBER :=0;