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 6266: l_qryCtx DBMS_XMLGEN.ctxHandle;

6262: errbuf OUT NOCOPY VARCHAR2,
6263: retcode OUT NOCOPY NUMBER,
6264: p_checkrun_id in varchar2)is
6265:
6266: l_qryCtx DBMS_XMLGEN.ctxHandle;
6267: l_result_clob CLOB;
6268: l_current_calling_sequence varchar2(2000);
6269: l_debug_info varchar2(200);
6270:

Line 6278: l_qryCtx := DBMS_XMLGEN.newContext(

6274: l_debug_info:= 'select from ap_inv_selection_criteria_all';
6275:
6276: fnd_file.put_line(fnd_file.output, '');
6277:
6278: l_qryCtx := DBMS_XMLGEN.newContext(
6279: 'select aisc.checkrun_name, aisc.pay_from_date, aisc.pay_thru_date,
6280: aisc.hi_payment_priority, aisc.low_payment_priority,
6281: aisc.pay_only_when_due_flag, aisc.zero_amounts_allowed,
6282: aisc.zero_invoices_allowed, ab.batch_name,

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

6299: and aisc.party_id = hz.party_id(+)
6300: and rate.lookup_type(+) = ''INVOICE_EXCHANGE_RATE_TYPE''
6301: and aisc.inv_exchange_rate_type = rate.lookup_code(+)');
6302:
6303: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CRITERIA');
6304: DBMS_XMLGEN.setRowTag(l_qryCtx, 'SELECTION_CRITERIA');
6305: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6306: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6307: DBMS_XMLGEN.closeContext(l_qryCtx);

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

6300: and rate.lookup_type(+) = ''INVOICE_EXCHANGE_RATE_TYPE''
6301: and aisc.inv_exchange_rate_type = rate.lookup_code(+)');
6302:
6303: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CRITERIA');
6304: DBMS_XMLGEN.setRowTag(l_qryCtx, 'SELECTION_CRITERIA');
6305: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6306: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6307: DBMS_XMLGEN.closeContext(l_qryCtx);
6308: ap_utilities_pkg.clob_to_file(l_result_clob);

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

6301: and aisc.inv_exchange_rate_type = rate.lookup_code(+)');
6302:
6303: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CRITERIA');
6304: DBMS_XMLGEN.setRowTag(l_qryCtx, 'SELECTION_CRITERIA');
6305: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6306: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6307: DBMS_XMLGEN.closeContext(l_qryCtx);
6308: ap_utilities_pkg.clob_to_file(l_result_clob);
6309:

Line 6307: DBMS_XMLGEN.closeContext(l_qryCtx);

6303: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CRITERIA');
6304: DBMS_XMLGEN.setRowTag(l_qryCtx, 'SELECTION_CRITERIA');
6305: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6306: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6307: DBMS_XMLGEN.closeContext(l_qryCtx);
6308: ap_utilities_pkg.clob_to_file(l_result_clob);
6309:
6310:
6311: l_debug_info := 'select pay group';

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

6310:
6311: l_debug_info := 'select pay group';
6312:
6313:
6314: l_qryCtx := DBMS_XMLGEN.newContext('SELECT vendor_pay_group '||
6315: 'FROM ap_pay_group '||
6316: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
6317: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
6318: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');

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

6313:
6314: l_qryCtx := DBMS_XMLGEN.newContext('SELECT vendor_pay_group '||
6315: 'FROM ap_pay_group '||
6316: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
6317: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
6318: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
6319: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6320: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6321: DBMS_XMLGEN.closeContext(l_qryCtx);

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

6314: l_qryCtx := DBMS_XMLGEN.newContext('SELECT vendor_pay_group '||
6315: 'FROM ap_pay_group '||
6316: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
6317: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
6318: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
6319: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6320: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6321: DBMS_XMLGEN.closeContext(l_qryCtx);
6322: ap_utilities_pkg.clob_to_file(l_result_clob);

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

6315: 'FROM ap_pay_group '||
6316: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
6317: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
6318: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
6319: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6320: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6321: DBMS_XMLGEN.closeContext(l_qryCtx);
6322: ap_utilities_pkg.clob_to_file(l_result_clob);
6323:

Line 6321: DBMS_XMLGEN.closeContext(l_qryCtx);

6317: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'PAY');
6318: DBMS_XMLGEN.setRowTag(l_qryCtx, 'PAY_GROUP');
6319: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6320: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6321: DBMS_XMLGEN.closeContext(l_qryCtx);
6322: ap_utilities_pkg.clob_to_file(l_result_clob);
6323:
6324:
6325: l_debug_info := 'select currency group';

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

6323:
6324:
6325: l_debug_info := 'select currency group';
6326:
6327: l_qryCtx := DBMS_XMLGEN.newContext('SELECT currency_code '||
6328: 'FROM AP_CURRENCY_GROUP '||
6329: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
6330: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
6331: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');

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

6326:
6327: l_qryCtx := DBMS_XMLGEN.newContext('SELECT currency_code '||
6328: 'FROM AP_CURRENCY_GROUP '||
6329: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
6330: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
6331: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
6332: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6333: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6334: DBMS_XMLGEN.closeContext(l_qryCtx);

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

6327: l_qryCtx := DBMS_XMLGEN.newContext('SELECT currency_code '||
6328: 'FROM AP_CURRENCY_GROUP '||
6329: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
6330: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
6331: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
6332: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6333: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6334: DBMS_XMLGEN.closeContext(l_qryCtx);
6335: ap_utilities_pkg.clob_to_file(l_result_clob);

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

6328: 'FROM AP_CURRENCY_GROUP '||
6329: 'WHERE checkrun_id = '||to_char(p_checkrun_id));
6330: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
6331: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
6332: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6333: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6334: DBMS_XMLGEN.closeContext(l_qryCtx);
6335: ap_utilities_pkg.clob_to_file(l_result_clob);
6336:

Line 6334: DBMS_XMLGEN.closeContext(l_qryCtx);

6330: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'CURRENCY');
6331: DBMS_XMLGEN.setRowTag(l_qryCtx, 'CURRENCY_GROUP');
6332: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6333: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6334: DBMS_XMLGEN.closeContext(l_qryCtx);
6335: ap_utilities_pkg.clob_to_file(l_result_clob);
6336:
6337:
6338:

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

6337:
6338:
6339: l_debug_info:= 'select le group';
6340:
6341: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name legal_entity_name '||
6342: 'FROM ap_le_group aleg, xle_entity_profiles xle '||
6343: 'WHERE aleg.legal_entity_id = xle.legal_entity_id '||
6344: 'AND checkrun_id = '||to_char(p_checkrun_id));
6345: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');

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

6341: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name legal_entity_name '||
6342: 'FROM ap_le_group aleg, xle_entity_profiles xle '||
6343: 'WHERE aleg.legal_entity_id = xle.legal_entity_id '||
6344: 'AND checkrun_id = '||to_char(p_checkrun_id));
6345: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');
6346: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');
6347: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6348: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6349: DBMS_XMLGEN.closeContext(l_qryCtx);

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

6342: 'FROM ap_le_group aleg, xle_entity_profiles xle '||
6343: 'WHERE aleg.legal_entity_id = xle.legal_entity_id '||
6344: 'AND checkrun_id = '||to_char(p_checkrun_id));
6345: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');
6346: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');
6347: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6348: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6349: DBMS_XMLGEN.closeContext(l_qryCtx);
6350: ap_utilities_pkg.clob_to_file(l_result_clob);

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

6343: 'WHERE aleg.legal_entity_id = xle.legal_entity_id '||
6344: 'AND checkrun_id = '||to_char(p_checkrun_id));
6345: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');
6346: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');
6347: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6348: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6349: DBMS_XMLGEN.closeContext(l_qryCtx);
6350: ap_utilities_pkg.clob_to_file(l_result_clob);
6351:

Line 6349: DBMS_XMLGEN.closeContext(l_qryCtx);

6345: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'LEGAL_ENTITY');
6346: DBMS_XMLGEN.setRowTag(l_qryCtx, 'LE_GROUP');
6347: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6348: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6349: DBMS_XMLGEN.closeContext(l_qryCtx);
6350: ap_utilities_pkg.clob_to_file(l_result_clob);
6351:
6352:
6353: l_debug_info := 'select ou group';

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

