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_LANDLORD_SERVICES_ALL

Line 7560: ----------------------dbms_output.put_line ('INSERT ROW INTO PN_LANDLORD_SERVICES_ALL STARTED FOR OBLIGATIONS');--Rupak

7556: for l_index in p_obligation_tbl.FIRST..p_obligation_tbl.LAST LOOP
7557: --l_index := 1;
7558: ----------------------dbms_output.put_line('In OBLIGATION_INSERT_ROW:p_obligation_tblIN FOR OUTSIDE IF'||p_obligation_tbl(l_index).temp_flag);--Rupak
7559: IF p_tbl(l_index).temp_flag = 1 THEN
7560: ----------------------dbms_output.put_line ('INSERT ROW INTO PN_LANDLORD_SERVICES_ALL STARTED FOR OBLIGATIONS');--Rupak
7561: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Calling PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);
7562: l_landlord_service_id := NULL;
7563: PN_LANDLORD_SERVICES_PKG.insert_row(
7564: X_ROWID => l_row_id,

Line 7679: l_landlord_service_id PN_LANDLORD_SERVICES_ALL.LANDLORD_SERVICE_ID%TYPE;

7675: IS
7676: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7677: l_index BINARY_INTEGER;
7678: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
7679: l_landlord_service_id PN_LANDLORD_SERVICES_ALL.LANDLORD_SERVICE_ID%TYPE;
7680: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
7681: l_company_id PN_LANDLORD_SERVICES_ALL.company_id%type ;
7682: l_cur_id NUMBER;
7683: l_tbl_index BINARY_INTEGER;

Line 7681: l_company_id PN_LANDLORD_SERVICES_ALL.company_id%type ;

7677: l_index BINARY_INTEGER;
7678: l_lookup_meaning FND_LOOKUPS.MEANING%TYPE;
7679: l_landlord_service_id PN_LANDLORD_SERVICES_ALL.LANDLORD_SERVICE_ID%TYPE;
7680: l_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE;
7681: l_company_id PN_LANDLORD_SERVICES_ALL.company_id%type ;
7682: l_cur_id NUMBER;
7683: l_tbl_index BINARY_INTEGER;
7684: l_tbl_flag NUMBER;
7685: l_tbl temp_tbl_type;

Line 7724: FROM pn_landlord_services_all

7720: , attribute12
7721: , attribute13
7722: , attribute14
7723: , attribute15
7724: FROM pn_landlord_services_all
7725: WHERE landlord_service_id = p_landlord_service_id;
7726: lcu_oblg_rec c_oblg%ROWTYPE;
7727: BEGIN
7728: l_return_status := fnd_api.g_ret_sts_success ;

Line 8117: l_landlord_service_id pn_landlord_services_all.LANDLORD_SERVICE_ID%TYPE;

8113: )
8114: IS
8115: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8116: l_index BINARY_INTEGER;
8117: l_landlord_service_id pn_landlord_services_all.LANDLORD_SERVICE_ID%TYPE;
8118: l_err_obg_count NUMBER:=0;
8119:
8120: BEGIN
8121: pvt_debug(g_pkg_name||'-Inside OBLIGATION_UPDATE_ROW',3);