APPS.PSB_WORKFLOW_PVT dependencies on PSB_BUDGET_REVISIONS

Line 1185: FROM psb_budget_revisions

1181: -- is the global budget revision.
1182: --
1183: SELECT NVL( global_budget_revision_id, l_budget_revision_id )
1184: INTO l_global_budget_revision_id
1185: FROM psb_budget_revisions
1186: WHERE budget_revision_id = l_budget_revision_id ;
1187:
1188: --
1189: FOR l_budget_groups_rec IN

Line 1317: l_child_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;

1313: p_return_status OUT NOCOPY VARCHAR2
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 ;

Line 1343: FROM psb_budget_revisions

1339: -- ( Bug#2832148 )
1340: --
1341: CURSOR l_child_budget_rev_csr IS
1342: SELECT budget_revision_id
1343: FROM psb_budget_revisions
1344: WHERE global_budget_revision_id = p_global_budget_revision_id
1345: AND budget_group_id = p_budget_group_id ;
1346:
1347: /*

Line 1378: FROM psb_budget_revisions

1374: -- To find if the budget revision is frozen.
1375:
1376: CURSOR l_br_csr IS
1377: SELECT freeze_flag
1378: FROM psb_budget_revisions
1379: WHERE budget_revision_id = l_child_budget_revision_id;
1380: --
1381: BEGIN
1382:

Line 1629: p_budget_revision_id IN psb_budget_revisions.budget_revision_id%type,

1625: (
1626: errbuf OUT NOCOPY VARCHAR2,
1627: retcode OUT NOCOPY VARCHAR2,
1628: --
1629: p_budget_revision_id IN psb_budget_revisions.budget_revision_id%type,
1630: p_submitter_id IN NUMBER ,
1631: p_operation_type IN VARCHAR2 ,
1632: p_orig_system IN VARCHAR2 ,
1633: p_comments IN VARCHAR2 ,

Line 1648: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;

1644: l_msg_count NUMBER ;
1645: l_msg_data VARCHAR2(2000) ;
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 ;

Line 1649: l_budget_group_id psb_budget_revisions.budget_group_id%TYPE ;

1645: l_msg_data VARCHAR2(2000) ;
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) ;

Line 1684: FROM psb_budget_revisions

1680: --
1681: -- Find budget_group_id for the worksheet.
1682: --
1683: SELECT budget_group_id INTO l_budget_group_id
1684: FROM psb_budget_revisions
1685: WHERE budget_revision_id = p_budget_revision_id ;
1686:
1687: --
1688: -- Find budget_group users information.