APPS.XTR_REPLICATE_BANK_BRANCHES_P dependencies on FND_GLOBAL

Line 377: ,updated_by = fnd_global.user_id

373: IF(p_update_type = 1) then
374: UPDATE XTR_PARTY_INFO
375: SET short_name = nvl(p_xtr_party_info_rec.short_name,short_name)
376: ,full_name = p_xtr_party_info_rec.full_name
377: ,updated_by = fnd_global.user_id
378: ,updated_on = sysdate
379: WHERE ce_bank_branch_id = l_ce_bank_branch_id;
380: ELSIF(p_update_type = 2) THEN
381: UPDATE XTR_PARTY_INFO

Line 386: ,updated_by = fnd_global.user_id

382: SET address_2 = p_xtr_party_info_rec.address_2
383: ,address_3 = p_xtr_party_info_rec.address_3
384: ,address_4 = p_xtr_party_info_rec.address_4
385: ,address_5 = p_xtr_party_info_rec.address_5
386: ,updated_by = fnd_global.user_id
387: ,updated_on = sysdate
388: ,p_address_1 = p_xtr_party_info_rec.p_address_1
389: ,p_address_2 = p_xtr_party_info_rec.p_address_2
390: ,p_address_3 = p_xtr_party_info_rec.p_address_3

Line 402: ,updated_by = fnd_global.user_id

398: UPDATE XTR_PARTY_INFO
399: SET contact_name = p_xtr_party_info_rec.contact_name
400: ,country_code = p_xtr_party_info_rec.country_code
401: ,email_address = p_xtr_party_info_rec.email_address
402: ,updated_by = fnd_global.user_id
403: ,updated_on = sysdate
404: ,fax_number = p_xtr_party_info_rec.fax_number
405: ,phone_number = p_xtr_party_info_rec.phone_number
406: WHERE ce_bank_branch_id = l_ce_bank_branch_id;

Line 414: ,updated_by = fnd_global.user_id

410: SET address_2 = p_xtr_party_info_rec.address_2
411: ,address_3 = p_xtr_party_info_rec.address_3
412: ,address_4 = p_xtr_party_info_rec.address_4
413: ,address_5 = p_xtr_party_info_rec.address_5
414: ,updated_by = fnd_global.user_id
415: ,updated_on = sysdate
416: ,country_code = p_xtr_party_info_rec.country_code
417: ,state_code = p_xtr_party_info_rec.state_code
418: WHERE ce_bank_branch_id = l_ce_bank_branch_id;