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.PN_LEASE_PVT dependencies on PN_INSURANCE_REQUIREMENTS_ALL

Line 9440: l_insurance_requirement_id PN_INSURANCE_REQUIREMENTS_ALL.INSURANCE_REQUIREMENT_ID%TYPE;

9436: )
9437: IS
9438: l_index BINARY_INTEGER;
9439: l_row_id VARCHAR2(100) ;
9440: l_insurance_requirement_id PN_INSURANCE_REQUIREMENTS_ALL.INSURANCE_REQUIREMENT_ID%TYPE;
9441: l_return_status VARCHAR2(1);
9442: x_msg_count NUMBER;
9443: x_msg_data VARCHAR2(5000);
9444: BEGIN

Line 9585: l_lookup_code pn_insurance_requirements_all.insurance_type_lookup_code%TYPE;

9581: l_cur_id NUMBER;
9582: l_tbl_index BINARY_INTEGER;
9583: l_tbl_flag NUMBER := 1;
9584: l_tbl temp_tbl_type;
9585: l_lookup_code pn_insurance_requirements_all.insurance_type_lookup_code%TYPE;
9586: CURSOR c_insur (
9587: p_insurance_req_id NUMBER
9588: )
9589: IS

Line 9620: from PN_INSURANCE_REQUIREMENTS_ALL

9616: attribute14,
9617: attribute15,
9618: org_id,
9619: insurance_comments
9620: from PN_INSURANCE_REQUIREMENTS_ALL
9621: where insurance_requirement_id = l_cur_id;
9622: lcu_insur_rec c_insur%ROWTYPE;
9623: BEGIN
9624: l_return_status := fnd_api.g_ret_sts_success ;

Line 9970: l_insurance_requirement_id PN_INSURANCE_REQUIREMENTS_ALL.insurance_requirement_id%TYPE;

9966: )
9967: IS
9968: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
9969: l_index BINARY_INTEGER;
9970: l_insurance_requirement_id PN_INSURANCE_REQUIREMENTS_ALL.insurance_requirement_id%TYPE;
9971: x_msg_count NUMBER;
9972: x_msg_data VARCHAR2(5000);
9973:
9974: BEGIN