APPS.PN_LEASE_PVT dependencies on PN_NOTE_DETAILS_PKG

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 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