APPS.PSB_WORKSHEET_CONSOLIDATE_PVT dependencies on PSB_WS_CONSOLIDATION_DETAILS

Line 209: FROM psb_ws_consolidation_details

205: l_api_version CONSTANT NUMBER := 1.0;
206:
207: CURSOR C IS
208: SELECT rowid
209: FROM psb_ws_consolidation_details
210: WHERE global_worksheet_id = p_global_worksheet_id
211: AND local_worksheet_id = p_local_worksheet_id;
212:
213: BEGIN

Line 232: INSERT INTO psb_ws_consolidation_details(

228: END IF;
229:
230: p_return_status := FND_API.G_RET_STS_SUCCESS ;
231:
232: INSERT INTO psb_ws_consolidation_details(
233: global_worksheet_id,
234: local_worksheet_id,
235: last_update_date ,
236: last_updated_by,

Line 355: FROM psb_ws_consolidation_details

351:
352: Counter NUMBER;
353: CURSOR C IS
354: SELECT *
355: FROM psb_ws_consolidation_details
356: WHERE rowid = p_row_id
357: FOR UPDATE NOWAIT;
358: Recinfo C%ROWTYPE;
359:

Line 548: UPDATE psb_ws_consolidation_details

544:
545: p_return_status := FND_API.G_RET_STS_SUCCESS ;
546:
547:
548: UPDATE psb_ws_consolidation_details
549: SET
550: global_worksheet_id = p_global_worksheet_id ,
551: local_worksheet_id = p_local_worksheet_id ,
552: last_update_date = p_last_update_date ,

Line 653: DELETE FROM psb_ws_consolidation_details

649:
650: p_return_status := FND_API.G_RET_STS_SUCCESS ;
651:
652:
653: DELETE FROM psb_ws_consolidation_details
654: WHERE rowid = p_row_id;
655:
656: IF (SQL%NOTFOUND) THEN
657: RAISE NO_DATA_FOUND ;

Line 724: FROM psb_ws_consolidation_details

720: l_tmp VARCHAR2(1);
721:
722: CURSOR c IS
723: SELECT '1'
724: FROM psb_ws_consolidation_details
725: WHERE global_worksheet_id = p_global_worksheet_id
726: AND local_worksheet_id = p_local_worksheet_id;
727:
728: BEGIN