eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_GTA_ARTRX_PROC dependencies on JMF_GTA_TRX_UTIL

Line 113: --| _From_Ebtax of package JMF_GTA_TRX_UTIL, and

109: --| .set_token('NUM', l_customer_trx_line_id)"
110: --| for bug 5258522
111: --| 29/06/2006 Shujuan Yan Modify Retrieve_AR_TRXs, get l_
112: --| tax_curr_unit_price from procedure Get_Info
113: --| _From_Ebtax of package JMF_GTA_TRX_UTIL, and
114: --| compare it with max amount for bug 5168900.
115: --| 12/07/2006 Shujuan Yan Added l_trx_line.item_description
116: --| := l_description when l_item_inventry_id is
117: --| null in the procedure Retrieve_AR_TRXs

Line 202: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type

198: --
199: -- PARAMETERS:
200: -- In: P_ORG_ID NUMBER
201: -- P_transfer_rule NUMBER
202: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type
203: -- p_DEBUG VARCHAR2
204: -- OUT: errbuf varchar2
205: -- retcode VARCHAR2
206:

Line 217: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type) IS

213: PROCEDURE Transfer_AR_To_GTA(errbuf OUT NOCOPY VARCHAR2,
214: retcode OUT NOCOPY VARCHAR2,
215: p_org_id IN NUMBER,
216: p_transfer_id IN NUMBER,
217: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type) IS
218: l_procedure_name VARCHAR2(30) := 'transfer_AR_to_GTA';
219: l_gta_trx_tbl_4ar jmf_gta_trx_util.trx_tbl_type := jmf_gta_trx_util.trx_tbl_type();
220: l_gta_trx_tbl_4gta jmf_gta_trx_util.trx_tbl_type := jmf_gta_trx_util.trx_tbl_type();
221: BEGIN

Line 219: l_gta_trx_tbl_4ar jmf_gta_trx_util.trx_tbl_type := jmf_gta_trx_util.trx_tbl_type();

215: p_org_id IN NUMBER,
216: p_transfer_id IN NUMBER,
217: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type) IS
218: l_procedure_name VARCHAR2(30) := 'transfer_AR_to_GTA';
219: l_gta_trx_tbl_4ar jmf_gta_trx_util.trx_tbl_type := jmf_gta_trx_util.trx_tbl_type();
220: l_gta_trx_tbl_4gta jmf_gta_trx_util.trx_tbl_type := jmf_gta_trx_util.trx_tbl_type();
221: BEGIN
222: FND_LOG.G_CURRENT_RUNTIME_LEVEL := FND_LOG.LEVEL_STATEMENT;
223:

Line 220: l_gta_trx_tbl_4gta jmf_gta_trx_util.trx_tbl_type := jmf_gta_trx_util.trx_tbl_type();

216: p_transfer_id IN NUMBER,
217: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type) IS
218: l_procedure_name VARCHAR2(30) := 'transfer_AR_to_GTA';
219: l_gta_trx_tbl_4ar jmf_gta_trx_util.trx_tbl_type := jmf_gta_trx_util.trx_tbl_type();
220: l_gta_trx_tbl_4gta jmf_gta_trx_util.trx_tbl_type := jmf_gta_trx_util.trx_tbl_type();
221: BEGIN
222: FND_LOG.G_CURRENT_RUNTIME_LEVEL := FND_LOG.LEVEL_STATEMENT;
223:
224: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 254: jmf_gta_trx_util.create_TRXs(p_gta_trxs => l_gta_trx_tbl_4gta);

250: G_MODULE_PREFIX || l_procedure_name,
251: 'End Split_transactions......' || l_gta_trx_tbl_4gta.COUNT);
252: END IF;
253:
254: jmf_gta_trx_util.create_TRXs(p_gta_trxs => l_gta_trx_tbl_4gta);
255:
256: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
257: log(FND_LOG.LEVEL_PROCEDURE,
258: G_MODULE_PREFIX || l_procedure_name,

Line 345: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type

341: --
342: -- PARAMETERS:
343: -- In: P_ORG_ID NUMBER
344: -- p_transfer_id NUMBER
345: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type
346: --
347: -- DESIGN REFERENCES:
348: -- GTA-TRANSFER-PROGRAM-TD.doc
349: --

Line 357: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type) IS

