eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on STANDARD

Line 588: l_tapv_rec.INVOICE_TYPE := 'STANDARD';

584: END if ;
585: CLOSE C_CURRENCY;
586:
587: l_tapv_rec.TAP_ID_REVERSES := OKC_API.G_MISS_NUM ;
588: l_tapv_rec.INVOICE_TYPE := 'STANDARD';
589: -- GET SET OF BOOK
590: l_tapv_rec.SET_OF_BOOKS_ID := OKL_ACCOUNTING_UTIL.get_set_of_books_id; --smoduga fix for bug 4238141
591:
592: END IF;

Line 911: l_tapv_rec.INVOICE_TYPE := 'STANDARD';

907: RAISE OKC_API.G_EXCEPTION_ERROR;
908: END if ;
909: CLOSE C_CURRENCY;
910: l_tapv_rec.TAP_ID_REVERSES := OKC_API.G_MISS_NUM ;
911: l_tapv_rec.INVOICE_TYPE := 'STANDARD';
912: -- GET SET OF BOOK
913: l_tapv_rec.SET_OF_BOOKS_ID := OKL_ACCOUNTING_UTIL.get_set_of_books_id; --smoduga fix for bug 4238141
914:
915: --Fix for bug#13433145 Start

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');