APPS.PSB_SUBMIT_REVISION_PVT dependencies on PSB_CREATE_BR_PVT

Line 374: PSB_Create_BR_Pvt.Check_BR_Ops_Concurrency

370: aname => 'OPERATION_TYPE' );
371: --
372: -- API to perform Revision related concurrency control.
373: --
374: PSB_Create_BR_Pvt.Check_BR_Ops_Concurrency
375: (
376: p_api_version => 1.0,
377: p_init_msg_list => FND_API.G_FALSE ,
378: p_commit => FND_API.G_FALSE ,

Line 629: l_budget_revisions_tab PSB_Create_BR_Pvt.Budget_Revision_Tbl_Type ;

625: --
626: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
627: l_budget_group_id psb_budget_revisions.budget_group_id%TYPE ;
628: l_current_freeze_flag psb_budget_revisions.freeze_flag%TYPE ;
629: l_budget_revisions_tab PSB_Create_BR_Pvt.Budget_Revision_Tbl_Type ;
630:
631: --
632: l_notification_id NUMBER ;
633: l_submitter_name VARCHAR2(80);

Line 671: PSB_Create_BR_Pvt.Freeze_Budget_Revision

667:
668: --
669: -- Freeze the top level worksheet.
670: --
671: PSB_Create_BR_Pvt.Freeze_Budget_Revision
672: (
673: p_api_version => 1.0 ,
674: p_init_msg_list => FND_API.G_FALSE,
675: p_commit => FND_API.G_FALSE,

Line 709: PSB_Create_BR_Pvt.Find_Child_Budget_Revisions

705: --
706: -- Call API to find all lower level worksheets.
707: --
708:
709: PSB_Create_BR_Pvt.Find_Child_Budget_Revisions
710: (
711: p_api_version => 1.0 ,
712: p_init_msg_list => FND_API.G_FALSE,
713: p_commit => FND_API.G_FALSE,

Line 744: PSB_Create_BR_Pvt.Freeze_Budget_Revision

740: WHERE budget_revision_id = l_budget_revisions_tab(i) ;
741:
742: IF l_current_freeze_flag = 'N' THEN
743: --
744: PSB_Create_BR_Pvt.Freeze_Budget_Revision
745: (
746: p_api_version => 1.0 ,
747: p_init_msg_list => FND_API.G_FALSE,
748: p_commit => FND_API.G_FALSE,

Line 1009: l_budget_revisions_tab PSB_Create_BR_Pvt.Budget_Revision_Tbl_Type ;

1005: l_msg_count NUMBER ;
1006: l_msg_data VARCHAR2(2000) ;
1007: --
1008: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
1009: l_budget_revisions_tab PSB_Create_BR_Pvt.Budget_Revision_Tbl_Type ;
1010: l_operation_id NUMBER ;
1011: --
1012:
1013: BEGIN

Line 1030: PSB_Create_BR_Pvt.Find_Parent_Budget_Revisions

1026:
1027: --
1028: -- Find all the parent worksheets to update thier view_line_flag.
1029: --
1030: PSB_Create_BR_Pvt.Find_Parent_Budget_Revisions
1031: (
1032: p_api_version => 1.0 ,
1033: p_init_msg_list => FND_API.G_FALSE,
1034: p_commit => FND_API.G_FALSE,

Line 1287: l_budget_revisions_tab PSB_Create_BR_Pvt.Budget_Revision_Tbl_Type ;

1283: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
1284: l_submitter_id NUMBER ;
1285: l_submission_status VARCHAR2(1);
1286: l_budget_group_id psb_budget_revisions.budget_group_id%TYPE ;
1287: l_budget_revisions_tab PSB_Create_BR_Pvt.Budget_Revision_Tbl_Type ;
1288: --
1289: BEGIN
1290: --
1291: IF ( funcmode = 'RUN' ) THEN

Line 1330: /*PSB_Create_BR_Pvt.Find_Child_Budget_Revisions

1326: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1328: END IF ;
1329:
1330: /*PSB_Create_BR_Pvt.Find_Child_Budget_Revisions
1331: (
1332: p_api_version => 1.0 ,
1333: p_init_msg_list => FND_API.G_FALSE,
1334: p_commit => FND_API.G_FALSE,

Line 1799: PSB_Create_BR_Pvt.Freeze_Budget_Revision

1795: aname => 'BUDGET_REVISION_ID');
1796: --
1797: -- Unfreeze only the current worksheet.
1798: --
1799: PSB_Create_BR_Pvt.Freeze_Budget_Revision
1800: (
1801: p_api_version => 1.0 ,
1802: p_init_msg_list => FND_API.G_FALSE,
1803: p_commit => FND_API.G_FALSE,