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 ZX_REGISTRATIONS

Line 6133: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_TYPE'

6129: BEGIN
6130: SELECT fndlookup.lookup_code
6131: INTO l_dummy_lookup
6132: FROM fnd_lookups fndlookup
6133: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_TYPE'
6134: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6135: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6136: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'
6137: AND lookup_code = p_tax_profile_rec.registration_type_code

Line 6392: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_TYPE'

6388: ' Validating tax registration type');
6389: SELECT fndlookup.lookup_code
6390: INTO l_dummy_lookup
6391: FROM fnd_lookups fndlookup
6392: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_TYPE'
6393: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6394: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6395: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'
6396: AND lookup_code = p_tax_reg_rec.registration_type_code

Line 6437: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_STATUS'

6433: BEGIN
6434: SELECT fndlookup.lookup_code
6435: INTO l_dummy_lookup
6436: FROM fnd_lookups fndlookup
6437: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_STATUS'
6438: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6439: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6440: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'
6441: AND lookup_code = p_tax_reg_rec.registration_status_code

Line 6528: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_REASON'

6524: BEGIN
6525: SELECT fndlookup.lookup_code
6526: INTO l_dummy_lookup
6527: FROM fnd_lookups fndlookup
6528: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_REASON'
6529: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6530: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6531: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'
6532: AND lookup_code = p_tax_reg_rec.registration_reason_code

Line 6573: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_SOURCE'

6569: BEGIN
6570: SELECT fndlookup.lookup_code
6571: INTO l_dummy_lookup
6572: FROM fnd_lookups fndlookup
6573: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_SOURCE'
6574: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
6575: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
6576: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'
6577: AND lookup_code = p_tax_reg_rec.registration_source_code

Line 6742: ' Calling zx_registrations_pkg.insert_row');

6738: x_tax_authority_party_id => l_tax_authority_party_id);
6739:
6740: IF (l_valid = 'Y') THEN
6741: fnd_file.put_line(fnd_file.log,
6742: ' Calling zx_registrations_pkg.insert_row');
6743:
6744: zx_registrations_pkg.insert_row(p_request_id => NULL,
6745: p_attribute1 => NULL,
6746: p_attribute2 => NULL,

Line 6744: zx_registrations_pkg.insert_row(p_request_id => NULL,

6740: IF (l_valid = 'Y') THEN
6741: fnd_file.put_line(fnd_file.log,
6742: ' Calling zx_registrations_pkg.insert_row');
6743:
6744: zx_registrations_pkg.insert_row(p_request_id => NULL,
6745: p_attribute1 => NULL,
6746: p_attribute2 => NULL,
6747: p_attribute3 => NULL,
6748: p_attribute4 => NULL,

Line 6872: ' Calling zx_registrations_pkg.update_row');

6868: x_tax_authority_party_id => l_tax_authority_party_id);
6869:
6870: IF (l_valid = 'Y') THEN
6871: fnd_file.put_line(fnd_file.log,
6872: ' Calling zx_registrations_pkg.update_row');
6873:
6874: zx_registrations_pkg.update_row(p_registration_id => p_registration_id,
6875: p_request_id => NULL,
6876: p_attribute1 => NULL,

Line 6874: zx_registrations_pkg.update_row(p_registration_id => p_registration_id,

6870: IF (l_valid = 'Y') THEN
6871: fnd_file.put_line(fnd_file.log,
6872: ' Calling zx_registrations_pkg.update_row');
6873:
6874: zx_registrations_pkg.update_row(p_registration_id => p_registration_id,
6875: p_request_id => NULL,
6876: p_attribute1 => NULL,
6877: p_attribute2 => NULL,
6878: p_attribute3 => NULL,

Line 7728: FROM zx_registrations

7724: BEGIN
7725: -- get the registration id
7726: SELECT 'U'
7727: INTO l_tax_reg_rec_tab(cntr).insert_update_flag
7728: FROM zx_registrations
7729: WHERE party_tax_profile_id = l_tax_profile_id
7730: AND tax_regime_code = l_tax_reg_rec_tab(cntr).tax_regime_code
7731: AND SYSDATE BETWEEN effective_from AND
7732: nvl(effective_to, SYSDATE);

Line 7751: FROM zx_registrations

7747: SELECT registration_id,
7748: effective_from
7749: INTO l_tax_reg_id,
7750: l_effective_from_date
7751: FROM zx_registrations
7752: WHERE party_tax_profile_id = l_tax_profile_id
7753: AND tax_regime_code = l_tax_reg_rec_tab(cntr).tax_regime_code
7754: AND SYSDATE BETWEEN effective_from AND
7755: nvl(effective_to, SYSDATE);