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.ZX_TRN_VALIDATION_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 14: g_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;

10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'ZX.PLSQL.ZX_TRN_VALIDATION_PKG.';
13: G_INVALID_PTP_ID CONSTANT NUMBER(3) := -1;
14: g_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
15: g_trn VARCHAR2(20);
16: l_allow_regn_num_flag VARCHAR2(1);
17: -- Logging Infra
18:

Line 130: zx_party_tax_profile ptp

126: c_tax varchar2,
127: c_tax_jurisdiction_code varchar2) IS
128: SELECT distinct ptp.party_id
129: FROM zx_registrations reg,
130: zx_party_tax_profile ptp
131: WHERE ptp.party_tax_profile_id = reg.party_tax_profile_id
132: AND reg.registration_number = c_registration_number
133: AND sysdate >= reg.effective_from
134: AND (sysdate <= reg.effective_to OR reg.effective_to IS NULL)

Line 159: FROM zx_party_tax_profile

155:
156:
157: CURSOR ptp_type_csr(c_ptp_id number) IS
158: SELECT party_type_code
159: FROM zx_party_tax_profile
160: WHERE party_tax_profile_id = c_ptp_id;
161:
162:
163: CURSOR c_AllowDupRegnNum IS

Line 174: FROM zx_party_tax_profile s,

170: CURSOR c_third_party_reg_num (c_ptp_id number, c_tax_reg_num varchar2) IS
171: SELECT registration_number
172: FROM zx_registrations
173: WHERE party_tax_profile_id = (SELECT s.party_tax_profile_id
174: FROM zx_party_tax_profile s,
175: zx_party_tax_profile ptp,
176: hz_party_sites hzps
177: where ptp.party_tax_profile_id = c_ptp_id
178: and ptp.party_id = hzps.party_site_id

Line 175: zx_party_tax_profile ptp,

171: SELECT registration_number
172: FROM zx_registrations
173: WHERE party_tax_profile_id = (SELECT s.party_tax_profile_id
174: FROM zx_party_tax_profile s,
175: zx_party_tax_profile ptp,
176: hz_party_sites hzps
177: where ptp.party_tax_profile_id = c_ptp_id
178: and ptp.party_id = hzps.party_site_id
179: and hzps.party_id = s.party_id

Line 189: zx_party_tax_profile ptp,

185: FROM zx_registrations regt
186: where regt.party_tax_profile_id = (SELECT ptpp.party_tax_profile_id
187: FROM xle_fp_establishment_v est,
188: xle_fp_establishment_v estp,
189: zx_party_tax_profile ptp,
190: zx_party_tax_profile ptpp
191: where estp.party_id = ptpp.party_id
192: and estp.legal_entity_id = est.legal_entity_id
193: and est.party_id = ptp.party_id

Line 190: zx_party_tax_profile ptpp

186: where regt.party_tax_profile_id = (SELECT ptpp.party_tax_profile_id
187: FROM xle_fp_establishment_v est,
188: xle_fp_establishment_v estp,
189: zx_party_tax_profile ptp,
190: zx_party_tax_profile ptpp
191: where estp.party_id = ptpp.party_id
192: and estp.legal_entity_id = est.legal_entity_id
193: and est.party_id = ptp.party_id
194: and ptp.party_tax_profile_id = c_ptp_id

Line 410: ZX_PARTY_TAX_PROFILE ZXP

406: INTO l_party_name, l_party_site_name
407: FROM ZX_REGISTRATIONS REG,
408: HZ_PARTY_SITES HZS,
409: HZ_PARTIES HZP,
410: ZX_PARTY_TAX_PROFILE ZXP
411: WHERE HZP.PARTY_ID = HZS.PARTY_ID
412: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID
413: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
414: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'

Line 416: FROM ZX_PARTY_TAX_PROFILE S,

412: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID
413: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
414: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
415: AND REG.PARTY_TAX_PROFILE_ID NOT IN (SELECT S.PARTY_TAX_PROFILE_ID
416: FROM ZX_PARTY_TAX_PROFILE S,
417: ZX_PARTY_TAX_PROFILE PTP,
418: HZ_PARTY_SITES HZPS
419: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
420: AND PTP.PARTY_ID = HZPS.PARTY_ID

Line 417: ZX_PARTY_TAX_PROFILE PTP,

413: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
414: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
415: AND REG.PARTY_TAX_PROFILE_ID NOT IN (SELECT S.PARTY_TAX_PROFILE_ID
416: FROM ZX_PARTY_TAX_PROFILE S,
417: ZX_PARTY_TAX_PROFILE PTP,
418: HZ_PARTY_SITES HZPS
419: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
420: AND PTP.PARTY_ID = HZPS.PARTY_ID
421: AND HZPS.PARTY_SITE_ID = S.PARTY_ID

Line 455: ZX_PARTY_TAX_PROFILE ZXP

451: SELECT HZP.PARTY_NAME
452: INTO l_party_name
453: FROM ZX_REGISTRATIONS REG,
454: HZ_PARTIES HZP,
455: ZX_PARTY_TAX_PROFILE ZXP
456: WHERE HZP.PARTY_ID = ZXP.PARTY_ID
457: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
458: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
459: AND REG.PARTY_TAX_PROFILE_ID NOT IN

Line 461: FROM ZX_PARTY_TAX_PROFILE S,

457: AND ZXP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
458: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
459: AND REG.PARTY_TAX_PROFILE_ID NOT IN
460: (SELECT S.PARTY_TAX_PROFILE_ID
461: FROM ZX_PARTY_TAX_PROFILE S,
462: ZX_PARTY_TAX_PROFILE PTP,
463: HZ_PARTY_SITES HZPS
464: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
465: AND PTP.PARTY_ID = HZPS.PARTY_SITE_ID

Line 462: ZX_PARTY_TAX_PROFILE PTP,

458: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
459: AND REG.PARTY_TAX_PROFILE_ID NOT IN
460: (SELECT S.PARTY_TAX_PROFILE_ID
461: FROM ZX_PARTY_TAX_PROFILE S,
462: ZX_PARTY_TAX_PROFILE PTP,
463: HZ_PARTY_SITES HZPS
464: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
465: AND PTP.PARTY_ID = HZPS.PARTY_SITE_ID
466: AND HZPS.PARTY_ID = S.PARTY_ID

Line 602: FROM zx_party_tax_profile ptp

598: ----------------------------------------------------------------
599:
600: CURSOR trn_with_no_reg_common_cur(c_ptp_id number, c_registration_number varchar2, c_party_type_code varchar2) IS
601: SELECT distinct ptp.party_id,ptp.party_tax_profile_id
602: FROM zx_party_tax_profile ptp
603: WHERE ptp.rep_registration_number = c_registration_number
604: AND ptp.party_type_code = c_party_type_code
605: AND ptp.party_tax_profile_id <> c_ptp_id;
606:

Line 689: FROM zx_party_tax_profile ptp

685: ELSIF p_party_type_code = 'THIRD_PARTY_SITE' THEN
686: BEGIN
687: SELECT distinct ptp.party_id, ptp.party_tax_profile_id
688: into l_party_id,l_ptp_id
689: FROM zx_party_tax_profile ptp
690: where ptp.rep_registration_number = p_tax_reg_num
691: and ptp.party_type_code = p_party_type_code
692: and ptp.party_tax_profile_id <> p_ptp_id
693: and not exists (SELECT 1

Line 694: FROM zx_party_tax_profile reg,

690: where ptp.rep_registration_number = p_tax_reg_num
691: and ptp.party_type_code = p_party_type_code
692: and ptp.party_tax_profile_id <> p_ptp_id
693: and not exists (SELECT 1
694: FROM zx_party_tax_profile reg,
695: hz_party_sites hzs,
696: hz_party_sites hzr
697: where reg.party_tax_profile_id = p_ptp_id
698: and ptp.party_id = hzs.party_site_id

Line 744: FROM zx_party_tax_profile ptp

740: ELSIF p_party_type_code = 'LEGAL_ESTABLISHMENT' THEN
741: BEGIN
742: SELECT distinct ptp.party_id,ptp.party_tax_profile_id
743: into l_party_id,l_ptp_id
744: FROM zx_party_tax_profile ptp
745: where ptp.rep_registration_number = p_tax_reg_num
746: and ptp.party_type_code = p_party_type_code
747: and ptp.party_tax_profile_id <> p_ptp_id
748: and not exists (SELECT 1

Line 751: zx_party_tax_profile ptpp

747: and ptp.party_tax_profile_id <> p_ptp_id
748: and not exists (SELECT 1
749: FROM xle_fp_establishment_v est,
750: xle_fp_establishment_v estp,
751: zx_party_tax_profile ptpp
752: where ptpp.party_tax_profile_id = p_ptp_id
753: and estp.party_id = ptpp.party_id
754: and estp.legal_entity_id = est.legal_entity_id
755: and est.party_id = ptp.party_id);

Line 795: FROM ZX_PARTY_TAX_PROFILE PTP

791: ELSE -- Cross Validation trn_with_no_reg_common_cur%NOTFOUND
792: BEGIN
793: SELECT COUNT(PTP.rep_registration_number)
794: INTO l_total_count
795: FROM ZX_PARTY_TAX_PROFILE PTP
796: WHERE PTP.rep_registration_number = p_tax_reg_num
797: AND ptp.party_tax_profile_id <> p_ptp_id;
798: EXCEPTION
799: WHEN OTHERS THEN

Line 813: FROM ZX_PARTY_TAX_PROFILE S,

809: IF p_party_type_code = 'THIRD_PARTY' THEN
810: BEGIN
811: SELECT count(S.PARTY_TAX_PROFILE_ID)
812: INTO l_specific_count
813: FROM ZX_PARTY_TAX_PROFILE S,
814: ZX_PARTY_TAX_PROFILE PTP,
815: HZ_PARTY_SITES HZPS
816: WHERE PTP.PARTY_TAX_PROFILE_ID = P_PTP_ID
817: AND PTP.PARTY_ID = HZPS.PARTY_ID

Line 814: ZX_PARTY_TAX_PROFILE PTP,

810: BEGIN
811: SELECT count(S.PARTY_TAX_PROFILE_ID)
812: INTO l_specific_count
813: FROM ZX_PARTY_TAX_PROFILE S,
814: ZX_PARTY_TAX_PROFILE PTP,
815: HZ_PARTY_SITES HZPS
816: WHERE PTP.PARTY_TAX_PROFILE_ID = P_PTP_ID
817: AND PTP.PARTY_ID = HZPS.PARTY_ID
818: AND HZPS.PARTY_SITE_ID = S.PARTY_ID

Line 845: ZX_PARTY_TAX_PROFILE ZXP

841: HZP.STATE) PARTY_SITE_NAME
842: INTO l_ptp_id,l_party_name, l_party_site_name
843: FROM HZ_PARTY_SITES HZS,
844: HZ_PARTIES HZP,
845: ZX_PARTY_TAX_PROFILE ZXP
846: WHERE HZP.PARTY_ID = HZS.PARTY_ID
847: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID
848: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
849: AND NOT EXISTS (SELECT PTP.PARTY_TAX_PROFILE_ID

Line 850: FROM ZX_PARTY_TAX_PROFILE PTP,

846: WHERE HZP.PARTY_ID = HZS.PARTY_ID
847: AND HZS.PARTY_SITE_ID = ZXP.PARTY_ID
848: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
849: AND NOT EXISTS (SELECT PTP.PARTY_TAX_PROFILE_ID
850: FROM ZX_PARTY_TAX_PROFILE PTP,
851: HZ_PARTY_SITES HZPS
852: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
853: AND PTP.PARTY_ID = HZPS.PARTY_ID(+)
854: AND (HZPS.PARTY_SITE_ID IS NULL

Line 892: FROM zx_party_tax_profile s,

888: ELSIF p_party_type_code = 'THIRD_PARTY_SITE' THEN
889: BEGIN
890: SELECT count(s.party_tax_profile_id)
891: into l_specific_count
892: FROM zx_party_tax_profile s,
893: zx_party_tax_profile ptp,
894: hz_party_sites hzps
895: where ptp.party_tax_profile_id = p_ptp_id
896: and ptp.party_id = hzps.party_site_id

Line 893: zx_party_tax_profile ptp,

889: BEGIN
890: SELECT count(s.party_tax_profile_id)
891: into l_specific_count
892: FROM zx_party_tax_profile s,
893: zx_party_tax_profile ptp,
894: hz_party_sites hzps
895: where ptp.party_tax_profile_id = p_ptp_id
896: and ptp.party_id = hzps.party_site_id
897: and hzps.party_id = s.party_id

Line 917: ZX_PARTY_TAX_PROFILE ZXP

913:
914: SELECT ZXP.PARTY_TAX_PROFILE_ID,HZP.PARTY_NAME
915: INTO l_ptp_id,l_party_name
916: FROM HZ_PARTIES HZP,
917: ZX_PARTY_TAX_PROFILE ZXP
918: WHERE HZP.PARTY_ID = ZXP.PARTY_ID
919: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
920: AND NOT EXISTS (SELECT S.PARTY_TAX_PROFILE_ID
921: FROM ZX_PARTY_TAX_PROFILE S,

Line 921: FROM ZX_PARTY_TAX_PROFILE S,

917: ZX_PARTY_TAX_PROFILE ZXP
918: WHERE HZP.PARTY_ID = ZXP.PARTY_ID
919: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
920: AND NOT EXISTS (SELECT S.PARTY_TAX_PROFILE_ID
921: FROM ZX_PARTY_TAX_PROFILE S,
922: ZX_PARTY_TAX_PROFILE PTP,
923: HZ_PARTY_SITES HZPS
924: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
925: AND PTP.PARTY_ID = HZPS.PARTY_SITE_ID

Line 922: ZX_PARTY_TAX_PROFILE PTP,

918: WHERE HZP.PARTY_ID = ZXP.PARTY_ID
919: AND ZXP.PARTY_TYPE_CODE = 'THIRD_PARTY'
920: AND NOT EXISTS (SELECT S.PARTY_TAX_PROFILE_ID
921: FROM ZX_PARTY_TAX_PROFILE S,
922: ZX_PARTY_TAX_PROFILE PTP,
923: HZ_PARTY_SITES HZPS
924: WHERE PTP.PARTY_TAX_PROFILE_ID = p_ptp_id
925: AND PTP.PARTY_ID = HZPS.PARTY_SITE_ID
926: AND HZPS.PARTY_ID = S.PARTY_ID

Line 1038: FROM zx_party_tax_profile

1034: -- the validation is completed eventhough we are updating one of the upgraded
1035: -- party tax profile. So the below query fails and go for normal validation.
1036: BEGIN
1037: SELECT rep_registration_number into l_trn
1038: FROM zx_party_tax_profile
1039: where party_tax_profile_id = p_ptp_id
1040: and rep_registration_number = p_tax_reg_num
1041: and record_type_code = 'MIGRATED'
1042: and not exists(SELECT 1 FROM zx_registrations reg

Line 1085: FROM zx_registrations reg,zx_taxes_b t,zx_party_tax_profile ptp

1081: END;
1082: BEGIN
1083: SELECT t.allow_dup_regn_num_flag
1084: INTO l_allow_regn_num_flag
1085: FROM zx_registrations reg,zx_taxes_b t,zx_party_tax_profile ptp
1086: WHERE ptp.party_tax_profile_id = NVL(p_ptp_id,G_INVALID_PTP_ID)
1087: AND ptp.rep_registration_number = p_tax_reg_num
1088: AND reg.registration_number = p_tax_reg_num
1089: AND reg.party_tax_profile_id <> p_ptp_id

Line 1231: ZX_PARTY_TAX_PROFILE PTP

1227: BEGIN
1228: SELECT COUNT(REG.REGISTRATION_NUMBER)
1229: INTO l_total_count
1230: FROM ZX_REGISTRATIONS REG,
1231: ZX_PARTY_TAX_PROFILE PTP
1232: WHERE PTP.PARTY_TAX_PROFILE_ID = REG.PARTY_TAX_PROFILE_ID
1233: AND REG.REGISTRATION_NUMBER = l_trn
1234: AND PTP.PARTY_TAX_PROFILE_ID <> G_PTP_ID
1235: AND SYSDATE >= REG.EFFECTIVE_FROM

Line 1257: FROM ZX_PARTY_TAX_PROFILE S,

1253: INTO l_specific_count
1254: FROM ZX_REGISTRATIONS REG
1255: WHERE REG.PARTY_TAX_PROFILE_ID IN
1256: (SELECT S.PARTY_TAX_PROFILE_ID
1257: FROM ZX_PARTY_TAX_PROFILE S,
1258: ZX_PARTY_TAX_PROFILE PTP,
1259: HZ_PARTY_SITES HZPS
1260: WHERE PTP.PARTY_TAX_PROFILE_ID = G_PTP_ID
1261: AND PTP.PARTY_ID = HZPS.PARTY_ID

Line 1258: ZX_PARTY_TAX_PROFILE PTP,

1254: FROM ZX_REGISTRATIONS REG
1255: WHERE REG.PARTY_TAX_PROFILE_ID IN
1256: (SELECT S.PARTY_TAX_PROFILE_ID
1257: FROM ZX_PARTY_TAX_PROFILE S,
1258: ZX_PARTY_TAX_PROFILE PTP,
1259: HZ_PARTY_SITES HZPS
1260: WHERE PTP.PARTY_TAX_PROFILE_ID = G_PTP_ID
1261: AND PTP.PARTY_ID = HZPS.PARTY_ID
1262: AND HZPS.PARTY_SITE_ID = S.PARTY_ID