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.POS_BATCH_IMPORT_PKG dependencies on HZ_IMP_BATCH_SUMMARY

Line 202: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.

198: ' Rows inserted in hz_imp_parties_int: ' ||
199: l_insert_count);
200:
201: IF (l_insert_count > 0) THEN
202: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.
203: UPDATE hz_imp_batch_summary
204: SET total_batch_records = total_batch_records + l_insert_count,
205: total_records_for_import = total_records_for_import +
206: l_insert_count,

Line 203: UPDATE hz_imp_batch_summary

199: l_insert_count);
200:
201: IF (l_insert_count > 0) THEN
202: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.
203: UPDATE hz_imp_batch_summary
204: SET total_batch_records = total_batch_records + l_insert_count,
205: total_records_for_import = total_records_for_import +
206: l_insert_count,
207: parties_in_batch = parties_in_batch + l_insert_count

Line 366: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.

362: ' Rows inserted in hz_imp_addresses_int: ' ||
363: l_insert_count);
364:
365: IF (l_insert_count > 0) THEN
366: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.
367: UPDATE hz_imp_batch_summary
368: SET total_batch_records = total_batch_records + l_insert_count,
369: total_records_for_import = total_records_for_import +
370: l_insert_count,

Line 367: UPDATE hz_imp_batch_summary

363: l_insert_count);
364:
365: IF (l_insert_count > 0) THEN
366: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.
367: UPDATE hz_imp_batch_summary
368: SET total_batch_records = total_batch_records + l_insert_count,
369: total_records_for_import = total_records_for_import +
370: l_insert_count,
371: addresses_in_batch = addresses_in_batch + l_insert_count

Line 483: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.

479: ' Rows inserted in hz_imp_parties_int: ' ||
480: l_insert_count);
481:
482: IF (l_insert_count > 0) THEN
483: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.
484: UPDATE hz_imp_batch_summary
485: SET total_batch_records = total_batch_records + l_insert_count,
486: total_records_for_import = total_records_for_import +
487: l_insert_count,

Line 484: UPDATE hz_imp_batch_summary

480: l_insert_count);
481:
482: IF (l_insert_count > 0) THEN
483: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.
484: UPDATE hz_imp_batch_summary
485: SET total_batch_records = total_batch_records + l_insert_count,
486: total_records_for_import = total_records_for_import +
487: l_insert_count,
488: parties_in_batch = parties_in_batch + l_insert_count

Line 578: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.

574: ' Rows inserted in hz_imp_contacts_int: ' ||
575: l_insert_count);
576:
577: IF (l_insert_count > 0) THEN
578: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.
579: UPDATE hz_imp_batch_summary
580: SET total_batch_records = total_batch_records + l_insert_count,
581: total_records_for_import = total_records_for_import +
582: l_insert_count,

Line 579: UPDATE hz_imp_batch_summary

575: l_insert_count);
576:
577: IF (l_insert_count > 0) THEN
578: -- Update hz_imp_batch_summary with the count of the records inserted into interface table.
579: UPDATE hz_imp_batch_summary
580: SET total_batch_records = total_batch_records + l_insert_count,
581: total_records_for_import = total_records_for_import +
582: l_insert_count,
583: contacts_in_batch = contacts_in_batch + l_insert_count

Line 10009: l_batch_status hz_imp_batch_summary.batch_status%TYPE;

10005: l_request_id NUMBER := fnd_global.conc_request_id;
10006:
10007: l_errbuf VARCHAR2(4000);
10008: l_retcode VARCHAR2(10);
10009: l_batch_status hz_imp_batch_summary.batch_status%TYPE;
10010: l_import_status hz_imp_batch_summary.import_status%TYPE;
10011: l_main_conc_status hz_imp_batch_summary.main_conc_status%TYPE;
10012: l_import_run_option VARCHAR2(20);
10013: l_what_if_flag VARCHAR2(10);

Line 10010: l_import_status hz_imp_batch_summary.import_status%TYPE;

10006:
10007: l_errbuf VARCHAR2(4000);
10008: l_retcode VARCHAR2(10);
10009: l_batch_status hz_imp_batch_summary.batch_status%TYPE;
10010: l_import_status hz_imp_batch_summary.import_status%TYPE;
10011: l_main_conc_status hz_imp_batch_summary.main_conc_status%TYPE;
10012: l_import_run_option VARCHAR2(20);
10013: l_what_if_flag VARCHAR2(10);
10014:

Line 10011: l_main_conc_status hz_imp_batch_summary.main_conc_status%TYPE;

10007: l_errbuf VARCHAR2(4000);
10008: l_retcode VARCHAR2(10);
10009: l_batch_status hz_imp_batch_summary.batch_status%TYPE;
10010: l_import_status hz_imp_batch_summary.import_status%TYPE;
10011: l_main_conc_status hz_imp_batch_summary.main_conc_status%TYPE;
10012: l_import_run_option VARCHAR2(20);
10013: l_what_if_flag VARCHAR2(10);
10014:
10015: l_return_status VARCHAR2(2000);

Line 10073: UPDATE hz_imp_batch_summary

10069: main_conc_status = 'COMPLETED',
10070: batch_status = 'ACTION_REQUIRED'
10071: WHERE batch_id = p_batch_id;
10072:
10073: UPDATE hz_imp_batch_summary
10074: SET what_if_flag = decode(p_import_run_option, 'WHAT_IF', 'Y', 'N')
10075: WHERE batch_id = p_batch_id;
10076:
10077: RETURN;

Line 10114: UPDATE hz_imp_batch_summary

10110: main_conc_status = 'COMPLETED',
10111: batch_status = 'PENDING'
10112: WHERE batch_id = p_batch_id;
10113:
10114: UPDATE hz_imp_batch_summary
10115: SET import_status = 'COMPL_ERRORS',
10116: main_conc_status = 'COMPLETED',
10117: batch_status = 'ACTION_REQUIRED'
10118: WHERE batch_id = p_batch_id;

Line 10135: FROM hz_imp_batch_summary

10131: what_if_flag
10132: INTO l_batch_status,
10133: l_import_status,
10134: l_what_if_flag
10135: FROM hz_imp_batch_summary
10136: WHERE batch_id = p_batch_id;
10137:
10138: EXCEPTION
10139: WHEN no_data_found THEN

Line 10204: FROM hz_imp_batch_summary

10200: main_conc_status
10201: INTO l_batch_status,
10202: l_import_status,
10203: l_main_conc_status
10204: FROM hz_imp_batch_summary
10205: WHERE batch_id = p_batch_id;
10206:
10207: EXCEPTION
10208: WHEN no_data_found THEN

Line 10218: UPDATE hz_imp_batch_summary

10214: /*After the party import is completed enable the party
10215: as supplier and party contact as supplier contact*/
10216:
10217: IF (l_batch_status = 'COMPLETED') THEN
10218: UPDATE hz_imp_batch_summary
10219: SET total_inserts = parties_inserted + addresses_inserted +
10220: addressuses_inserted + contactpoints_inserted +
10221: contacts_inserted + contactroles_inserted +
10222: codeassigns_inserted + relationships_inserted +