353: --===========================================================================
354:
355: PROCEDURE Generate_XML_Output(p_org_id IN NUMBER,
356: p_transfer_id IN NUMBER,
357: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type) IS
358: l_currency VARCHAR2(30);
359: l_reportFailed xmltype;
360: l_FailedWithParameters xmltype;
361: l_parameter XMLType;

Line 399: l_gl_date_from VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.GL_DATE_FROM),

395: ' ');
396: l_gl_period VARCHAR2(100) := nvl(p_conc_parameters.GL_PERIOD,
397: ' ');
398: --l_gl_date_from VARCHAR2(20) := nvl(to_char(p_conc_parameters.GL_DATE_FROM), ' ');
399: l_gl_date_from VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.GL_DATE_FROM),
400: ' ');
401: --l_gl_date_to VARCHAR2(20) := nvl(to_char(p_conc_parameters.GL_DATE_TO), ' ');
402: l_gl_date_to VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.GL_DATE_TO),
403: ' ');

Line 402: l_gl_date_to VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.GL_DATE_TO),

398: --l_gl_date_from VARCHAR2(20) := nvl(to_char(p_conc_parameters.GL_DATE_FROM), ' ');
399: l_gl_date_from VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.GL_DATE_FROM),
400: ' ');
401: --l_gl_date_to VARCHAR2(20) := nvl(to_char(p_conc_parameters.GL_DATE_TO), ' ');
402: l_gl_date_to VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.GL_DATE_TO),
403: ' ');
404: l_trx_batch_from VARCHAR2(50) := nvl(p_conc_parameters.TRX_BATCH_FROM,
405: ' ');
406: l_trx_batch_to VARCHAR2(50) := nvl(p_conc_parameters.TRX_BATCH_TO,

Line 413: l_trx_date_from VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.TRX_DATE_FROM),

409: ' ');
410: l_trx_number_to VARCHAR2(20) := nvl(p_conc_parameters.TRX_NUMBER_TO,
411: ' ');
412: --l_trx_date_from VARCHAR2(20) := nvl(to_char(p_conc_parameters.TRX_DATE_FROM), ' ');
413: l_trx_date_from VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.TRX_DATE_FROM),
414: ' ');
415: --l_trx_date_to VARCHAR2(20) := nvl(to_char(p_conc_parameters.TRX_DATE_TO), ' ');
416: l_trx_date_to VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.TRX_DATE_TO),
417: ' ');

Line 416: l_trx_date_to VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.TRX_DATE_TO),

412: --l_trx_date_from VARCHAR2(20) := nvl(to_char(p_conc_parameters.TRX_DATE_FROM), ' ');
413: l_trx_date_from VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.TRX_DATE_FROM),
414: ' ');
415: --l_trx_date_to VARCHAR2(20) := nvl(to_char(p_conc_parameters.TRX_DATE_TO), ' ');
416: l_trx_date_to VARCHAR2(20) := nvl(JMF_GTA_TRX_UTIL.To_Xsd_Date_String(p_conc_parameters.TRX_DATE_TO),
417: ' ');
418: l_doc_num_from VARCHAR2(30) := nvl(to_char(p_conc_parameters.DOC_NUM_FROM),
419: ' ');
420: l_doc_num_to VARCHAR2(30) := nvl(to_char(p_conc_parameters.DOC_NUM_TO),

Line 689: JMF_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE) AS

685: SELECT xmlelement("TransferReport",
686: xmlforest(l_reportFailed AS "ReportFailed",
687: l_FailedWithParameters AS
688: "FailedWithParameters",
689: JMF_GTA_TRX_UTIL.To_Xsd_Date_String(SYSDATE) AS
690: "ReqDate"
691: --, to_char(SYSDATE, l_date_format) AS "ReqDate"
692: ,
693: l_currency AS "CurrencyCode",

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

699: INTO l_report_XML
700: FROM dual;
701:
702: -- concurrent output
703: JMF_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);
704:
705: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
706: JMF_GTA_TRX_UTIL.debug_output_conc(l_report_XML.Getclobval);
707: END IF;

Line 706: JMF_GTA_TRX_UTIL.debug_output_conc(l_report_XML.Getclobval);

702: -- concurrent output
703: JMF_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);
704:
705: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
706: JMF_GTA_TRX_UTIL.debug_output_conc(l_report_XML.Getclobval);
707: END IF;
708:
709: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: fnd_log.String(fnd_log.LEVEL_PROCEDURE,

Line 737: -- p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type

733: --
734: -- PARAMETERS:
735: -- p_org_id IN NUMBER
736: -- p_transfer_id IN NUMBER
737: -- p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type
738: -- x_GTA_TRX_Tbl OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE
739: --
740: -- DESIGN REFERENCES:
741: -- GTA-TRANSFER-PROGRAM-TD.doc

Line 738: -- x_GTA_TRX_Tbl OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE

734: -- PARAMETERS:
735: -- p_org_id IN NUMBER
736: -- p_transfer_id IN NUMBER
737: -- p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type
738: -- x_GTA_TRX_Tbl OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE
739: --
740: -- DESIGN REFERENCES:
741: -- GTA-TRANSFER-PROGRAM-TD.doc
742: --

Line 750: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,

746: -- 23-01-2008 Yao Zhang Changed for bug 7758496
747: --===========================================================================
748: PROCEDURE Retrive_Valid_AR_TRXs(p_org_id IN NUMBER,
749: p_transfer_id IN NUMBER,
750: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,
751: x_GTA_TRX_Tbl OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE) IS
752: l_sql_exec VARCHAR2(4000);
753: l_procedure_name VARCHAR2(30) := 'retrive_valid_AR_TRXs';
754: l_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();

Line 751: x_GTA_TRX_Tbl OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE) IS

747: --===========================================================================
748: PROCEDURE Retrive_Valid_AR_TRXs(p_org_id IN NUMBER,
749: p_transfer_id IN NUMBER,
750: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,
751: x_GTA_TRX_Tbl OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE) IS
752: l_sql_exec VARCHAR2(4000);
753: l_procedure_name VARCHAR2(30) := 'retrive_valid_AR_TRXs';
754: l_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
755: l_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();

Line 754: l_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();

750: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,
751: x_GTA_TRX_Tbl OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE) IS
752: l_sql_exec VARCHAR2(4000);
753: l_procedure_name VARCHAR2(30) := 'retrive_valid_AR_TRXs';
754: l_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
755: l_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
756: l_other_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
757: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
758: l_gta_trx_tbl jmf_gta_trx_util.trx_tbl_type:= jmf_gta_trx_util.trx_tbl_type();

Line 755: l_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();

751: x_GTA_TRX_Tbl OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE) IS
752: l_sql_exec VARCHAR2(4000);
753: l_procedure_name VARCHAR2(30) := 'retrive_valid_AR_TRXs';
754: l_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
755: l_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
756: l_other_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
757: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
758: l_gta_trx_tbl jmf_gta_trx_util.trx_tbl_type:= jmf_gta_trx_util.trx_tbl_type();
759: l_invoice_type_code VARCHAR2(1);

Line 756: l_other_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();

752: l_sql_exec VARCHAR2(4000);
753: l_procedure_name VARCHAR2(30) := 'retrive_valid_AR_TRXs';
754: l_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
755: l_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
756: l_other_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
757: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
758: l_gta_trx_tbl jmf_gta_trx_util.trx_tbl_type:= jmf_gta_trx_util.trx_tbl_type();
759: l_invoice_type_code VARCHAR2(1);
760: BEGIN

Line 758: l_gta_trx_tbl jmf_gta_trx_util.trx_tbl_type:= jmf_gta_trx_util.trx_tbl_type();

754: l_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
755: l_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
756: l_other_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
757: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
758: l_gta_trx_tbl jmf_gta_trx_util.trx_tbl_type:= jmf_gta_trx_util.trx_tbl_type();
759: l_invoice_type_code VARCHAR2(1);
760: BEGIN
761:
762: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 852: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type

848: --
849: -- PARAMETERS:
850: -- In: P_ORG_ID NUMBER
851: -- p_transfer_id VARCHAR2
852: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type
853: -- OUT: x_query_sql VARCHAR2
854: -- x_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
855: -- x_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
856: -- x_other_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type

Line 854: -- x_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type

850: -- In: P_ORG_ID NUMBER
851: -- p_transfer_id VARCHAR2
852: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type
853: -- OUT: x_query_sql VARCHAR2
854: -- x_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
855: -- x_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
856: -- x_other_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
857: -- x_currency_code VARCHAR2
858:

Line 855: -- x_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type

851: -- p_transfer_id VARCHAR2
852: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type
853: -- OUT: x_query_sql VARCHAR2
854: -- x_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
855: -- x_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
856: -- x_other_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
857: -- x_currency_code VARCHAR2
858:
859: -- DESIGN REFERENCES:

Line 856: -- x_other_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type

852: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type
853: -- OUT: x_query_sql VARCHAR2
854: -- x_trxtype_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
855: -- x_flex_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
856: -- x_other_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
857: -- x_currency_code VARCHAR2
858:
859: -- DESIGN REFERENCES:
860: -- GTA-TRANSFER-PROGRAM-TD.doc

Line 871: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,

867: -- to support new tax regulation change in R12.1
868: --===========================================================================
869: PROCEDURE Get_AR_SQL(P_ORG_ID IN NUMBER,
870: p_transfer_id IN NUMBER,
871: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,
872: x_query_sql OUT NOCOPY VARCHAR2,
873: x_trxtype_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
874: x_flex_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
875: x_other_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,

Line 873: x_trxtype_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,

869: PROCEDURE Get_AR_SQL(P_ORG_ID IN NUMBER,
870: p_transfer_id IN NUMBER,
871: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,
872: x_query_sql OUT NOCOPY VARCHAR2,
873: x_trxtype_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
874: x_flex_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
875: x_other_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
876: x_currency_code OUT NOCOPY VARCHAR2) IS
877: l_select_sql VARCHAR2(4000);

Line 874: x_flex_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,

870: p_transfer_id IN NUMBER,
871: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,
872: x_query_sql OUT NOCOPY VARCHAR2,
873: x_trxtype_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
874: x_flex_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
875: x_other_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
876: x_currency_code OUT NOCOPY VARCHAR2) IS
877: l_select_sql VARCHAR2(4000);
878:

Line 875: x_other_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,

871: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,
872: x_query_sql OUT NOCOPY VARCHAR2,
873: x_trxtype_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
874: x_flex_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
875: x_other_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
876: x_currency_code OUT NOCOPY VARCHAR2) IS
877: l_select_sql VARCHAR2(4000);
878:
879: l_TRX_TYPE_condition VARCHAR2(2000);

Line 1245: -- x_query_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type

1241: -- In: P_ORG_ID NUMBER
1242: -- p_transfer_id VARCHAR2
1243:
1244: -- OUT: x_condition_sql Varchar2
1245: -- x_query_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1246:
1247: -- DESIGN REFERENCES:
1248: -- GTA-TRANSFER-PROGRAM-TD.doc
1249: --

Line 1256: x_query_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type) IS

1252: --===========================================================================
1253: PROCEDURE Get_AR_TrxType_Cond(p_ORG_ID IN NUMBER,
1254: p_transfer_id IN NUMBER,
1255: x_condition_sql OUT NOCOPY VARCHAR2,
1256: x_query_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type) IS
1257: l_procedure_name VARCHAR2(50) := 'Get_AR_TrxType_Cond';
1258: l_parameter_prefix VARCHAR2(10) := ':trxtype';
1259: l_parameter_suffix NUMBER;
1260: l_include_flag VARCHAR2(5);

Line 1290: x_query_parameter := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();

1286: 'Begin Get_AR_TrxType_Cond......');
1287: END IF;
1288:
1289: -- init the sql string and parameter table.
1290: x_query_parameter := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
1291: l_parameter_suffix := 0;
1292:
1293: -- Generate the dynamic sql which condition_rule is 'I'
1294: OPEN trx_type_cond_i;

Line 1381: -- x_query_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type

1377: -- In: P_ORG_ID NUMBER
1378: -- p_transfer_id VARCHAR2
1379:
1380: -- OUT: x_condition_sql Varchar2
1381: -- x_query_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1382:
1383: -- DESIGN REFERENCES:
1384: -- GTA-TRANSFER-PROGRAM-TD.doc
1385: --

Line 1392: x_query_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type) IS

1388: --===========================================================================
1389: PROCEDURE Get_AR_FLEX_COND(P_ORG_ID IN NUMBER,
1390: p_transfer_id IN NUMBER,
1391: x_condition_sql OUT NOCOPY VARCHAR2,
1392: x_query_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type) IS
1393: l_procedure_name VARCHAR2(50) := 'Get_AR_FLEX_COND';
1394: l_parameter_prefix VARCHAR2(10) := ':flex';
1395: l_parameter_suffix NUMBER;
1396:

Line 1430: x_query_parameter := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();

1426: G_MODULE_PREFIX || l_procedure_name,
1427: 'begin get_ar_flex......');
1428: END IF;
1429:
1430: x_query_parameter := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
1431: l_parameter_suffix := 0;
1432:
1433: -- Generate the dynamic sql for flex filed which the condition rule is 'I'
1434: OPEN flex_cond_i;

Line 1537: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type

1533: --
1534: -- PARAMETERS:
1535: -- In: P_ORG_ID NUMBER
1536: -- p_transfer_id VARCHAR2
1537: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type
1538:
1539: -- OUT: x_condition_sql Varchar2
1540: -- x_query_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1541:

Line 1540: -- x_query_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type

1536: -- p_transfer_id VARCHAR2
1537: -- p_conc_parameters JMF_GTA_TRX_UTIL.transferParas_rec_type
1538:
1539: -- OUT: x_condition_sql Varchar2
1540: -- x_query_parameter JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1541:
1542: -- DESIGN REFERENCES:
1543: -- GTA-TRANSFER-PROGRAM-TD.doc
1544: --

Line 1551: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,

1547: --
1548: --===========================================================================
1549: PROCEDURE Get_Param_Cond(P_ORG_ID IN NUMBER,
1550: p_transfer_id IN NUMBER,
1551: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,
1552: x_condition_sql OUT NOCOPY VARCHAR2,
1553: x_query_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type) IS
1554: l_procedure_name VARCHAR2(30) := 'Get_Param_Cond';
1555: l_parameter_prefix VARCHAR2(10) := ':para';

Line 1553: x_query_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type) IS

1549: PROCEDURE Get_Param_Cond(P_ORG_ID IN NUMBER,
1550: p_transfer_id IN NUMBER,
1551: p_conc_parameters IN JMF_GTA_TRX_UTIL.transferParas_rec_type,
1552: x_condition_sql OUT NOCOPY VARCHAR2,
1553: x_query_parameter OUT NOCOPY JMF_GTA_TRX_UTIL.Condition_para_tbl_type) IS
1554: l_procedure_name VARCHAR2(30) := 'Get_Param_Cond';
1555: l_parameter_prefix VARCHAR2(10) := ':para';
1556: l_parameter_suffix NUMBER;
1557:

Line 1574: x_query_parameter := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();

1570: END IF;
1571:
1572: -- init
1573: x_condition_sql := '';
1574: x_query_parameter := JMF_GTA_TRX_UTIL.Condition_para_tbl_type();
1575: l_parameter_suffix := 0;
1576:
1577: -- if the from parameter and to parameter is null
1578: --and don't add the condition to dynamic sql

Line 1915: -- P_trxtype_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type

1911: --
1912: -- PARAMETERS:
1913: -- In: P_ORG_ID NUMBER
1914: -- p_transfer_id VARCHAR2
1915: -- P_trxtype_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1916: -- p_flex_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1917: -- p_other_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1918: -- p_currency_code VARCHAR2
1919: -- OUT: x_GTA_Trx_Tbl JMF_GTA_TRX_UTIL.TRX_TBL_TYPE

Line 1916: -- p_flex_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type

1912: -- PARAMETERS:
1913: -- In: P_ORG_ID NUMBER
1914: -- p_transfer_id VARCHAR2
1915: -- P_trxtype_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1916: -- p_flex_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1917: -- p_other_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1918: -- p_currency_code VARCHAR2
1919: -- OUT: x_GTA_Trx_Tbl JMF_GTA_TRX_UTIL.TRX_TBL_TYPE
1920:

Line 1917: -- p_other_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type

1913: -- In: P_ORG_ID NUMBER
1914: -- p_transfer_id VARCHAR2
1915: -- P_trxtype_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1916: -- p_flex_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1917: -- p_other_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1918: -- p_currency_code VARCHAR2
1919: -- OUT: x_GTA_Trx_Tbl JMF_GTA_TRX_UTIL.TRX_TBL_TYPE
1920:
1921: -- DESIGN REFERENCES:

Line 1919: -- OUT: x_GTA_Trx_Tbl JMF_GTA_TRX_UTIL.TRX_TBL_TYPE

1915: -- P_trxtype_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1916: -- p_flex_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1917: -- p_other_para JMF_GTA_TRX_UTIL.Condition_para_tbl_type
1918: -- p_currency_code VARCHAR2
1919: -- OUT: x_GTA_Trx_Tbl JMF_GTA_TRX_UTIL.TRX_TBL_TYPE
1920:
1921: -- DESIGN REFERENCES:
1922: -- GTA-TRANSFER-PROGRAM-TD.doc
1923: --

Line 1941: P_trxtype_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,

1937: --===========================================================================
1938: PROCEDURE Retrieve_AR_TRXs(p_org_id IN NUMBER,
1939: p_transfer_id IN NUMBER,
1940: P_query_SQL IN VARCHAR2,
1941: P_trxtype_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1942: p_flex_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1943: p_other_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1944: p_currency_code IN VARCHAR2,
1945: x_GTA_TRX_TBL OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE) IS

Line 1942: p_flex_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,

1938: PROCEDURE Retrieve_AR_TRXs(p_org_id IN NUMBER,
1939: p_transfer_id IN NUMBER,
1940: P_query_SQL IN VARCHAR2,
1941: P_trxtype_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1942: p_flex_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1943: p_other_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1944: p_currency_code IN VARCHAR2,
1945: x_GTA_TRX_TBL OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE) IS
1946:

Line 1943: p_other_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,

1939: p_transfer_id IN NUMBER,
1940: P_query_SQL IN VARCHAR2,
1941: P_trxtype_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1942: p_flex_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1943: p_other_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1944: p_currency_code IN VARCHAR2,
1945: x_GTA_TRX_TBL OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE) IS
1946:
1947: l_normal_exception EXCEPTION;

Line 1945: x_GTA_TRX_TBL OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE) IS

1941: P_trxtype_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1942: p_flex_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1943: p_other_query_para IN JMF_GTA_TRX_UTIL.Condition_para_tbl_type,
1944: p_currency_code IN VARCHAR2,
1945: x_GTA_TRX_TBL OUT NOCOPY JMF_GTA_TRX_UTIL.TRX_TBL_TYPE) IS
1946:
1947: l_normal_exception EXCEPTION;
1948: l_repeat_exception EXCEPTION;
1949: l_no_tax_line_exception EXCEPTION;

Line 1953: l_trx_header JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;

1949: l_no_tax_line_exception EXCEPTION;
1950: l_procedure_name VARCHAR2(30) := 'Retrieve_AR_TRXs';
1951: l_cursor NUMBER;
1952: l_sql_exec_ret NUMBER;
1953: l_trx_header JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1954: l_trx_header_init JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1955: l_trx_line JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1956: l_trx_line_init JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1957: l_trx_lines JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();

Line 1954: l_trx_header_init JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;

1950: l_procedure_name VARCHAR2(30) := 'Retrieve_AR_TRXs';
1951: l_cursor NUMBER;
1952: l_sql_exec_ret NUMBER;
1953: l_trx_header JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1954: l_trx_header_init JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1955: l_trx_line JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1956: l_trx_line_init JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1957: l_trx_lines JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();
1958: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;

Line 1955: l_trx_line JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;

1951: l_cursor NUMBER;
1952: l_sql_exec_ret NUMBER;
1953: l_trx_header JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1954: l_trx_header_init JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1955: l_trx_line JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1956: l_trx_line_init JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1957: l_trx_lines JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();
1958: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
1959: l_trx_rec_init JMF_GTA_TRX_UTIL.TRX_REC_TYPE;

Line 1956: l_trx_line_init JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;

1952: l_sql_exec_ret NUMBER;
1953: l_trx_header JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1954: l_trx_header_init JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1955: l_trx_line JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1956: l_trx_line_init JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1957: l_trx_lines JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();
1958: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
1959: l_trx_rec_init JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
1960: l_log_str VARCHAR2(4000);

Line 1957: l_trx_lines JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();

1953: l_trx_header JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1954: l_trx_header_init JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1955: l_trx_line JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1956: l_trx_line_init JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1957: l_trx_lines JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();
1958: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
1959: l_trx_rec_init JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
1960: l_log_str VARCHAR2(4000);
1961: l_error_string VARCHAR2(1000);

Line 1958: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;

1954: l_trx_header_init JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1955: l_trx_line JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1956: l_trx_line_init JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1957: l_trx_lines JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();
1958: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
1959: l_trx_rec_init JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
1960: l_log_str VARCHAR2(4000);
1961: l_error_string VARCHAR2(1000);
1962: l_error_flag NUMBER := 0;

