APPS.PQP_ADDRESS_SYNCHRONIZATION dependencies on PER_ADDRESSES

Line 92: l_addr_rec per_addresses%ROWTYPE;

88: --
89: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Addr_DDF_Ins';
90: l_Stu_OSSData_Sync Varchar2(5);
91: l_return_flag Boolean;
92: l_addr_rec per_addresses%ROWTYPE;
93: l_addr_rec_new per_addresses%ROWTYPE;
94: l_addr_rec_old per_addresses%ROWTYPE;
95: l_last_update_date Date;
96: l_rowid ROWID;

Line 93: l_addr_rec_new per_addresses%ROWTYPE;

89: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Addr_DDF_Ins';
90: l_Stu_OSSData_Sync Varchar2(5);
91: l_return_flag Boolean;
92: l_addr_rec per_addresses%ROWTYPE;
93: l_addr_rec_new per_addresses%ROWTYPE;
94: l_addr_rec_old per_addresses%ROWTYPE;
95: l_last_update_date Date;
96: l_rowid ROWID;
97: --

Line 94: l_addr_rec_old per_addresses%ROWTYPE;

90: l_Stu_OSSData_Sync Varchar2(5);
91: l_return_flag Boolean;
92: l_addr_rec per_addresses%ROWTYPE;
93: l_addr_rec_new per_addresses%ROWTYPE;
94: l_addr_rec_old per_addresses%ROWTYPE;
95: l_last_update_date Date;
96: l_rowid ROWID;
97: --
98: l_party_site_id Number;

Line 312: l_addr_rec_new per_addresses%ROWTYPE;

308: --
309: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Addr_DDF_Upd';
310: l_Stu_OSSData_Sync Varchar2(5);
311: l_return_flag Boolean;
312: l_addr_rec_new per_addresses%ROWTYPE;
313: l_addr_rec_old per_addresses%ROWTYPE;
314: --
315: l_party_site_id Number;
316: l_location_id Number;

Line 313: l_addr_rec_old per_addresses%ROWTYPE;

309: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Addr_DDF_Upd';
310: l_Stu_OSSData_Sync Varchar2(5);
311: l_return_flag Boolean;
312: l_addr_rec_new per_addresses%ROWTYPE;
313: l_addr_rec_old per_addresses%ROWTYPE;
314: --
315: l_party_site_id Number;
316: l_location_id Number;
317: l_location_ovn Number;