APPS.PSB_GL_BUDGET_PVT dependencies on PSB_GL_BUDGETS

Line 56: FROM psb_gl_budgets

52: l_api_version CONSTANT NUMBER := 1.0;
53: --
54: CURSOR C IS
55: SELECT rowid
56: FROM psb_gl_budgets
57: WHERE gl_budget_id = p_gl_budget_id ;
58:
59: CURSOR C2 IS
60: SELECT psb_gl_budgets_s.NEXTVAL

Line 60: SELECT psb_gl_budgets_s.NEXTVAL

56: FROM psb_gl_budgets
57: WHERE gl_budget_id = p_gl_budget_id ;
58:
59: CURSOR C2 IS
60: SELECT psb_gl_budgets_s.NEXTVAL
61: FROM dual ;
62: --
63: BEGIN
64: --

Line 89: INSERT INTO psb_gl_budgets

85: FETCH C2 INTO p_gl_budget_id ;
86: CLOSE C2 ;
87: END IF;
88:
89: INSERT INTO psb_gl_budgets
90: (
91: gl_budget_id ,
92: gl_budget_set_id ,
93: gl_budget_version_id ,

Line 204: FROM psb_gl_budgets

200: --
201: Counter NUMBER;
202: CURSOR C IS
203: SELECT *
204: FROM psb_gl_budgets
205: WHERE rowid = p_row_id
206: FOR UPDATE OF gl_budget_id NOWAIT;
207: --
208: Recinfo C%ROWTYPE;

Line 381: UPDATE psb_gl_budgets

377: --
378: p_return_status := FND_API.G_RET_STS_SUCCESS ;
379: --
380:
381: UPDATE psb_gl_budgets
382: SET gl_budget_set_id = p_gl_budget_set_id ,
383: gl_budget_version_id = p_gl_budget_version_id ,
384: start_period = p_start_period ,
385: end_period = p_end_period ,

Line 464: l_gl_budget_id psb_gl_budgets.gl_budget_id%TYPE;

460: l_return_status VARCHAR2(1) ;
461: l_msg_count NUMBER ;
462: l_msg_data VARCHAR2(2000) ;
463: --
464: l_gl_budget_id psb_gl_budgets.gl_budget_id%TYPE;
465: --
466: BEGIN
467: --
468: SAVEPOINT Delete_Row_Pvt ;

Line 496: FROM psb_gl_budgets

492: -- First delete all the set related information.
493: --
494:
495: SELECT gl_budget_id INTO l_gl_budget_id
496: FROM psb_gl_budgets
497: WHERE rowid = p_row_id ;
498:
499: PSB_Set_Relation_PVT.Delete_Entity_Relation
500: (

Line 522: -- Deleting the record in psb_gl_budgets.

518: -- End deleting set related information.
519: --
520:
521: --
522: -- Deleting the record in psb_gl_budgets.
523: --
524: DELETE psb_gl_budgets
525: WHERE rowid = p_row_id;
526:

Line 524: DELETE psb_gl_budgets

520:
521: --
522: -- Deleting the record in psb_gl_budgets.
523: --
524: DELETE psb_gl_budgets
525: WHERE rowid = p_row_id;
526:
527: IF (SQL%NOTFOUND) THEN
528: RAISE NO_DATA_FOUND ;

Line 604: c_gl_budget_id psb_gl_budgets.gl_budget_id%TYPE ,

600: l_api_version CONSTANT NUMBER := 1.0 ;
601: --
602: CURSOR l_find_ccid_csr
603: (
604: c_gl_budget_id psb_gl_budgets.gl_budget_id%TYPE ,
605: c_code_combination_id psb_budget_accounts.code_combination_id%TYPE
606: )
607: IS
608: SELECT '1'

Line 688: FROM psb_gl_budgets

684: FOR l_gl_budget_rec IN
685: (
686: SELECT gl_budget_id ,
687: gl_budget_version_id
688: FROM psb_gl_budgets
689: WHERE gl_budget_set_id = p_gl_budget_set_id
690: AND p_start_date BETWEEN start_date AND end_date
691: AND NVL( dual_posting_type, 'P' ) = l_dual_posting_type
692: