APPS.PSB_BUDGET_GROUPS_PVT dependencies on PSB_BUDGET_GROUP_CATEGORIES

Line 2606: delete psb_budget_group_categories where budget_group_id = c1rec.budget_group_id;

2602: delete psb_set_relations where budget_group_id = c1rec.budget_group_id;
2603: if (sql%notfound) then
2604: null;
2605: end if;
2606: delete psb_budget_group_categories where budget_group_id = c1rec.budget_group_id;
2607: if (sql%notfound) then
2608: null;
2609: end if;
2610: end loop;

Line 2621: delete psb_budget_group_categories where budget_group_id = p_budget_group_id;

2617: delete psb_set_relations where budget_group_id = p_budget_group_id;
2618: if (sql%notfound) then
2619: null;
2620: end if;
2621: delete psb_budget_group_categories where budget_group_id = p_budget_group_id;
2622: if (sql%notfound) then
2623: null;
2624: end if;
2625:

Line 2798: from psb_budget_group_categories

2794:
2795:
2796: Cursor BG_WF_Cur Is
2797: select stage_id
2798: from psb_budget_group_categories
2799: where budget_group_id = p_src_budget_group_id;
2800:
2801: Bgwf_Rec BG_WF_Cur%ROWTYPE;
2802:

Line 3047: select psb_budget_group_categories_s.NEXTVAL

3043:
3044: if BG_WF_Cur%NOTFOUND then
3045: EXIT;
3046: else
3047: select psb_budget_group_categories_s.NEXTVAL
3048: Into l_budget_group_category_id from DUAL ;
3049:
3050: Insert into psb_budget_group_categories
3051: ( budget_group_category_id ,

Line 3050: Insert into psb_budget_group_categories

3046: else
3047: select psb_budget_group_categories_s.NEXTVAL
3048: Into l_budget_group_category_id from DUAL ;
3049:
3050: Insert into psb_budget_group_categories
3051: ( budget_group_category_id ,
3052: budget_group_id ,
3053: stage_id ,
3054: last_updated_date ,