Line 1959: l_trx_rec_init JMF_GTA_TRX_UTIL.TRX_REC_TYPE;

1955: l_trx_line JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1956: l_trx_line_init JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;
1957: l_trx_lines JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();
1958: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
1959: l_trx_rec_init JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
1960: l_log_str VARCHAR2(4000);
1961: l_error_string VARCHAR2(1000);
1962: l_error_flag NUMBER := 0;
1963:

Line 2123: x_GTA_TRX_TBL := JMF_GTA_TRX_UTIL.TRX_TBL_TYPE();

2119: 'Begin Procedure. ');
2120: END IF;
2121:
2122: -- init x_GTA_TRX_TBL
2123: x_GTA_TRX_TBL := JMF_GTA_TRX_UTIL.TRX_TBL_TYPE();
2124:
2125: l_log_str := p_query_sql;
2126: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2127: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 2304: l_trx_lines := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();

2300: END IF;
2301:
2302: -- init trx header and trx lines
2303: l_trx_header := l_trx_header_init;
2304: l_trx_lines := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();
2305: l_error_flag := 0;
2306:
2307: -- get customer_trx_id of the AR_trx_header
2308: dbms_sql.column_value(l_cursor, 1, l_customer_trx_id);

Line 2479: jmf_gta_trx_util.get_bank_info( p_customer_trx_id => l_customer_trx_id

2475: -- Since if tansaction type is credit memo, the paying customer is null,
2476: -- can not get bank information.
2477: /*
2478: -- call util procedure to get bank info
2479: jmf_gta_trx_util.get_bank_info( p_customer_trx_id => l_customer_trx_id
2480: ,p_org_id => p_org_id
2481: ,x_bank_name => l_apb_customer_bank_name
2482: ,x_bank_branch_name => l_apb_bank_branch_name
2483: ,x_bank_account_name => l_apba_bank_account_name

Line 2653: jmf_gta_trx_util.get_bank_info(p_customer_trx_id => l_origin_trx_id,

2649: --29/06/2006 Added by Shujuan Yan for bug 5263131
2650: IF l_origin_trx_id IS NOT NULL THEN
2651: -- call util procedure to get bank info for 'CM',
2652: -- since paying customer is null, have to use the original invoice
2653: jmf_gta_trx_util.get_bank_info(p_customer_trx_id => l_origin_trx_id,
2654: p_org_id => p_org_id,
2655: x_bank_name => l_apb_customer_bank_name,
2656: x_bank_branch_name => l_apb_bank_branch_name,
2657: x_bank_account_name => l_apba_bank_account_name,

Line 2661: jmf_gta_trx_util.get_bank_info(p_customer_trx_id => l_customer_trx_id,

2657: x_bank_account_name => l_apba_bank_account_name,
2658: x_bank_account_num => l_apba_bank_account_num);
2659: ELSE
2660:
2661: jmf_gta_trx_util.get_bank_info(p_customer_trx_id => l_customer_trx_id,
2662: p_org_id => p_org_id,
2663: x_bank_name => l_apb_customer_bank_name,
2664: x_bank_branch_name => l_apb_bank_branch_name,
2665: x_bank_account_name => l_apba_bank_account_name,

Line 2725: l_trx_lines := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();

2721: -- end insert data into trx_header
2722:
2723: -- begin fetch lines, and insert all value into trx_line;
2724: -- init l_trx_lines
2725: l_trx_lines := JMF_GTA_TRX_UTIL.TRX_line_tbl_TYPE();
2726:
2727: OPEN l_ra_lines(l_customer_trx_id);
2728: LOOP
2729:

Line 2809: jmf_gta_trx_util.get_info_from_ebtax(p_org_id => p_org_id,

2805:
2806: -- 29-JUN-2006 Modified by Shujuan for bug 5168900,
2807: -- Added return parameter p_tax_curr_unit_price
2808: -- in order to get the unit price of tax currency
2809: jmf_gta_trx_util.get_info_from_ebtax(p_org_id => p_org_id,
2810: p_trx_id => l_customer_trx_id,
2811: p_trx_line_id => l_customer_trx_line_id,
2812: p_tax_type_code => l_vat_tax_type,
2813: x_tax_amount => l_tax_amount_func_curr,