APPS.HZ_PARTY_SITE_V2PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2993: UPDATE HZ_CUST_ACCT_SITES_ALL

2989: END IF;
2990:
2991: -- check whether record has been updated by another user. If not, lock it.
2992: BEGIN
2993: UPDATE HZ_CUST_ACCT_SITES_ALL
2994: SET STATUS = p_new_status,
2995: bill_to_flag = NULL,
2996: ship_to_flag = NULL,
2997: market_flag = NULL,

Line 3162: l_cust_acct_site_id HZ_CUST_ACCT_SITES_ALL.cust_acct_site_id%TYPE;

3158:
3159: ) IS
3160:
3161: l_debug_prefix VARCHAR2(30) := ''; --'denormalize_site_use_flag'
3162: l_cust_acct_site_id HZ_CUST_ACCT_SITES_ALL.cust_acct_site_id%TYPE;
3163:
3164: BEGIN
3165:
3166: -- Debug info.

Line 3187: UPDATE HZ_CUST_ACCT_SITES_ALL

3183: RETURNING CUST_ACCT_SITE_ID INTO l_cust_acct_site_id;
3184:
3185: IF p_site_use_code = 'BILL_TO' THEN
3186:
3187: UPDATE HZ_CUST_ACCT_SITES_ALL
3188: SET BILL_TO_FLAG = 'P',
3189: last_update_date = hz_utility_v2pub.last_update_date,
3190: last_updated_by = hz_utility_v2pub.last_updated_by,
3191: last_update_login = hz_utility_v2pub.last_update_login,

Line 3200: UPDATE HZ_CUST_ACCT_SITES_ALL

3196: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3197:
3198: ELSIF p_site_use_code = 'SHIP_TO' THEN
3199:
3200: UPDATE HZ_CUST_ACCT_SITES_ALL
3201: SET SHIP_TO_FLAG = 'P',
3202: last_update_date = hz_utility_v2pub.last_update_date,
3203: last_updated_by = hz_utility_v2pub.last_updated_by,
3204: last_update_login = hz_utility_v2pub.last_update_login,

Line 3213: UPDATE HZ_CUST_ACCT_SITES_ALL

3209: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3210:
3211: ELSIF p_site_use_code = 'MARKET' THEN
3212:
3213: UPDATE HZ_CUST_ACCT_SITES_ALL
3214: SET MARKET_FLAG = 'P',
3215: last_update_date = hz_utility_v2pub.last_update_date,
3216: last_updated_by = hz_utility_v2pub.last_updated_by,
3217: last_update_login = hz_utility_v2pub.last_update_login,

Line 3283: FROM hz_cust_acct_sites_all a , hz_cust_site_uses_all b

3279: once the acct sites sharing the p_party_site_id are made inactive
3280: even for multiple accounts sharing p_party_site_id */
3281: cursor c_prim is
3282: SELECT MIN(b.site_use_id) , site_use_code
3283: FROM hz_cust_acct_sites_all a , hz_cust_site_uses_all b
3284: WHERE a.cust_account_id in (select cust_account_id
3285: from hz_cust_acct_sites_all cas
3286: where cas.party_site_id = p_party_site_id)
3287: AND a.cust_acct_site_id = b.cust_acct_site_id

Line 3285: from hz_cust_acct_sites_all cas

3281: cursor c_prim is
3282: SELECT MIN(b.site_use_id) , site_use_code
3283: FROM hz_cust_acct_sites_all a , hz_cust_site_uses_all b
3284: WHERE a.cust_account_id in (select cust_account_id
3285: from hz_cust_acct_sites_all cas
3286: where cas.party_site_id = p_party_site_id)
3287: AND a.cust_acct_site_id = b.cust_acct_site_id
3288: AND b.status = 'A'
3289: AND a.status = 'A'

Line 3317: FROM HZ_CUST_ACCT_SITES_ALL

3313: program_application_id = hz_utility_v2pub.program_application_id,
3314: program_update_date = hz_utility_v2pub.program_update_date
3315: WHERE CUST_ACCT_SITE_ID IN (
3316: SELECT CUST_ACCT_SITE_ID
3317: FROM HZ_CUST_ACCT_SITES_ALL
3318: WHERE PARTY_SITE_ID = p_party_site_id);
3319: /*Bug Fix: 4515314*/
3320: OPEN c_prim;
3321: LOOP