APPS.OKL_INSURANCE_POLICIES_PVT dependencies on ARP_STANDARD

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

7321: UPDATE OKL_INS_POLICIES_B IPYB
7322: SET IPYB.ISU_ID = p_to_fk_id
7323: ,IPYB.object_version_number = IPYB.object_version_number + 1
7324: ,IPYB.last_update_date = SYSDATE
7325: ,IPYB.last_updated_by = arp_standard.profile.user_id
7326: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7327: WHERE IPYB.ISU_ID = p_from_fk_id ;
7328: x_to_id := p_from_id;
7329: l_count := sql%rowcount;

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

7322: SET IPYB.ISU_ID = p_to_fk_id
7323: ,IPYB.object_version_number = IPYB.object_version_number + 1
7324: ,IPYB.last_update_date = SYSDATE
7325: ,IPYB.last_updated_by = arp_standard.profile.user_id
7326: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7327: WHERE IPYB.ISU_ID = p_from_fk_id ;
7328: x_to_id := p_from_id;
7329: l_count := sql%rowcount;
7330: arp_message.set_name('AR','AR_ROWS_UPDATED');

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

7408: UPDATE OKL_INS_POLICIES_B IPYB
7409: SET IPYB.AGENCY_SITE_ID = p_to_fk_id
7410: ,IPYB.object_version_number = IPYB.object_version_number + 1
7411: ,IPYB.last_update_date = SYSDATE
7412: ,IPYB.last_updated_by = arp_standard.profile.user_id
7413: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7414: WHERE IPYB.AGENCY_SITE_ID = p_from_fk_id ;
7415:
7416: l_count := sql%rowcount;

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

7409: SET IPYB.AGENCY_SITE_ID = p_to_fk_id
7410: ,IPYB.object_version_number = IPYB.object_version_number + 1
7411: ,IPYB.last_update_date = SYSDATE
7412: ,IPYB.last_updated_by = arp_standard.profile.user_id
7413: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7414: WHERE IPYB.AGENCY_SITE_ID = p_from_fk_id ;
7415:
7416: l_count := sql%rowcount;
7417: arp_message.set_name('AR','AR_ROWS_UPDATED');

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

7494: UPDATE OKL_INS_POLICIES_B IPYB
7495: SET IPYB.INT_ID = p_to_fk_id
7496: ,IPYB.object_version_number = IPYB.object_version_number + 1
7497: ,IPYB.last_update_date = SYSDATE
7498: ,IPYB.last_updated_by = arp_standard.profile.user_id
7499: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7500: WHERE IPYB.INT_ID = p_from_fk_id ;
7501:
7502: l_count := sql%rowcount;

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

7495: SET IPYB.INT_ID = p_to_fk_id
7496: ,IPYB.object_version_number = IPYB.object_version_number + 1
7497: ,IPYB.last_update_date = SYSDATE
7498: ,IPYB.last_updated_by = arp_standard.profile.user_id
7499: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7500: WHERE IPYB.INT_ID = p_from_fk_id ;
7501:
7502: l_count := sql%rowcount;
7503: arp_message.set_name('AR','AR_ROWS_UPDATED');

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

7579: UPDATE OKL_INS_POLICIES_B IPYB
7580: SET IPYB.AGENT_SITE_ID = p_to_fk_id
7581: ,IPYB.object_version_number = IPYB.object_version_number + 1
7582: ,IPYB.last_update_date = SYSDATE
7583: ,IPYB.last_updated_by = arp_standard.profile.user_id
7584: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7585: WHERE IPYB.AGENT_SITE_ID = p_from_fk_id ;
7586:
7587: l_count := sql%rowcount;

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

7580: SET IPYB.AGENT_SITE_ID = p_to_fk_id
7581: ,IPYB.object_version_number = IPYB.object_version_number + 1
7582: ,IPYB.last_update_date = SYSDATE
7583: ,IPYB.last_updated_by = arp_standard.profile.user_id
7584: ,IPYB.last_update_login = arp_standard.profile.last_update_login
7585: WHERE IPYB.AGENT_SITE_ID = p_from_fk_id ;
7586:
7587: l_count := sql%rowcount;
7588: arp_message.set_name('AR','AR_ROWS_UPDATED');