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_IMP_SUPP_PKG dependencies on HZ_UTILITY_V2PUB

Line 393: last_updated_by = hz_utility_v2pub.last_updated_by,

389:
390: -- update the batch record
391: UPDATE pos_imp_batch_summary
392: SET batch_status = 'ACTIVE',
393: last_updated_by = hz_utility_v2pub.last_updated_by,
394: last_update_date = hz_utility_v2pub.last_update_date,
395: last_update_login = hz_utility_v2pub.last_update_login
396: WHERE batch_id = p_batch_id;
397:

Line 394: last_update_date = hz_utility_v2pub.last_update_date,

390: -- update the batch record
391: UPDATE pos_imp_batch_summary
392: SET batch_status = 'ACTIVE',
393: last_updated_by = hz_utility_v2pub.last_updated_by,
394: last_update_date = hz_utility_v2pub.last_update_date,
395: last_update_login = hz_utility_v2pub.last_update_login
396: WHERE batch_id = p_batch_id;
397:
398: ------------------------------------

Line 395: last_update_login = hz_utility_v2pub.last_update_login

391: UPDATE pos_imp_batch_summary
392: SET batch_status = 'ACTIVE',
393: last_updated_by = hz_utility_v2pub.last_updated_by,
394: last_update_date = hz_utility_v2pub.last_update_date,
395: last_update_login = hz_utility_v2pub.last_update_login
396: WHERE batch_id = p_batch_id;
397:
398: ------------------------------------
399: -- call the pre import count process

Line 565: purged_by_user_id = hz_utility_v2pub.user_id

561: -- Update pos_imp_batch_summary table.
562: UPDATE pos_imp_batch_summary
563: SET batch_status = 'PURGED',
564: purge_date = SYSDATE,
565: purged_by_user_id = hz_utility_v2pub.user_id
566: WHERE batch_id = p_batch_id;
567: COMMIT;
568:
569: fnd_file.put_line(fnd_file.log,

Line 676: last_updated_by = hz_utility_v2pub.last_updated_by,

672: -- update the batch record
673: UPDATE hz_imp_batch_summary
674: SET batch_status = 'REJECTED',
675: import_status = 'REJECTED',
676: last_updated_by = hz_utility_v2pub.last_updated_by,
677: last_update_date = hz_utility_v2pub.last_update_date,
678: last_update_login = hz_utility_v2pub.last_update_login
679: WHERE batch_id = p_batch_id;
680:

Line 677: last_update_date = hz_utility_v2pub.last_update_date,

673: UPDATE hz_imp_batch_summary
674: SET batch_status = 'REJECTED',
675: import_status = 'REJECTED',
676: last_updated_by = hz_utility_v2pub.last_updated_by,
677: last_update_date = hz_utility_v2pub.last_update_date,
678: last_update_login = hz_utility_v2pub.last_update_login
679: WHERE batch_id = p_batch_id;
680:
681: UPDATE pos_imp_batch_summary

Line 678: last_update_login = hz_utility_v2pub.last_update_login

674: SET batch_status = 'REJECTED',
675: import_status = 'REJECTED',
676: last_updated_by = hz_utility_v2pub.last_updated_by,
677: last_update_date = hz_utility_v2pub.last_update_date,
678: last_update_login = hz_utility_v2pub.last_update_login
679: WHERE batch_id = p_batch_id;
680:
681: UPDATE pos_imp_batch_summary
682: SET batch_status = 'REJECTED',

Line 684: last_updated_by = hz_utility_v2pub.last_updated_by,

680:
681: UPDATE pos_imp_batch_summary
682: SET batch_status = 'REJECTED',
683: import_status = 'REJECTED',
684: last_updated_by = hz_utility_v2pub.last_updated_by,
685: last_update_date = hz_utility_v2pub.last_update_date,
686: last_update_login = hz_utility_v2pub.last_update_login
687: WHERE batch_id = p_batch_id;
688:

Line 685: last_update_date = hz_utility_v2pub.last_update_date,

681: UPDATE pos_imp_batch_summary
682: SET batch_status = 'REJECTED',
683: import_status = 'REJECTED',
684: last_updated_by = hz_utility_v2pub.last_updated_by,
685: last_update_date = hz_utility_v2pub.last_update_date,
686: last_update_login = hz_utility_v2pub.last_update_login
687: WHERE batch_id = p_batch_id;
688:
689: -- standard call to get message count and if count is 1, get message info.

Line 686: last_update_login = hz_utility_v2pub.last_update_login

682: SET batch_status = 'REJECTED',
683: import_status = 'REJECTED',
684: last_updated_by = hz_utility_v2pub.last_updated_by,
685: last_update_date = hz_utility_v2pub.last_update_date,
686: last_update_login = hz_utility_v2pub.last_update_login
687: WHERE batch_id = p_batch_id;
688:
689: -- standard call to get message count and if count is 1, get message info.
690: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 754: hz_utility_v2pub.validate_mandatory(p_create_update_flag => 'C',

750: -- do validation
751: ----------------
752:
753: -- batch name is mandatory
754: hz_utility_v2pub.validate_mandatory(p_create_update_flag => 'C',
755: p_column => 'batch_name',
756: p_column_value => p_batch_name,
757: p_restricted => 'Y',
758: x_return_status => x_return_status);

Line 761: hz_utility_v2pub.validate_mandatory(p_create_update_flag => 'C',

757: p_restricted => 'Y',
758: x_return_status => x_return_status);
759:
760: -- original_system is mandatory
761: hz_utility_v2pub.validate_mandatory(p_create_update_flag => 'C',
762: p_column => 'original_system',
763: p_column_value => p_original_system,
764: p_restricted => 'Y',
765: x_return_status => x_return_status);

Line 811: hz_utility_v2pub.created_by,

807: p_description,
808: p_original_system,
809: p_load_type,
810: p_est_no_of_records,
811: hz_utility_v2pub.created_by,
812: hz_utility_v2pub.creation_date,
813: hz_utility_v2pub.last_updated_by,
814: hz_utility_v2pub.last_update_date,
815: hz_utility_v2pub.last_update_login);

Line 812: hz_utility_v2pub.creation_date,

808: p_original_system,
809: p_load_type,
810: p_est_no_of_records,
811: hz_utility_v2pub.created_by,
812: hz_utility_v2pub.creation_date,
813: hz_utility_v2pub.last_updated_by,
814: hz_utility_v2pub.last_update_date,
815: hz_utility_v2pub.last_update_login);
816:

Line 813: hz_utility_v2pub.last_updated_by,

809: p_load_type,
810: p_est_no_of_records,
811: hz_utility_v2pub.created_by,
812: hz_utility_v2pub.creation_date,
813: hz_utility_v2pub.last_updated_by,
814: hz_utility_v2pub.last_update_date,
815: hz_utility_v2pub.last_update_login);
816:
817: -- standard call to get message count and if count is 1, get message info.

Line 814: hz_utility_v2pub.last_update_date,

810: p_est_no_of_records,
811: hz_utility_v2pub.created_by,
812: hz_utility_v2pub.creation_date,
813: hz_utility_v2pub.last_updated_by,
814: hz_utility_v2pub.last_update_date,
815: hz_utility_v2pub.last_update_login);
816:
817: -- standard call to get message count and if count is 1, get message info.
818: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 815: hz_utility_v2pub.last_update_login);

811: hz_utility_v2pub.created_by,
812: hz_utility_v2pub.creation_date,
813: hz_utility_v2pub.last_updated_by,
814: hz_utility_v2pub.last_update_date,
815: hz_utility_v2pub.last_update_login);
816:
817: -- standard call to get message count and if count is 1, get message info.
818: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
819: p_count => x_msg_count,