APPS.PSB_WORKFLOW_PVT dependencies on PSB_BUDGET_GROUP_RESP

Line 405: l_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;

401: l_msg_index_out NUMBER;
402: --
403: l_worksheet_id psb_worksheets.worksheet_id%TYPE ;
404: l_budget_group_id psb_worksheets.budget_group_id%TYPE ;
405: l_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
406: --
407: l_lock_worksheet_id psb_worksheets.worksheet_id%TYPE ;
408: l_tmp_number NUMBER ;
409: l_item_key VARCHAR2(240) ;

Line 489: psb_budget_group_resp resp

485: -- Find budget_group users information.
486: --
487: SELECT min(wf_role_name) INTO l_wf_role_name
488: FROM psb_budget_groups bg ,
489: psb_budget_group_resp resp
490: WHERE bg.budget_group_id = l_budget_group_id
491: AND resp.responsibility_type = 'N'
492: AND bg.budget_group_id = resp.budget_group_id ;
493:

Line 596: l_dist_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;

592: )
593: IS
594: --
595: l_child_worksheet_id psb_worksheets.worksheet_id%TYPE ;
596: l_dist_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
597: l_budget_group_resp_id psb_budget_group_resp.budget_group_resp_id%TYPE;
598: l_return_status VARCHAR2(1) ;
599: l_msg_count NUMBER ;
600: l_msg_data VARCHAR2(2000) ;

Line 597: l_budget_group_resp_id psb_budget_group_resp.budget_group_resp_id%TYPE;

593: IS
594: --
595: l_child_worksheet_id psb_worksheets.worksheet_id%TYPE ;
596: l_dist_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
597: l_budget_group_resp_id psb_budget_group_resp.budget_group_resp_id%TYPE;
598: l_return_status VARCHAR2(1) ;
599: l_msg_count NUMBER ;
600: l_msg_data VARCHAR2(2000) ;
601: --

Line 644: psb_budget_group_resp resp

640: -- Find the approver role name for the budget group.
641: CURSOR l_role_csr IS
642: SELECT wf_role_name, budget_group_resp_id
643: FROM psb_budget_groups bg ,
644: psb_budget_group_resp resp
645: WHERE bg.budget_group_id = p_budget_group_id
646: AND resp.responsibility_type = 'N'
647: AND bg.budget_group_id = resp.budget_group_id;
648:

Line 1318: l_dist_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;

1314: )
1315: IS
1316: --
1317: l_child_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
1318: l_dist_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
1319: l_budget_group_resp_id psb_budget_group_resp.budget_group_resp_id%TYPE;
1320: l_return_status VARCHAR2(1) ;
1321: l_msg_count NUMBER ;
1322: l_msg_data VARCHAR2(2000) ;

Line 1319: l_budget_group_resp_id psb_budget_group_resp.budget_group_resp_id%TYPE;

1315: IS
1316: --
1317: l_child_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
1318: l_dist_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
1319: l_budget_group_resp_id psb_budget_group_resp.budget_group_resp_id%TYPE;
1320: l_return_status VARCHAR2(1) ;
1321: l_msg_count NUMBER ;
1322: l_msg_data VARCHAR2(2000) ;
1323: --

Line 1369: psb_budget_group_resp resp

1365: -- Find the approver role name for the budget group.
1366: CURSOR l_role_csr IS
1367: SELECT wf_role_name, budget_group_resp_id
1368: FROM psb_budget_groups bg ,
1369: psb_budget_group_resp resp
1370: WHERE bg.budget_group_id = p_budget_group_id
1371: AND resp.responsibility_type = 'N'
1372: AND bg.budget_group_id = resp.budget_group_id;
1373:

Line 1650: l_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;

1646: l_msg_index_out NUMBER;
1647: --
1648: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
1649: l_budget_group_id psb_budget_revisions.budget_group_id%TYPE ;
1650: l_wf_role_name psb_budget_group_resp.wf_role_name%TYPE ;
1651: --
1652: l_tmp_number NUMBER ;
1653: l_item_key VARCHAR2(240) ;
1654: --

Line 1692: psb_budget_group_resp resp

1688: -- Find budget_group users information.
1689: --
1690: SELECT min(wf_role_name) INTO l_wf_role_name
1691: FROM psb_budget_groups bg ,
1692: psb_budget_group_resp resp
1693: WHERE bg.budget_group_id = l_budget_group_id
1694: AND resp.responsibility_type = 'N'
1695: AND bg.budget_group_id = resp.budget_group_id ;
1696: