eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PSB_SUBMIT_WORKSHEET_PVT dependencies on PSB_BUDGET_GROUPS

Line 13: g_budget_group_name psb_budget_groups.name%TYPE ;

9: -- CALLBACK procedure related global information.
10: --
11: g_worksheet_id psb_worksheets.worksheet_id%TYPE ;
12: g_worksheet_name psb_worksheets.name%TYPE ;
13: g_budget_group_name psb_budget_groups.name%TYPE ;
14: g_itemtype VARCHAR2(2000) ;
15: g_itemkey VARCHAR2(2000) ;
16:
17: -- WHO columns variables

Line 223: l_budget_group_name psb_budget_groups.name%TYPE ;

219: IS
220: --
221: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
222: l_worksheet_name psb_worksheets.name%TYPE ;
223: l_budget_group_name psb_budget_groups.name%TYPE ;
224: l_submitter_name VARCHAR2(80);
225: --
226: l_orig_system VARCHAR2(8) ;
227: l_submitter_id NUMBER ;

Line 1038: FROM psb_budget_groups bg ,

1034: --
1035: FOR l_role_rec IN
1036: (
1037: SELECT wf_role_name
1038: FROM psb_budget_groups bg ,
1039: psb_budget_group_resp resp
1040: WHERE resp.responsibility_type = 'N'
1041: AND bg.budget_group_id = l_budget_group_id
1042: AND bg.budget_group_id = resp.budget_group_id

Line 1501: FROM psb_budget_groups bg ,

1497: --
1498: FOR l_role_rec IN
1499: (
1500: SELECT wf_role_name
1501: FROM psb_budget_groups bg ,
1502: psb_budget_group_resp resp
1503: WHERE resp.responsibility_type = 'N'
1504: AND bg.budget_group_id = l_budget_group_id
1505: AND bg.budget_group_id = resp.budget_group_id

Line 1637: l_root_budget_group_id psb_budget_groups.root_budget_group_id%TYPE ;

1633: --
1634: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
1635: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
1636: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
1637: l_root_budget_group_id psb_budget_groups.root_budget_group_id%TYPE ;
1638: l_count NUMBER ;
1639: --
1640: BEGIN
1641: --

Line 1663: psb_budget_groups bg

1659: l_budget_group_id ,
1660: l_budget_calendar_id ,
1661: l_root_budget_group_id
1662: FROM psb_worksheets ws ,
1663: psb_budget_groups bg
1664: WHERE worksheet_id = l_worksheet_id
1665: AND ws.budget_group_id = bg.budget_group_id ;
1666:
1667:

Line 1698: psb_budget_groups bg

1694: ( item_key, budget_workflow_rule_id, sequence )
1695: SELECT itemkey, rules.budget_workflow_rule_id, ROWNUM
1696: FROM psb_budget_group_categories cats ,
1697: psb_budget_workflow_rules rules ,
1698: psb_budget_groups bg
1699: WHERE cats.budget_group_id = l_budget_group_id
1700: AND rules.budget_group_id = l_root_budget_group_id
1701: AND rules.stage_id = cats.stage_id
1702: AND bg.budget_group_id = rules.review_budget_group_id

Line 1896: FROM psb_budget_groups

1892: --
1893: -- Get the current review group name to update 'REVIEW_GROUP_NAME' attribute.
1894: --
1895: SELECT name INTO l_review_budget_group_name
1896: FROM psb_budget_groups
1897: WHERE budget_group_id = l_review_budget_group_id ;
1898:
1899: --
1900: -- Update 'LOOP_VISITED_COUNTER', 'APPROVAL_OPTION' and

Line 2018: FROM psb_budget_groups bg ,

2014: WHERE worksheet_id = l_new_worksheet_id ;
2015:
2016: -- Find approvers for the current review group.
2017: SELECT wf_role_name INTO l_review_group_approver_name
2018: FROM psb_budget_groups bg ,
2019: psb_budget_group_resp resp
2020: WHERE resp.responsibility_type = 'N'
2021: AND bg.budget_group_id = l_review_budget_group_id
2022: AND bg.budget_group_id = resp.budget_group_id

Line 2522: psb_budget_groups bg

2518: SELECT bg.parent_budget_group_id
2519: INTO
2520: l_parent_budget_group_id
2521: FROM psb_worksheets ws,
2522: psb_budget_groups bg
2523: WHERE ws.worksheet_id = l_worksheet_id
2524: AND ws.budget_group_id = bg.budget_group_id ;
2525:
2526:

Line 2530: FROM psb_budget_groups bg ,

2526:
2527: FOR l_role_rec IN
2528: (
2529: SELECT wf_role_name
2530: FROM psb_budget_groups bg ,
2531: psb_budget_group_resp resp
2532: WHERE bg.budget_group_id = l_parent_budget_group_id
2533: AND resp.responsibility_type = 'N'
2534: AND bg.budget_group_id = resp.budget_group_id

Line 2774: l_root_budget_group_id psb_budget_groups.root_budget_group_id%TYPE ;

2770: l_msg_data VARCHAR2(2000) ;
2771: --
2772: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
2773: l_budget_calendar_id psb_worksheets.budget_calendar_id%TYPE ;
2774: l_root_budget_group_id psb_budget_groups.root_budget_group_id%TYPE ;
2775: l_count NUMBER ;
2776: --
2777: l_exists VARCHAR2(10);
2778:

Line 2812: psb_budget_groups bg

2808: l_budget_group_id ,
2809: l_budget_calendar_id ,
2810: l_root_budget_group_id
2811: FROM psb_worksheets ws ,
2812: psb_budget_groups bg
2813: WHERE worksheet_id = p_worksheet_id
2814: AND ws.budget_group_id = bg.budget_group_id ;
2815:
2816: l_count := 0 ;

Line 2851: psb_budget_groups bg,

2847: WHERE EXISTS
2848: (SELECT 1
2849: FROM psb_budget_group_categories cats,
2850: psb_budget_workflow_rules rules,
2851: psb_budget_groups bg,
2852: psb_set_relations relations,
2853: psb_budget_accounts ba
2854: WHERE cats.budget_group_id = l_budget_group_id
2855: AND rules.budget_group_id = l_root_budget_group_id

Line 2900: psb_budget_groups bg,

2896: WHERE EXISTS
2897: (SELECT 1
2898: FROM psb_budget_group_categories cats,
2899: psb_budget_workflow_rules rules,
2900: psb_budget_groups bg,
2901: psb_set_relations relations,
2902: psb_budget_positions bp
2903: WHERE cats.budget_group_id = l_budget_group_id
2904: AND rules.budget_group_id = l_root_budget_group_id

Line 2942: PSB_BUDGET_GROUPS bgrp

2938: WHERE EXISTS
2939: (SELECT 1
2940: FROM PSB_BUDGET_GROUP_CATEGORIES cats,
2941: PSB_BUDGET_WORKFLOW_RULES rules,
2942: PSB_BUDGET_GROUPS bgrp
2943: WHERE cats.budget_group_id = l_budget_group_id
2944: AND rules.stage_id = cats.stage_id
2945: AND rules.budget_group_id = l_root_budget_group_id
2946: AND bgrp.budget_group_id = rules.review_budget_group_id