APPS.ARH_ADDR_PKG dependencies on ARH_CSU_PKG

Line 394: -- This procedure calls arh_csu_pkg.insert_row to create a site use for

390: -- PROCEDURE
391: -- insert_site_use
392: --
393: -- DESCRIPTION
394: -- This procedure calls arh_csu_pkg.insert_row to create a site use for
395: -- an address
396: --
397: -- SCOPE - PRIVATE
398: --

Line 429: arh_csu_pkg.insert_row(

425: --
426: begin
427: --
428: --
429: arh_csu_pkg.insert_row(
430: X_Site_Use_Id => l_site_use_id,
431: X_Last_Update_Date => sysdate,
432: x_Last_Updated_By => fnd_global.user_id,
433: X_Creation_Date => sysdate,

Line 567: -- to arh_csu_pkg.update_su_status .

563: -- MODIFICATION HISTORY - Created by Kevin Hudson
564: --
565: -- 07/25/01 Suresh P Bug No : 1348423 Changed the call
566: -- from arp_csu_pkg.update_su_status
567: -- to arh_csu_pkg.update_su_status .
568:
569: Procedure manage_site_use ( p_customer_id in number,
570: p_address_id in number,
571: p_site_use_flag in varchar2,

Line 581: arh_csu_pkg.site_use_exists( p_address_id => p_address_id,

577: l_site_use_id number;
578: l_site_use_status varchar2(1);
579: begin
580: --
581: arh_csu_pkg.site_use_exists( p_address_id => p_address_id,
582: p_site_use_code => p_site_use_code,
583: p_site_use_id => l_site_use_id,
584: p_site_use_status => l_site_use_status,
585: x_msg_count => x_msg_count,

Line 600: arh_csu_pkg.update_su_status(p_customer_id => p_customer_id,

596: if ( l_site_use_status = 'A') then
597: null;
598: elsif ( l_site_use_status = 'I') then
599: -- Bug Fix : 1348423
600: arh_csu_pkg.update_su_status(p_customer_id => p_customer_id,
601: p_address_id => p_address_id,
602: p_site_use_id => l_site_use_id,
603: p_site_use_code => p_site_use_code,
604: p_status =>'A');

Line 616: arh_csu_pkg.update_su_status(p_customer_id => p_customer_id,

612: --
613: elsif ( p_site_use_flag = 'N' ) then
614: if ( l_site_use_status = 'A' ) then
615: -- Bug Fix : 1348423
616: arh_csu_pkg.update_su_status(p_customer_id => p_customer_id,
617: p_address_id => p_address_id,
618: p_site_use_id => l_site_use_id,
619: p_site_use_code => p_site_use_code,
620: p_status => 'I');