1143:
1144: l_sub_request_ids := SUBSTRB( l_sub_request_ids, l_posi1 + 1 );
1145: END LOOP;
1146: ELSE
1147: m_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1148: l_times := 0;
1149: END IF;
1150:
1151: l_times := l_times + 1;
3158: USING
3159: (SELECT 'THIRD_PARTY' PARTY_TYPE_CODE,
3160: party.party_id PARTY_ID,
3161: party.country COUNTRY_CODE, --4742586
3162: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3163: party.tax_reference TAX_REFERENCE,
3164: SYSDATE CREATION_DATE,
3165: FND_GLOBAL.User_ID CREATED_BY,
3166: SYSDATE LAST_UPDATE_DATE,
3161: party.country COUNTRY_CODE, --4742586
3162: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3163: party.tax_reference TAX_REFERENCE,
3164: SYSDATE CREATION_DATE,
3165: FND_GLOBAL.User_ID CREATED_BY,
3166: SYSDATE LAST_UPDATE_DATE,
3167: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3168: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3169: FROM HZ_PARTIES party, ra_customers_interface_all rci -- Bug 4956131
3163: party.tax_reference TAX_REFERENCE,
3164: SYSDATE CREATION_DATE,
3165: FND_GLOBAL.User_ID CREATED_BY,
3166: SYSDATE LAST_UPDATE_DATE,
3167: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3168: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3169: FROM HZ_PARTIES party, ra_customers_interface_all rci -- Bug 4956131
3170: WHERE party.orig_system_reference = nvl(rci.orig_system_party_ref, rci.orig_system_customer_ref)
3171: AND party.request_id = p_request_id
3164: SYSDATE CREATION_DATE,
3165: FND_GLOBAL.User_ID CREATED_BY,
3166: SYSDATE LAST_UPDATE_DATE,
3167: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3168: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3169: FROM HZ_PARTIES party, ra_customers_interface_all rci -- Bug 4956131
3170: WHERE party.orig_system_reference = nvl(rci.orig_system_party_ref, rci.orig_system_customer_ref)
3171: AND party.request_id = p_request_id
3172: AND rci.interface_status is null
3235: USING
3236: (SELECT 'THIRD_PARTY' PARTY_TYPE_CODE,
3237: party.party_id PARTY_ID,
3238: party.country COUNTRY_CODE,
3239: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3240: party.tax_reference TAX_REFERENCE,
3241: SYSDATE CREATION_DATE,
3242: FND_GLOBAL.User_ID CREATED_BY,
3243: SYSDATE LAST_UPDATE_DATE,
3238: party.country COUNTRY_CODE,
3239: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3240: party.tax_reference TAX_REFERENCE,
3241: SYSDATE CREATION_DATE,
3242: FND_GLOBAL.User_ID CREATED_BY,
3243: SYSDATE LAST_UPDATE_DATE,
3244: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3245: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3246: FROM HZ_PARTIES party, RA_CONTACT_PHONES_INT_ALL rcpi
3240: party.tax_reference TAX_REFERENCE,
3241: SYSDATE CREATION_DATE,
3242: FND_GLOBAL.User_ID CREATED_BY,
3243: SYSDATE LAST_UPDATE_DATE,
3244: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3245: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3246: FROM HZ_PARTIES party, RA_CONTACT_PHONES_INT_ALL rcpi
3247: WHERE party.orig_system_reference = rcpi.orig_system_contact_ref
3248: AND party.request_id = p_request_id
3241: SYSDATE CREATION_DATE,
3242: FND_GLOBAL.User_ID CREATED_BY,
3243: SYSDATE LAST_UPDATE_DATE,
3244: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3245: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3246: FROM HZ_PARTIES party, RA_CONTACT_PHONES_INT_ALL rcpi
3247: WHERE party.orig_system_reference = rcpi.orig_system_contact_ref
3248: AND party.request_id = p_request_id
3249: AND rcpi.interface_status is null
3306: USING
3307: (SELECT 'THIRD_PARTY_SITE' PARTY_TYPE_CODE,
3308: ps.party_site_id PARTY_ID,
3309: loc.country COUNTRY_CODE,--4742586
3310: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3311: NULL TAX_REFERENCE,
3312: SYSDATE CREATION_DATE,
3313: FND_GLOBAL.User_ID CREATED_BY,
3314: SYSDATE LAST_UPDATE_DATE,
3309: loc.country COUNTRY_CODE,--4742586
3310: FND_GLOBAL.Login_ID PROGRAM_LOGIN_ID ,
3311: NULL TAX_REFERENCE,
3312: SYSDATE CREATION_DATE,
3313: FND_GLOBAL.User_ID CREATED_BY,
3314: SYSDATE LAST_UPDATE_DATE,
3315: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3316: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3317: FROM HZ_PARTY_SITES ps, ra_customers_interface_all rci, -- Bug 4956131
3311: NULL TAX_REFERENCE,
3312: SYSDATE CREATION_DATE,
3313: FND_GLOBAL.User_ID CREATED_BY,
3314: SYSDATE LAST_UPDATE_DATE,
3315: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3316: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3317: FROM HZ_PARTY_SITES ps, ra_customers_interface_all rci, -- Bug 4956131
3318: HZ_LOCATIONS loc --4742586
3319: WHERE ps.orig_system_reference = rci.orig_system_address_ref
3312: SYSDATE CREATION_DATE,
3313: FND_GLOBAL.User_ID CREATED_BY,
3314: SYSDATE LAST_UPDATE_DATE,
3315: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3316: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3317: FROM HZ_PARTY_SITES ps, ra_customers_interface_all rci, -- Bug 4956131
3318: HZ_LOCATIONS loc --4742586
3319: WHERE ps.orig_system_reference = rci.orig_system_address_ref
3320: AND loc.location_id = ps.location_id --4742586