APPS.PSB_GL_BUDGET_SET_PVT dependencies on PSB_GL_BUDGET_SETS

Line 62: FROM psb_gl_budget_sets

58: l_api_version CONSTANT NUMBER := 1.0;
59: --
60: CURSOR C IS
61: SELECT rowid
62: FROM psb_gl_budget_sets
63: WHERE gl_budget_set_id = p_gl_budget_set_id ;
64:
65: CURSOR C2 IS
66: SELECT psb_gl_budget_sets_s.NEXTVAL

Line 66: SELECT psb_gl_budget_sets_s.NEXTVAL

62: FROM psb_gl_budget_sets
63: WHERE gl_budget_set_id = p_gl_budget_set_id ;
64:
65: CURSOR C2 IS
66: SELECT psb_gl_budget_sets_s.NEXTVAL
67: FROM dual ;
68: --
69: BEGIN
70: --

Line 96: INSERT INTO psb_gl_budget_sets

92: FETCH C2 INTO p_gl_budget_set_id ;
93: CLOSE C2;
94: END IF;
95:
96: INSERT INTO psb_gl_budget_sets
97: (
98: gl_budget_set_id ,
99: gl_budget_set_name ,
100: set_of_books_id ,

Line 229: FROM psb_gl_budget_sets

225: --
226: Counter NUMBER;
227: CURSOR C IS
228: SELECT *
229: FROM psb_gl_budget_sets
230: WHERE rowid = p_row_id
231: FOR UPDATE of gl_budget_set_id NOWAIT;
232: Recinfo C%ROWTYPE;
233: --

Line 434: UPDATE psb_gl_budget_sets

430: --
431: p_return_status := FND_API.G_RET_STS_SUCCESS ;
432: --
433:
434: UPDATE psb_gl_budget_sets
435: SET gl_budget_set_name = p_gl_budget_set_name ,
436: set_of_books_id = p_set_of_books_id ,
437: last_update_date = p_last_update_date ,
438: last_updated_by = p_last_updated_by ,

Line 523: l_gl_budget_set_id psb_gl_budget_sets.gl_budget_set_id%TYPE;

519: l_return_status VARCHAR2(1) ;
520: l_msg_count NUMBER ;
521: l_msg_data VARCHAR2(2000) ;
522: --
523: l_gl_budget_set_id psb_gl_budget_sets.gl_budget_set_id%TYPE;
524: --
525: BEGIN
526: --
527: SAVEPOINT Delete_Row_Pvt ;

Line 551: FROM psb_gl_budget_sets

547: -- ( To maintain ISOLATED master-detail form relation also. )
548: --
549:
550: SELECT gl_budget_set_id INTO l_gl_budget_set_id
551: FROM psb_gl_budget_sets
552: WHERE rowid = p_row_id ;
553:
554: --
555: -- Delete all the related GL Budgets and associated set information.

Line 588: -- Deleting the record in psb_gl_budget_sets.

584: -- End deleting GL Budgets related information.
585: --
586:
587:
588: -- Deleting the record in psb_gl_budget_sets.
589: DELETE psb_gl_budget_sets
590: WHERE rowid = p_row_id;
591:
592: IF (SQL%NOTFOUND) THEN

Line 589: DELETE psb_gl_budget_sets

585: --
586:
587:
588: -- Deleting the record in psb_gl_budget_sets.
589: DELETE psb_gl_budget_sets
590: WHERE rowid = p_row_id;
591:
592: IF (SQL%NOTFOUND) THEN
593: RAISE NO_DATA_FOUND ;

Line 665: FROM psb_gl_budget_sets

661: l_tmp VARCHAR2(1);
662: --
663: CURSOR c IS
664: SELECT '1'
665: FROM psb_gl_budget_sets
666: WHERE gl_budget_set_name = p_gl_budget_set_name
667: AND set_of_books_id = p_set_of_books_id
668: AND (
669: p_row_id IS NULL

Line 773: l_gl_budget_set_id psb_gl_budget_sets.gl_budget_set_id%TYPE;

769: l_return_status VARCHAR2(1) ;
770: l_msg_count NUMBER ;
771: l_msg_data VARCHAR2(2000) ;
772: --
773: l_gl_budget_set_id psb_gl_budget_sets.gl_budget_set_id%TYPE;
774: l_start_date DATE ;
775: l_end_date DATE ;
776: --
777: l_first_time_flag VARCHAR2(1) ;