6351:
6352:
6353: l_debug_info := 'select ou group';
6354:
6355: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name organization_name '||
6356: 'FROM AP_OU_GROUP AOG, HR_OPERATING_UNITS HR '||
6357: 'WHERE hr.organization_id = aog.org_id '||
6358: 'AND checkrun_id = '||to_char(p_checkrun_id));
6359: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');

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

6355: l_qryCtx := DBMS_XMLGEN.newContext('SELECT name organization_name '||
6356: 'FROM AP_OU_GROUP AOG, HR_OPERATING_UNITS HR '||
6357: 'WHERE hr.organization_id = aog.org_id '||
6358: 'AND checkrun_id = '||to_char(p_checkrun_id));
6359: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');
6360: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');
6361: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6362: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6363: DBMS_XMLGEN.closeContext(l_qryCtx);

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

6356: 'FROM AP_OU_GROUP AOG, HR_OPERATING_UNITS HR '||
6357: 'WHERE hr.organization_id = aog.org_id '||
6358: 'AND checkrun_id = '||to_char(p_checkrun_id));
6359: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');
6360: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');
6361: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6362: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6363: DBMS_XMLGEN.closeContext(l_qryCtx);
6364: ap_utilities_pkg.clob_to_file(l_result_clob);

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

6357: 'WHERE hr.organization_id = aog.org_id '||
6358: 'AND checkrun_id = '||to_char(p_checkrun_id));
6359: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');
6360: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');
6361: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6362: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6363: DBMS_XMLGEN.closeContext(l_qryCtx);
6364: ap_utilities_pkg.clob_to_file(l_result_clob);
6365:

Line 6363: DBMS_XMLGEN.closeContext(l_qryCtx);

6359: DBMS_XMLGEN.setRowSetTag(l_qryCtx,'ORGANIZATION');
6360: DBMS_XMLGEN.setRowTag(l_qryCtx, 'OU_GROUP');
6361: l_result_clob :=DBMS_XMLGEN.GETXML(l_qryCtx);
6362: l_result_clob := substr(l_result_clob,instr(l_result_clob,'>')+1);
6363: DBMS_XMLGEN.closeContext(l_qryCtx);
6364: ap_utilities_pkg.clob_to_file(l_result_clob);
6365:
6366: fnd_file.put_line(fnd_file.output, '');
6367: