APPS.PN_LEASE_PVT dependencies on PN_NOTE_DETAILS

Line 5697: l_note_detail_id PN_NOTE_DETAILS.NOTE_DETAIL_ID%TYPE;

5693: l_hdr_row_id VARCHAR2(100) ;
5694: l_dt_row_id VARCHAR2(100) ;
5695: l_note_header_tbl lease_note_tbl_type := p_note_tbl;
5696: l_note_header_id PN_NOTE_HEADERS.NOTE_HEADER_ID%TYPE;
5697: l_note_detail_id PN_NOTE_DETAILS.NOTE_DETAIL_ID%TYPE;
5698: BEGIN
5699: ----------------------dbms_output.put_line('PVT INSERT PROCEDURE FOR NOTE HEADER:STARTING'||p_note_tbl(1).note_date);--Rupak
5700: pvt_debug(g_pkg_name||'-Inside NOTE_INSERT_ROW',3);
5701: for l_index in p_note_tbl.FIRST..p_note_tbl.LAST LOOP

Line 5743: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:Calling PN_NOTE_DETAILS_PKG.INSERT_ROW',3);

5739: ----------------------dbms_output.put_line('NOTE HEADER CREATED WITH NOTE HEADER ID: '||l_note_header_id);--Rupak
5740: l_note_header_tbl(l_index).note_header_id := l_note_header_id;
5741: l_note_detail_id := NULL;
5742: IF l_note_header_tbl(l_index).text IS NOT NULL OR l_note_header_tbl(l_index).text <> pn_lease_utils.g_pn_miss_char THEN
5743: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:Calling PN_NOTE_DETAILS_PKG.INSERT_ROW',3);
5744: ------------------dbms_output.put_line('Inside Details'||l_note_header_tbl(l_index).note_header_id);--OOPS
5745:
5746: pn_note_details_pkg.insert_row (
5747: x_rowid => l_dt_row_id

Line 5746: pn_note_details_pkg.insert_row (

5742: IF l_note_header_tbl(l_index).text IS NOT NULL OR l_note_header_tbl(l_index).text <> pn_lease_utils.g_pn_miss_char THEN
5743: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:Calling PN_NOTE_DETAILS_PKG.INSERT_ROW',3);
5744: ------------------dbms_output.put_line('Inside Details'||l_note_header_tbl(l_index).note_header_id);--OOPS
5745:
5746: pn_note_details_pkg.insert_row (
5747: x_rowid => l_dt_row_id
5748: , x_note_detail_id => l_note_detail_id
5749: , x_note_header_id => l_note_header_tbl(l_index).note_header_id
5750: , x_text => l_note_header_tbl(l_index).text

Line 5758: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:PN_NOTE_DETAILS_PKG.INSERT_ROW Succesful',3);

5754: , x_last_updated_by => fnd_global.user_id
5755: , x_last_update_login => fnd_global.user_id
5756: );
5757:
5758: pvt_debug(g_pkg_name||'-NOTE_INSERT_ROW:PN_NOTE_DETAILS_PKG.INSERT_ROW Succesful',3);
5759: ------------------dbms_output.put_line('After calling note details'||l_note_detail_id);
5760: IF l_note_detail_id IS NOT NULL THEN
5761: l_note_header_tbl(l_index).note_detail_id := l_note_detail_id;
5762: ------------------dbms_output.put_line('NOTE DETAIL CREATED');

Line 6093: l_note_detail_id PN_NOTE_DETAILS.NOTE_DETAIL_ID%TYPE;

6089: IS
6090: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
6091: l_index BINARY_INTEGER;
6092: l_dt_row_id VARCHAR2(100);
6093: l_note_detail_id PN_NOTE_DETAILS.NOTE_DETAIL_ID%TYPE;
6094: l_err_note_count NUMBER:=0;
6095: l_flag VARCHAR(1) := 'N';
6096: BEGIN
6097: ----------------dbms_output.put_line('IN UPDATE NOTE:0');

Line 6140: FROM pn_note_details

6136: IF (p_note_tbl(l_index).note_detail_id IS NULL OR p_note_tbl(l_index).note_detail_id = pn_lease_utils.g_pn_miss_num) THEN
6137: BEGIN
6138: SELECT note_detail_id
6139: INTO p_note_tbl(l_index).note_detail_id
6140: FROM pn_note_details
6141: WHERE note_header_id = p_note_tbl(l_index).note_header_id
6142: AND LANGUAGE = 'US';--userenv('lang');
6143: ----------------dbms_output.put_line('Note Details:'||p_note_tbl(l_index).note_detail_id);
6144: EXCEPTION

Line 6157: pn_note_details_pkg.update_row (

6153: OR(p_note_tbl(l_index).text IS NOT NULL OR p_note_tbl(l_index).text <> pn_lease_utils.g_pn_miss_char )
6154: )
6155: THEN
6156: ----------------------dbms_output.put_line('NOTE DETAIL update');--Rupak
6157: pn_note_details_pkg.update_row (
6158: x_note_detail_id => p_note_tbl(l_index).note_detail_id
6159: , x_text => p_note_tbl(l_index).text
6160: , x_last_update_date => sysdate
6161: , x_last_updated_by => fnd_global.user_id

Line 6177: pn_note_details_pkg.insert_row (

6173: )
6174: THEN
6175: l_note_detail_id := NULL;
6176: ----------------------dbms_output.put_line('NOTE DETAIL INSERT:');--Rupak
6177: pn_note_details_pkg.insert_row (
6178: x_rowid => l_dt_row_id
6179: , x_note_detail_id => l_note_detail_id
6180: , x_note_header_id => p_note_tbl(l_index).note_header_id
6181: , x_text => p_note_tbl(l_index).text

Line 6193: pvt_debug(g_pkg_name||'-NOTE_UPDATE_ROW:PN_NOTE_DETAILS_PKG.INSERT_ROW Succesful'||l_note_detail_id,3);

6189: IF (l_flag = 'Y') THEN
6190: x_return_status:=fnd_api.g_ret_sts_success;
6191: END IF;
6192: ----------------------dbms_output.put_line('NOTE DETAIL CREATED WITH NOTE DETAIL ID :'||l_note_detail_id);--Rupak
6193: pvt_debug(g_pkg_name||'-NOTE_UPDATE_ROW:PN_NOTE_DETAILS_PKG.INSERT_ROW Succesful'||l_note_detail_id,3);
6194: END IF;
6195: END IF;
6196: EXCEPTION
6197: WHEN OTHERS THEN