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.AR_GTA_CONSOLIDATE_PROC dependencies on DUAL

Line 154: SELECT xmlelement("ReportFailed", 'N') INTO l_Reportfailed FROM dual;

150: FROM AR_gta_consol_temp
151: WHERE status= 'E';
152:
153: -- generate validate xml string
154: SELECT xmlelement("ReportFailed", 'N') INTO l_Reportfailed FROM dual;
155: SELECT xmlelement("FailedWithParameters", 'N')
156: INTO l_failedwithparameters
157: FROM dual;
158:

Line 157: FROM dual;

153: -- generate validate xml string
154: SELECT xmlelement("ReportFailed", 'N') INTO l_Reportfailed FROM dual;
155: SELECT xmlelement("FailedWithParameters", 'N')
156: INTO l_failedwithparameters
157: FROM dual;
158:
159: -- generate xmlsring of parameters of transfer program
160: SELECT xmlelement("Parameters",
161: xmlforest(l_sameprisamedis AS "SamePriSameDis",

Line 169: FROM dual;

165: l_consolidation_id AS "ConsolidationId",
166: l_org_name AS "OrgName"
167: ))
168: INTO l_parameter
169: FROM dual;
170:
171: SELECT xmlelement("Summary",
172: xmlforest(l_succ_unm AS "NumOfSucc",
173: l_warn_unm AS "NumOfWarning",

Line 176: FROM dual;

172: xmlforest(l_succ_unm AS "NumOfSucc",
173: l_warn_unm AS "NumOfWarning",
174: l_error_unm AS "NumOfFailed"))
175: INTO l_summary
176: FROM dual;
177:
178:
179: -- generate the xmltype for success inv
180: --Yao Zhang add for bug 14462789

Line 226: FROM dual;

222: AND jgct.invoice_type = lk.lookup_code
223: AND lk.lookup_type = 'AR_GTA_INVOICE_TYPE';
224: SELECT Xmlconcat(l_success_all, l_success)
225: INTO l_success_all
226: FROM dual;
227:
228: END LOOP;
229: CLOSE c_consol_seq;
230: -- generate the xmltype for warning inv

Line 277: FROM dual;

273: AND jgct.invoice_type = lk.lookup_code
274: AND lk.lookup_type = 'AR_GTA_INVOICE_TYPE';
275: SELECT Xmlconcat(l_warning_all, l_warning)
276: INTO l_warning_all
277: FROM dual;
278: END LOOP;
279: CLOSE c_consol_seq;
280: --ORDER BY jgct.seq;
281: -- generate the xmltype for error inv

Line 333: SELECT Xmlconcat(l_failed_all, l_failed) INTO l_failed_all FROM dual;

329: AND jgct.invoice_type = lk.lookup_code
330: AND lk.lookup_type = 'AR_GTA_INVOICE_TYPE';
331:
332: --ORDER BY jgct.seq;
333: SELECT Xmlconcat(l_failed_all, l_failed) INTO l_failed_all FROM dual;
334: END LOOP;
335: CLOSE c_consol_seq;
336: --generate the final report
337: SELECT xmlelement("ConsolidationReport",

Line 349: FROM dual;

345: l_success_all AS "SuccessInvs",
346: l_warning_all AS "WarningInvs",
347: l_failed_all AS "FailedInvs"))
348: INTO l_report_xml
349: FROM dual;
350:
351: -- concurrent output
352: AR_GTA_TRX_UTIL.output_conc(l_report_XML.Getclobval);
353:

Line 1309: FROM dual;

1305: l_result_flag:=nvl(l_result_flag,'S');
1306: --new header sequence
1307: SELECT ar_gta_trx_headers_all_s.NEXTVAL
1308: INTO l_csldtion_inv.trx_header.gta_trx_header_id
1309: FROM dual;
1310: --copy trx header information
1311: l_csldtion_inv.trx_header.ra_gl_date :=l_csldted_inv.trx_header.ra_gl_date;
1312: l_csldtion_inv.trx_header.ra_gl_period :=l_csldted_inv.trx_header.ra_gl_period;
1313: l_csldtion_inv.trx_header.set_of_books_id :=l_csldted_inv.trx_header.set_of_books_id;

Line 1369: FROM dual;

1365: WHILE l_csldtion_inv_lines_index IS NOT NULL
1366: LOOP
1367: SELECT ar_gta_trx_lines_all_s.NEXTVAL
1368: INTO l_csldtion_inv.trx_lines(l_csldtion_inv_lines_index).gta_trx_line_id
1369: FROM dual;
1370: l_csldtion_inv.trx_lines(l_csldtion_inv_lines_index).gta_trx_header_id
1371: :=l_csldtion_inv.trx_header.gta_trx_header_id;
1372: l_csldtion_inv_lines_index:= l_csldtion_inv.trx_lines.NEXT(l_csldtion_inv_lines_index);
1373: END LOOP;

Line 1392: FROM dual;

1388: END IF;--ABS(l_sum_amount)>l_max_amount OR (l_consol_sign_flag=0 AND l_sum_amount<0) and
1389: --l_csldted_invs.COUNT<=1 create consolidation invoice
1390: SELECT AR_gta_consol_temp_s.NEXTVAL
1391: INTO l_gta_consol_temp_seq
1392: FROM dual;
1393: INSERT INTO AR_gta_consol_temp
1394: (seq
1395: ,status
1396: ,consolidation_inv_number

Line 1417: FROM dual;

1413: ,l_bank_account_number
1414: ,l_invoice_type
1415: ,l_sum_amount
1416: ,l_error_string
1417: FROM dual;
1418: --insert csldted invs to table ar_gta_consol_invs_temp
1419: --init l_csldted_invs_index
1420: l_csldted_invs_index:=l_csldted_invs.FIRST;
1421: WHILE l_csldted_invs_index IS NOT NULL

Line 1464: FROM dual;

1460: ,l_csldted_invs(l_csldted_invs_index).trx_header.ra_gl_period
1461: ,l_csldted_invs(l_csldted_invs_index).trx_header.RA_TRX_NUMBER
1462: ,l_ra_trx_type
1463: ,l_amount
1464: FROM dual;
1465: l_csldted_invs_index:=l_csldted_invs.NEXT(l_csldted_invs_index);
1466: END LOOP;
1467:
1468: