APPS.HZ_CUSTOMER_INT dependencies on ZX_PARTY_TAX_PROFILE

Line 3157: MERGE INTO ZX_PARTY_TAX_PROFILE PTP

3153:
3154: BEGIN
3155:
3156: -- Import Party
3157: MERGE INTO ZX_PARTY_TAX_PROFILE PTP
3158: USING
3159: (SELECT 'THIRD_PARTY' PARTY_TYPE_CODE,
3160: party.party_id PARTY_ID,
3161: party.country COUNTRY_CODE, --4742586

Line 3217: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

3213: REQUEST_ID,
3214: OBJECT_VERSION_NUMBER,
3215: COUNTRY_CODE)--4742586
3216: VALUES (PTY.PARTY_TYPE_CODE,
3217: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
3218: PTY.PARTY_ID,
3219: PTY.PROGRAM_LOGIN_ID,
3220: PTY.TAX_REFERENCE,
3221: PTY.CREATION_DATE,

Line 3234: MERGE INTO ZX_PARTY_TAX_PROFILE PTP

3230: PTY.COUNTRY_CODE );--4742586
3231:
3232: -- Bug 6682585
3233: -- Insert Contact Person Parties
3234: MERGE INTO ZX_PARTY_TAX_PROFILE PTP
3235: USING
3236: (SELECT 'THIRD_PARTY' PARTY_TYPE_CODE,
3237: party.party_id PARTY_ID,
3238: party.country COUNTRY_CODE,

Line 3287: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

3283: REQUEST_ID,
3284: OBJECT_VERSION_NUMBER,
3285: COUNTRY_CODE)
3286: VALUES (PTY.PARTY_TYPE_CODE,
3287: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
3288: PTY.PARTY_ID,
3289: PTY.PROGRAM_LOGIN_ID,
3290: PTY.TAX_REFERENCE,
3291: PTY.CREATION_DATE,

Line 3305: MERGE INTO ZX_PARTY_TAX_PROFILE PTP

3301:
3302:
3303:
3304: -- Import Party Sites
3305: MERGE INTO ZX_PARTY_TAX_PROFILE PTP
3306: USING
3307: (SELECT 'THIRD_PARTY_SITE' PARTY_TYPE_CODE,
3308: ps.party_site_id PARTY_ID,
3309: loc.country COUNTRY_CODE,--4742586

Line 3360: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,

3356: OBJECT_VERSION_NUMBER,
3357: COUNTRY_CODE)--4742586
3358: VALUES (
3359: PTY.PARTY_TYPE_CODE,
3360: ZX_PARTY_TAX_PROFILE_S.NEXTVAL,
3361: PTY.PARTY_ID,
3362: PTY.PROGRAM_LOGIN_ID,
3363: PTY.TAX_REFERENCE,
3364: PTY.CREATION_DATE,

Line 3563: FROM zx_party_tax_profile

3559: ,x_msg_data OUT NOCOPY VARCHAR2)
3560: IS
3561:
3562: CURSOR c_tax_reference IS SELECT party_id, rep_registration_number
3563: FROM zx_party_tax_profile
3564: WHERE request_id = p_request_id
3565: AND party_type_code ='THIRD_PARTY';
3566:
3567: TYPE PARTY_ID IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE;

Line 3647: FROM zx_party_tax_profile_int zx_ptp

3643:
3644: /*Query to identify errored out Customers*/
3645:
3646: CURSOR error_parties IS SELECT intf_party_reference
3647: FROM zx_party_tax_profile_int zx_ptp
3648: WHERE request_id = p_request_id
3649: AND zx_ptp.intf_party_site_reference IS NULL
3650: AND NVL(zx_ptp.record_status,3) = 3;
3651:

Line 3655: FROM zx_party_tax_profile_int zx_ptp

3651:
3652: /*Query to identify errored out Addresses*/
3653:
3654: CURSOR error_sites IS SELECT intf_party_site_reference
3655: FROM zx_party_tax_profile_int zx_ptp
3656: WHERE request_id = p_request_id
3657: AND zx_ptp.intf_party_site_reference IS NOT NULL
3658: AND NVL(zx_ptp.record_status,3) = 3;
3659: l_request_id NUMBER;

Line 3873: FROM zx_party_tax_profile_int

3869:
3870: BEGIN
3871:
3872: SELECT request_id INTO l_request_id
3873: FROM zx_party_tax_profile_int
3874: WHERE intf_party_reference IN (SELECT Nvl(orig_system_party_ref, orig_system_customer_ref)
3875: FROM ra_customers_interface
3876: )
3877: AND ROWNUM = 1 ;

Line 3918: FROM zx_party_tax_profile_int

3914:
3915: BEGIN
3916:
3917: SELECT request_id INTO l_request_id
3918: FROM zx_party_tax_profile_int
3919: WHERE intf_party_reference IN (SELECT Nvl(orig_system_party_ref, orig_system_customer_ref)
3920: FROM ra_customers_interface
3921: )
3922: AND ROWNUM = 1 ;

Line 3954: FROM zx_party_tax_profile_int

3950:
3951: BEGIN
3952:
3953: SELECT request_id INTO l_request_id
3954: FROM zx_party_tax_profile_int
3955: WHERE intf_party_reference IN (SELECT Nvl(orig_system_party_ref, orig_system_customer_ref)
3956: FROM ra_customers_interface
3957: )
3958: AND ROWNUM = 1 ;

Line 3996: FROM zx_party_tax_profile_int

3992:
3993: BEGIN
3994:
3995: SELECT request_id INTO l_request_id
3996: FROM zx_party_tax_profile_int
3997: WHERE intf_party_reference IN (SELECT Nvl(orig_system_party_ref, orig_system_customer_ref)
3998: FROM ra_customers_interface
3999: )
4000: AND ROWNUM = 1 ;