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.AP_AUTOSELECT_PKG dependencies on DBMS_XMLGEN

Line 4666: l_qryCtx DBMS_XMLGEN.ctxHandle;

4662: errbuf OUT NOCOPY VARCHAR2,
4663: retcode OUT NOCOPY NUMBER,
4664: p_checkrun_id in varchar2)is
4665:
4666: l_qryCtx DBMS_XMLGEN.ctxHandle;
4667: l_result_clob CLOB;
4668: l_current_calling_sequence varchar2(2000);
4669: l_debug_info varchar2(200);
4670:

Line 4678: l_qryCtx := DBMS_XMLGEN.newContext(

4674: l_debug_info:= 'select from ap_inv_selection_criteria_all';
4675:
4676: fnd_file.put_line(fnd_file.output, '');
4677:
4678: l_qryCtx := DBMS_XMLGEN.newContext(
4679: 'select aisc.checkrun_name, aisc.pay_from_date, aisc.pay_thru_date,
4680: aisc.hi_payment_priority, aisc.low_payment_priority,
4681: aisc.pay_only_when_due_flag, aisc.zero_amounts_allowed,
4682: aisc.zero_invoices_allowed, ab.batch_name,

Line 4703: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CRITERIA');

4699: and aisc.party_id = hz.party_id(+)
4700: and rate.lookup_type(+) = ''INVOICE_EXCHANGE_RATE_TYPE''
4701: and aisc.inv_exchange_rate_type = rate.lookup_code(+)');
4702:
4703: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CRITERIA');
4704: DBMS_XMLGEN.setRowTag(l_qryCtx, 'SELECTION_CRITERIA');
4705: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4706: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4707: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 4704: DBMS_XMLGEN.setRowTag(l_qryCtx, 'SELECTION_CRITERIA');

4700: and rate.lookup_type(+) = ''INVOICE_EXCHANGE_RATE_TYPE''
4701: and aisc.inv_exchange_rate_type = rate.lookup_code(+)');
4702:
4703: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CRITERIA');
4704: DBMS_XMLGEN.setRowTag(l_qryCtx, 'SELECTION_CRITERIA');
4705: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4706: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4707: DBMS_XMLGEN.closeContext(l_qryCtx);
4708: ap_utilities_pkg.clob_to_file(l_result_clob);

Line 4705: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

4701: and aisc.inv_exchange_rate_type = rate.lookup_code(+)');
4702:
4703: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CRITERIA');
4704: DBMS_XMLGEN.setRowTag(l_qryCtx, 'SELECTION_CRITERIA');
4705: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4706: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4707: DBMS_XMLGEN.closeContext(l_qryCtx);
4708: ap_utilities_pkg.clob_to_file(l_result_clob);
4709:

Line 4707: DBMS_XMLGEN.closeContext(l_qryCtx);

4703: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CRITERIA');
4704: DBMS_XMLGEN.setRowTag(l_qryCtx, 'SELECTION_CRITERIA');
4705: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4706: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4707: DBMS_XMLGEN.closeContext(l_qryCtx);
4708: ap_utilities_pkg.clob_to_file(l_result_clob);
4709:
4710:
4711: l_debug_info := 'select pay group';

Line 4714: l_qryCtx := DBMS_XMLGEN.newContext('SELECT vendor_pay_group '||

4710:
4711: l_debug_info := 'select pay group';
4712:
4713:
4714: l_qryCtx := DBMS_XMLGEN.newContext('SELECT vendor_pay_group '||
4715: 'FROM ap_pay_group '||
4716: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
4717: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
4718: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');

Line 4717: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');

4713:
4714: l_qryCtx := DBMS_XMLGEN.newContext('SELECT vendor_pay_group '||
4715: 'FROM ap_pay_group '||
4716: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
4717: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
4718: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
4719: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4720: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4721: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 4718: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');

4714: l_qryCtx := DBMS_XMLGEN.newContext('SELECT vendor_pay_group '||
4715: 'FROM ap_pay_group '||
4716: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
4717: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
4718: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
4719: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4720: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4721: DBMS_XMLGEN.closeContext(l_qryCtx);
4722: ap_utilities_pkg.clob_to_file(l_result_clob);

Line 4719: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

4715: 'FROM ap_pay_group '||
4716: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
4717: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
4718: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
4719: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4720: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4721: DBMS_XMLGEN.closeContext(l_qryCtx);
4722: ap_utilities_pkg.clob_to_file(l_result_clob);
4723:

Line 4721: DBMS_XMLGEN.closeContext(l_qryCtx);

4717: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
4718: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
4719: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4720: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4721: DBMS_XMLGEN.closeContext(l_qryCtx);
4722: ap_utilities_pkg.clob_to_file(l_result_clob);
4723:
4724:
4725: l_debug_info := 'select currency group';

Line 4727: l_qryCtx := DBMS_XMLGEN.newContext('SELECT currency_code '||

4723:
4724:
4725: l_debug_info := 'select currency group';
4726:
4727: l_qryCtx := DBMS_XMLGEN.newContext('SELECT currency_code '||
4728: 'FROM AP_CURRENCY_GROUP '||
4729: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
4730: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
4731: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');

Line 4730: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');

4726:
4727: l_qryCtx := DBMS_XMLGEN.newContext('SELECT currency_code '||
4728: 'FROM AP_CURRENCY_GROUP '||
4729: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
4730: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
4731: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
4732: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4733: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4734: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 4731: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');

4727: l_qryCtx := DBMS_XMLGEN.newContext('SELECT currency_code '||
4728: 'FROM AP_CURRENCY_GROUP '||
4729: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
4730: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
4731: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
4732: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4733: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4734: DBMS_XMLGEN.closeContext(l_qryCtx);
4735: ap_utilities_pkg.clob_to_file(l_result_clob);

Line 4732: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

4728: 'FROM AP_CURRENCY_GROUP '||
4729: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
4730: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
4731: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
4732: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4733: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4734: DBMS_XMLGEN.closeContext(l_qryCtx);
4735: ap_utilities_pkg.clob_to_file(l_result_clob);
4736:

Line 4734: DBMS_XMLGEN.closeContext(l_qryCtx);

4730: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
4731: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
4732: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4733: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4734: DBMS_XMLGEN.closeContext(l_qryCtx);
4735: ap_utilities_pkg.clob_to_file(l_result_clob);
4736:
4737:
4738:

Line 4741: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name legal_entity_name '||

4737:
4738:
4739: l_debug_info:= 'select le group';
4740:
4741: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name legal_entity_name '||
4742: 'FROM ap_le_group aleg, xle_entity_profiles xle '||
4743: 'WHERE aleg.legal_entity_id = xle.legal_entity_id '||
4744: 'AND checkrun_id = '||to_char(p_checkrun_id));
4745: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');

Line 4745: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');

4741: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name legal_entity_name '||
4742: 'FROM ap_le_group aleg, xle_entity_profiles xle '||
4743: 'WHERE aleg.legal_entity_id = xle.legal_entity_id '||
4744: 'AND checkrun_id = '||to_char(p_checkrun_id));
4745: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');
4746: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');
4747: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4748: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4749: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 4746: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');

4742: 'FROM ap_le_group aleg, xle_entity_profiles xle '||
4743: 'WHERE aleg.legal_entity_id = xle.legal_entity_id '||
4744: 'AND checkrun_id = '||to_char(p_checkrun_id));
4745: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');
4746: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');
4747: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4748: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4749: DBMS_XMLGEN.closeContext(l_qryCtx);
4750: ap_utilities_pkg.clob_to_file(l_result_clob);

Line 4747: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

4743: 'WHERE aleg.legal_entity_id = xle.legal_entity_id '||
4744: 'AND checkrun_id = '||to_char(p_checkrun_id));
4745: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');
4746: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');
4747: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4748: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4749: DBMS_XMLGEN.closeContext(l_qryCtx);
4750: ap_utilities_pkg.clob_to_file(l_result_clob);
4751:

Line 4749: DBMS_XMLGEN.closeContext(l_qryCtx);

4745: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');
4746: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');
4747: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4748: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4749: DBMS_XMLGEN.closeContext(l_qryCtx);
4750: ap_utilities_pkg.clob_to_file(l_result_clob);
4751:
4752:
4753: l_debug_info := 'select ou group';

Line 4755: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name organization_name '||

4751:
4752:
4753: l_debug_info := 'select ou group';
4754:
4755: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name organization_name '||
4756: 'FROM AP_OU_GROUP AOG, HR_OPERATING_UNITS HR '||
4757: 'WHERE hr.organization_id = aog.org_id '||
4758: 'AND checkrun_id = '||to_char(p_checkrun_id));
4759: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');

Line 4759: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');

4755: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name organization_name '||
4756: 'FROM AP_OU_GROUP AOG, HR_OPERATING_UNITS HR '||
4757: 'WHERE hr.organization_id = aog.org_id '||
4758: 'AND checkrun_id = '||to_char(p_checkrun_id));
4759: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');
4760: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');
4761: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4762: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4763: DBMS_XMLGEN.closeContext(l_qryCtx);

Line 4760: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');

4756: 'FROM AP_OU_GROUP AOG, HR_OPERATING_UNITS HR '||
4757: 'WHERE hr.organization_id = aog.org_id '||
4758: 'AND checkrun_id = '||to_char(p_checkrun_id));
4759: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');
4760: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');
4761: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4762: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4763: DBMS_XMLGEN.closeContext(l_qryCtx);
4764: ap_utilities_pkg.clob_to_file(l_result_clob);

Line 4761: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);

4757: 'WHERE hr.organization_id = aog.org_id '||
4758: 'AND checkrun_id = '||to_char(p_checkrun_id));
4759: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');
4760: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');
4761: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4762: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4763: DBMS_XMLGEN.closeContext(l_qryCtx);
4764: ap_utilities_pkg.clob_to_file(l_result_clob);
4765:

Line 4763: DBMS_XMLGEN.closeContext(l_qryCtx);

4759: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');
4760: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');
4761: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
4762: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
4763: DBMS_XMLGEN.closeContext(l_qryCtx);
4764: ap_utilities_pkg.clob_to_file(l_result_clob);
4765:
4766: fnd_file.put_line(fnd_file.output, '');
4767: