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.

APPS.PSB_CREATE_BR_PVT dependencies on PSB_BUDGET_REVISIONS

Line 427: l_revision_justification psb_budget_revisions.justification%TYPE ;

423: l_return_status VARCHAR2(1) ;
424: l_msg_count NUMBER ;
425: l_msg_data VARCHAR2(2000) ;
426: --
427: l_revision_justification psb_budget_revisions.justification%TYPE ;
428: l_main_budget_group_id psb_budget_revisions.budget_group_id%TYPE ;
429: l_main_budget_group_name psb_budget_groups.name%TYPE ;
430: l_new_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
431: l_global_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;

Line 428: l_main_budget_group_id psb_budget_revisions.budget_group_id%TYPE ;

424: l_msg_count NUMBER ;
425: l_msg_data VARCHAR2(2000) ;
426: --
427: l_revision_justification psb_budget_revisions.justification%TYPE ;
428: l_main_budget_group_id psb_budget_revisions.budget_group_id%TYPE ;
429: l_main_budget_group_name psb_budget_groups.name%TYPE ;
430: l_new_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
431: l_global_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
432: --

Line 430: l_new_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;

426: --
427: l_revision_justification psb_budget_revisions.justification%TYPE ;
428: l_main_budget_group_id psb_budget_revisions.budget_group_id%TYPE ;
429: l_main_budget_group_name psb_budget_groups.name%TYPE ;
430: l_new_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
431: l_global_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
432: --
433: l_tmp_char VARCHAR2(1) ;
434: l_freeze_flag VARCHAR2(1) ;

Line 431: l_global_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;

427: l_revision_justification psb_budget_revisions.justification%TYPE ;
428: l_main_budget_group_id psb_budget_revisions.budget_group_id%TYPE ;
429: l_main_budget_group_name psb_budget_groups.name%TYPE ;
430: l_new_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
431: l_global_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
432: --
433: l_tmp_char VARCHAR2(1) ;
434: l_freeze_flag VARCHAR2(1) ;
435: --

Line 438: FROM psb_budget_revisions

434: l_freeze_flag VARCHAR2(1) ;
435: --
436: CURSOR l_budget_revisions_csr IS
437: SELECT *
438: FROM psb_budget_revisions
439: WHERE budget_revision_id = p_budget_revision_id;
440:
441: CURSOR l_budget_by_position_csr IS
442: SELECT count(*)

Line 444: psb_budget_revisions rev

440:
441: CURSOR l_budget_by_position_csr IS
442: SELECT count(*)
443: FROM psb_budget_revision_pos_lines lines,
444: psb_budget_revisions rev
445: WHERE rev.budget_revision_id = p_budget_revision_id
446: AND rev.budget_revision_id = lines.budget_revision_id;
447:
448: --CURSOR l_seq IS

Line 449: -- SELECT psb_budget_revisions_s.nextval budget_revision_id

445: WHERE rev.budget_revision_id = p_budget_revision_id
446: AND rev.budget_revision_id = lines.budget_revision_id;
447:
448: --CURSOR l_seq IS
449: -- SELECT psb_budget_revisions_s.nextval budget_revision_id
450: -- FROM DUAL;
451: --
452: l_br_row_type l_budget_revisions_csr%ROWTYPE ;
453: --

Line 525: -- Create the new budget revision in psb_budget_revisions table.

521: l_global_budget_revision_id := l_br_row_type.global_budget_revision_id;
522: END IF ;
523:
524: --
525: -- Create the new budget revision in psb_budget_revisions table.
526: --
527: if ((p_revision_option_flag is not null ) and (p_revision_option_flag = 'N'))
528: then
529: l_freeze_flag := 'Y';

Line 535: PSB_Budget_Revisions_Pvt.Create_Budget_Revision

531: l_freeze_flag := l_br_row_type.freeze_flag;
532: end if;
533:
534:
535: PSB_Budget_Revisions_Pvt.Create_Budget_Revision
536: (
537: p_api_version => 1.0 ,
538: p_init_msg_list => FND_API.G_FALSE,
539: p_commit => FND_API.G_FALSE,

Line 814: l_parent_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;

810: l_return_status VARCHAR2(1) ;
811: l_msg_count NUMBER ;
812: l_msg_data VARCHAR2(2000) ;
813: --
814: l_parent_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
815: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
816: l_parent_freeze_flag psb_budget_revisions.freeze_flag%TYPE ;
817: --
818: BEGIN

Line 815: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;

811: l_msg_count NUMBER ;
812: l_msg_data VARCHAR2(2000) ;
813: --
814: l_parent_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
815: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
816: l_parent_freeze_flag psb_budget_revisions.freeze_flag%TYPE ;
817: --
818: BEGIN
819: --

Line 816: l_parent_freeze_flag psb_budget_revisions.freeze_flag%TYPE ;

812: l_msg_data VARCHAR2(2000) ;
813: --
814: l_parent_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
815: l_budget_revision_id psb_budget_revisions.budget_revision_id%TYPE ;
816: l_parent_freeze_flag psb_budget_revisions.freeze_flag%TYPE ;
817: --
818: BEGIN
819: --
820: SAVEPOINT Freeze_Budget_Revision_Pvt ;

Line 871: FROM psb_budget_revisions

867: -- Check the freeze_flag for the parent worksheet.
868: IF l_parent_budget_revision_id <> 0 THEN
869:
870: SELECT NVL(freeze_flag, 'N') INTO l_parent_freeze_flag
871: FROM psb_budget_revisions
872: WHERE budget_revision_id = l_parent_budget_revision_id;
873:
874: IF l_parent_freeze_flag = 'Y' THEN
875:

Line 887: -- Update freeze_flag in psb_budget_revisions.

883:
884: END IF ; -- For p_freeze_flag = 'N' condition.
885:
886: --
887: -- Update freeze_flag in psb_budget_revisions.
888: --
889: l_budget_revision_id := p_budget_revision_id;
890:
891:

Line 895: PSB_Budget_Revisions_Pvt.Create_Budget_Revision

891:
892: /* Code split into 2 conditions if and elsif to make request_id
893: null in case of unfreeze. Changed by Siva on 07/17/00 to resolve bug 1303434 */
894: IF p_freeze_flag = 'Y' THEN
895: PSB_Budget_Revisions_Pvt.Create_Budget_Revision
896: (
897: p_api_version => 1.0 ,
898: p_init_msg_list => FND_API.G_FALSE,
899: p_commit => FND_API.G_FALSE,

Line 910: PSB_Budget_Revisions_Pvt.Create_Budget_Revision

906: p_freeze_flag => p_freeze_flag
907: );
908: ELSIF p_freeze_flag = 'N' THEN
909:
910: PSB_Budget_Revisions_Pvt.Create_Budget_Revision
911: (
912: p_api_version => 1.0 ,
913: p_init_msg_list => FND_API.G_FALSE,
914: p_commit => FND_API.G_FALSE,

Line 1055: FROM psb_budget_revisions br,

1051: l_budget_group_id,
1052: l_global_budget_revision_id,
1053: l_global_budget_revision,
1054: l_parent_budget_group_id
1055: FROM psb_budget_revisions br,
1056: psb_budget_groups bg
1057: WHERE br.budget_revision_id = p_budget_revision_id
1058: AND br.budget_group_id = bg.budget_group_id ;
1059:

Line 1071: FROM psb_budget_revisions

1067: --
1068: -- Find global budget_group_id for the global budget revision.
1069: --
1070: SELECT budget_group_id INTO l_global_budget_group_id
1071: FROM psb_budget_revisions
1072: WHERE budget_revision_id = l_global_budget_revision_id;
1073:
1074: --
1075: -- If parent budget group for the current budget revision is same as the budget

Line 1094: FROM psb_budget_revisions

1090: -- New way to find if a revision has been created for a budget group.
1091: -- ( Bug#2832148 )
1092: --
1093: SELECT budget_revision_id INTO p_budget_revision_id_OUT
1094: FROM psb_budget_revisions
1095: WHERE global_budget_revision_id = l_global_budget_revision_id
1096: AND budget_group_id = l_parent_budget_group_id ;
1097:
1098: /*

Line 1372: FROM psb_budget_revisions

1368: INTO
1369: l_budget_group_id ,
1370: l_global_budget_revision_id ,
1371: l_global_budget_revision
1372: FROM psb_budget_revisions
1373: WHERE budget_revision_id = p_budget_revision_id ;
1374:
1375: IF l_global_budget_revision = 'Y' THEN
1376: l_global_budget_revision_id := p_budget_revision_id ;

Line 1416: FROM psb_budget_revisions

1412: -- New way to find if a revision has been created for a budget group.
1413: -- ( Bug#2832148 )
1414: --
1415: SELECT budget_revision_id INTO l_child_budget_revision_id
1416: FROM psb_budget_revisions
1417: WHERE global_budget_revision_id = l_global_budget_revision_id
1418: AND budget_group_id = l_budget_group_rec.budget_group_id ;
1419:
1420: /*

Line 1546: psb_budget_revisions rev

1542:
1543: CURSOR l_budget_by_position_csr IS
1544: SELECT count(*)
1545: FROM psb_budget_revision_pos_lines lines,
1546: psb_budget_revisions rev
1547: WHERE rev.budget_revision_id = p_source_budget_revision_id
1548: AND rev.budget_revision_id = lines.budget_revision_id;
1549:
1550: BEGIN

Line 1579: PSB_Budget_Revisions_Pvt.Create_Budget_Revision

1575: if ((p_revision_option_flag is not null ) and (p_revision_option_flag = 'N')) then
1576: l_freeze_flag := 'Y';
1577: end if;
1578:
1579: PSB_Budget_Revisions_Pvt.Create_Budget_Revision
1580: (
1581: p_api_version => 1.0 ,
1582: p_init_msg_list => FND_API.G_FALSE,
1583: p_commit => FND_API.G_FALSE,

Line 1609: FROM psb_budget_revisions

1605: INTO
1606: l_source_budget_group_id,
1607: l_source_global_budget_rev_id,
1608: l_source_global_budget_rev
1609: FROM psb_budget_revisions
1610: WHERE budget_revision_id = p_source_budget_revision_id ;
1611:
1612: IF l_source_global_budget_rev = 'Y' THEN
1613: l_source_global_budget_rev_id := p_source_budget_revision_id ;

Line 1626: FROM psb_budget_revisions

1622: global_budget_revision_id
1623: INTO
1624: l_target_budget_group_id,
1625: l_target_global_budget_rev_id
1626: FROM psb_budget_revisions
1627: WHERE budget_revision_id = p_target_budget_revision_id ;
1628: --
1629: --
1630: --