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: END IF;
915:

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