APPS.OKL_INSURANCE_POLICIES_PVT dependencies on ARP_STANDARD

Line 7332: ,IPYB.last_updated_by = arp_standard.profile.user_id

7328: UPDATE OKL_INS_POLICIES_B IPYB
7329: SET IPYB.ISU_ID = p_to_fk_id
7330: ,IPYB.object_version_number = IPYB.object_version_number + 1
7331: ,IPYB.last_update_date = SYSDATE
7332: ,IPYB.last_updated_by = arp_standard.profile.user_id
7333: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7334: WHERE IPYB.ISU_ID = p_from_fk_id ;
7335: x_to_id := p_from_id;
7336: l_count := sql%rowcount;

Line 7333: ,IPYB.last_update_login = arp_standard.profile.last_update_login

7329: SET IPYB.ISU_ID = p_to_fk_id
7330: ,IPYB.object_version_number = IPYB.object_version_number + 1
7331: ,IPYB.last_update_date = SYSDATE
7332: ,IPYB.last_updated_by = arp_standard.profile.user_id
7333: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7334: WHERE IPYB.ISU_ID = p_from_fk_id ;
7335: x_to_id := p_from_id;
7336: l_count := sql%rowcount;
7337: arp_message.set_name('AR','AR_ROWS_UPDATED');

Line 7419: ,IPYB.last_updated_by = arp_standard.profile.user_id

7415: UPDATE OKL_INS_POLICIES_B IPYB
7416: SET IPYB.AGENCY_SITE_ID = p_to_fk_id
7417: ,IPYB.object_version_number = IPYB.object_version_number + 1
7418: ,IPYB.last_update_date = SYSDATE
7419: ,IPYB.last_updated_by = arp_standard.profile.user_id
7420: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7421: WHERE IPYB.AGENCY_SITE_ID = p_from_fk_id ;
7422:
7423: l_count := sql%rowcount;

Line 7420: ,IPYB.last_update_login = arp_standard.profile.last_update_login

7416: SET IPYB.AGENCY_SITE_ID = p_to_fk_id
7417: ,IPYB.object_version_number = IPYB.object_version_number + 1
7418: ,IPYB.last_update_date = SYSDATE
7419: ,IPYB.last_updated_by = arp_standard.profile.user_id
7420: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7421: WHERE IPYB.AGENCY_SITE_ID = p_from_fk_id ;
7422:
7423: l_count := sql%rowcount;
7424: arp_message.set_name('AR','AR_ROWS_UPDATED');

Line 7505: ,IPYB.last_updated_by = arp_standard.profile.user_id

7501: UPDATE OKL_INS_POLICIES_B IPYB
7502: SET IPYB.INT_ID = p_to_fk_id
7503: ,IPYB.object_version_number = IPYB.object_version_number + 1
7504: ,IPYB.last_update_date = SYSDATE
7505: ,IPYB.last_updated_by = arp_standard.profile.user_id
7506: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7507: WHERE IPYB.INT_ID = p_from_fk_id ;
7508:
7509: l_count := sql%rowcount;

Line 7506: ,IPYB.last_update_login = arp_standard.profile.last_update_login

7502: SET IPYB.INT_ID = p_to_fk_id
7503: ,IPYB.object_version_number = IPYB.object_version_number + 1
7504: ,IPYB.last_update_date = SYSDATE
7505: ,IPYB.last_updated_by = arp_standard.profile.user_id
7506: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7507: WHERE IPYB.INT_ID = p_from_fk_id ;
7508:
7509: l_count := sql%rowcount;
7510: arp_message.set_name('AR','AR_ROWS_UPDATED');

Line 7590: ,IPYB.last_updated_by = arp_standard.profile.user_id

7586: UPDATE OKL_INS_POLICIES_B IPYB
7587: SET IPYB.AGENT_SITE_ID = p_to_fk_id
7588: ,IPYB.object_version_number = IPYB.object_version_number + 1
7589: ,IPYB.last_update_date = SYSDATE
7590: ,IPYB.last_updated_by = arp_standard.profile.user_id
7591: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7592: WHERE IPYB.AGENT_SITE_ID = p_from_fk_id ;
7593:
7594: l_count := sql%rowcount;

Line 7591: ,IPYB.last_update_login = arp_standard.profile.last_update_login

7587: SET IPYB.AGENT_SITE_ID = p_to_fk_id
7588: ,IPYB.object_version_number = IPYB.object_version_number + 1
7589: ,IPYB.last_update_date = SYSDATE
7590: ,IPYB.last_updated_by = arp_standard.profile.user_id
7591: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7592: WHERE IPYB.AGENT_SITE_ID = p_from_fk_id ;
7593:
7594: l_count := sql%rowcount;
7595: arp_message.set_name('AR','AR_ROWS_UPDATED');