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.BIS_TARGET_LEVEL_PVT dependencies on HTP

Line 1641: htp.p( 'a.Measure_ID ='||a.Measure_ID ||', b = '||b.Measure_ID );

1637: Set_NULL( p_Target_Level_Rec => p_target_level_rec
1638: , x_Target_Level_Rec => b);
1639:
1640: /*
1641: htp.p( 'a.Measure_ID ='||a.Measure_ID ||', b = '||b.Measure_ID );
1642: htp.p( 'a.Target_Level_ID ='||a.Target_Level_ID ||', b = '||b.Target_Level_ID );
1643: htp.p( 'a.Target_Level_Short_Name ='||a.Target_Level_Short_Name ||', b = '||b.Target_Level_Short_Name );
1644: htp.p( 'a.Target_Level_Name ='||a.Target_Level_Name ||', b = '||b.Target_Level_Name );
1645: htp.p( 'a.Description ='||a.Description ||', b = '||b.Description );

Line 1642: htp.p( 'a.Target_Level_ID ='||a.Target_Level_ID ||', b = '||b.Target_Level_ID );

1638: , x_Target_Level_Rec => b);
1639:
1640: /*
1641: htp.p( 'a.Measure_ID ='||a.Measure_ID ||', b = '||b.Measure_ID );
1642: htp.p( 'a.Target_Level_ID ='||a.Target_Level_ID ||', b = '||b.Target_Level_ID );
1643: htp.p( 'a.Target_Level_Short_Name ='||a.Target_Level_Short_Name ||', b = '||b.Target_Level_Short_Name );
1644: htp.p( 'a.Target_Level_Name ='||a.Target_Level_Name ||', b = '||b.Target_Level_Name );
1645: htp.p( 'a.Description ='||a.Description ||', b = '||b.Description );
1646: htp.p( 'a.Dimension1_Level_ID ='||a.Dimension1_Level_ID ||', b = '||b.Dimension1_Level_ID);

Line 1643: htp.p( 'a.Target_Level_Short_Name ='||a.Target_Level_Short_Name ||', b = '||b.Target_Level_Short_Name );

1639:
1640: /*
1641: htp.p( 'a.Measure_ID ='||a.Measure_ID ||', b = '||b.Measure_ID );
1642: htp.p( 'a.Target_Level_ID ='||a.Target_Level_ID ||', b = '||b.Target_Level_ID );
1643: htp.p( 'a.Target_Level_Short_Name ='||a.Target_Level_Short_Name ||', b = '||b.Target_Level_Short_Name );
1644: htp.p( 'a.Target_Level_Name ='||a.Target_Level_Name ||', b = '||b.Target_Level_Name );
1645: htp.p( 'a.Description ='||a.Description ||', b = '||b.Description );
1646: htp.p( 'a.Dimension1_Level_ID ='||a.Dimension1_Level_ID ||', b = '||b.Dimension1_Level_ID);
1647: htp.p( 'a.Dimension2_Level_ID ='||a.Dimension2_Level_ID ||', b = '||b.Dimension2_Level_ID );

Line 1644: htp.p( 'a.Target_Level_Name ='||a.Target_Level_Name ||', b = '||b.Target_Level_Name );

1640: /*
1641: htp.p( 'a.Measure_ID ='||a.Measure_ID ||', b = '||b.Measure_ID );
1642: htp.p( 'a.Target_Level_ID ='||a.Target_Level_ID ||', b = '||b.Target_Level_ID );
1643: htp.p( 'a.Target_Level_Short_Name ='||a.Target_Level_Short_Name ||', b = '||b.Target_Level_Short_Name );
1644: htp.p( 'a.Target_Level_Name ='||a.Target_Level_Name ||', b = '||b.Target_Level_Name );
1645: htp.p( 'a.Description ='||a.Description ||', b = '||b.Description );
1646: htp.p( 'a.Dimension1_Level_ID ='||a.Dimension1_Level_ID ||', b = '||b.Dimension1_Level_ID);
1647: htp.p( 'a.Dimension2_Level_ID ='||a.Dimension2_Level_ID ||', b = '||b.Dimension2_Level_ID );
1648: htp.p( 'a.Dimension3_Level_ID ='||a.Dimension3_Level_ID ||', b = '||b.Dimension3_Level_ID );

Line 1645: htp.p( 'a.Description ='||a.Description ||', b = '||b.Description );

1641: htp.p( 'a.Measure_ID ='||a.Measure_ID ||', b = '||b.Measure_ID );
1642: htp.p( 'a.Target_Level_ID ='||a.Target_Level_ID ||', b = '||b.Target_Level_ID );
1643: htp.p( 'a.Target_Level_Short_Name ='||a.Target_Level_Short_Name ||', b = '||b.Target_Level_Short_Name );
1644: htp.p( 'a.Target_Level_Name ='||a.Target_Level_Name ||', b = '||b.Target_Level_Name );
1645: htp.p( 'a.Description ='||a.Description ||', b = '||b.Description );
1646: htp.p( 'a.Dimension1_Level_ID ='||a.Dimension1_Level_ID ||', b = '||b.Dimension1_Level_ID);
1647: htp.p( 'a.Dimension2_Level_ID ='||a.Dimension2_Level_ID ||', b = '||b.Dimension2_Level_ID );
1648: htp.p( 'a.Dimension3_Level_ID ='||a.Dimension3_Level_ID ||', b = '||b.Dimension3_Level_ID );
1649: htp.p( 'a.Dimension4_Level_ID ='||a.Dimension4_Level_ID ||', b = '||b.Dimension4_Level_ID );

Line 1646: htp.p( 'a.Dimension1_Level_ID ='||a.Dimension1_Level_ID ||', b = '||b.Dimension1_Level_ID);

1642: htp.p( 'a.Target_Level_ID ='||a.Target_Level_ID ||', b = '||b.Target_Level_ID );
1643: htp.p( 'a.Target_Level_Short_Name ='||a.Target_Level_Short_Name ||', b = '||b.Target_Level_Short_Name );
1644: htp.p( 'a.Target_Level_Name ='||a.Target_Level_Name ||', b = '||b.Target_Level_Name );
1645: htp.p( 'a.Description ='||a.Description ||', b = '||b.Description );
1646: htp.p( 'a.Dimension1_Level_ID ='||a.Dimension1_Level_ID ||', b = '||b.Dimension1_Level_ID);
1647: htp.p( 'a.Dimension2_Level_ID ='||a.Dimension2_Level_ID ||', b = '||b.Dimension2_Level_ID );
1648: htp.p( 'a.Dimension3_Level_ID ='||a.Dimension3_Level_ID ||', b = '||b.Dimension3_Level_ID );
1649: htp.p( 'a.Dimension4_Level_ID ='||a.Dimension4_Level_ID ||', b = '||b.Dimension4_Level_ID );
1650: htp.p( 'a.Dimension5_Level_ID ='||a.Dimension5_Level_ID ||', b = '||b.Dimension5_Level_ID );

Line 1647: htp.p( 'a.Dimension2_Level_ID ='||a.Dimension2_Level_ID ||', b = '||b.Dimension2_Level_ID );

1643: htp.p( 'a.Target_Level_Short_Name ='||a.Target_Level_Short_Name ||', b = '||b.Target_Level_Short_Name );
1644: htp.p( 'a.Target_Level_Name ='||a.Target_Level_Name ||', b = '||b.Target_Level_Name );
1645: htp.p( 'a.Description ='||a.Description ||', b = '||b.Description );
1646: htp.p( 'a.Dimension1_Level_ID ='||a.Dimension1_Level_ID ||', b = '||b.Dimension1_Level_ID);
1647: htp.p( 'a.Dimension2_Level_ID ='||a.Dimension2_Level_ID ||', b = '||b.Dimension2_Level_ID );
1648: htp.p( 'a.Dimension3_Level_ID ='||a.Dimension3_Level_ID ||', b = '||b.Dimension3_Level_ID );
1649: htp.p( 'a.Dimension4_Level_ID ='||a.Dimension4_Level_ID ||', b = '||b.Dimension4_Level_ID );
1650: htp.p( 'a.Dimension5_Level_ID ='||a.Dimension5_Level_ID ||', b = '||b.Dimension5_Level_ID );
1651: htp.p( 'a.Unit_of_Measure ='||a.Unit_of_Measure ||', b = '||b.Unit_of_Measure );

Line 1648: htp.p( 'a.Dimension3_Level_ID ='||a.Dimension3_Level_ID ||', b = '||b.Dimension3_Level_ID );

1644: htp.p( 'a.Target_Level_Name ='||a.Target_Level_Name ||', b = '||b.Target_Level_Name );
1645: htp.p( 'a.Description ='||a.Description ||', b = '||b.Description );
1646: htp.p( 'a.Dimension1_Level_ID ='||a.Dimension1_Level_ID ||', b = '||b.Dimension1_Level_ID);
1647: htp.p( 'a.Dimension2_Level_ID ='||a.Dimension2_Level_ID ||', b = '||b.Dimension2_Level_ID );
1648: htp.p( 'a.Dimension3_Level_ID ='||a.Dimension3_Level_ID ||', b = '||b.Dimension3_Level_ID );
1649: htp.p( 'a.Dimension4_Level_ID ='||a.Dimension4_Level_ID ||', b = '||b.Dimension4_Level_ID );
1650: htp.p( 'a.Dimension5_Level_ID ='||a.Dimension5_Level_ID ||', b = '||b.Dimension5_Level_ID );
1651: htp.p( 'a.Unit_of_Measure ='||a.Unit_of_Measure ||', b = '||b.Unit_of_Measure );
1652: htp.p( 'a.WF_Process_Short_Name ='||a.workflow_Process_Short_Name||', b = '||b.workflow_Process_Short_Name);

Line 1649: htp.p( 'a.Dimension4_Level_ID ='||a.Dimension4_Level_ID ||', b = '||b.Dimension4_Level_ID );

1645: htp.p( 'a.Description ='||a.Description ||', b = '||b.Description );
1646: htp.p( 'a.Dimension1_Level_ID ='||a.Dimension1_Level_ID ||', b = '||b.Dimension1_Level_ID);
1647: htp.p( 'a.Dimension2_Level_ID ='||a.Dimension2_Level_ID ||', b = '||b.Dimension2_Level_ID );
1648: htp.p( 'a.Dimension3_Level_ID ='||a.Dimension3_Level_ID ||', b = '||b.Dimension3_Level_ID );
1649: htp.p( 'a.Dimension4_Level_ID ='||a.Dimension4_Level_ID ||', b = '||b.Dimension4_Level_ID );
1650: htp.p( 'a.Dimension5_Level_ID ='||a.Dimension5_Level_ID ||', b = '||b.Dimension5_Level_ID );
1651: htp.p( 'a.Unit_of_Measure ='||a.Unit_of_Measure ||', b = '||b.Unit_of_Measure );
1652: htp.p( 'a.WF_Process_Short_Name ='||a.workflow_Process_Short_Name||', b = '||b.workflow_Process_Short_Name);
1653: htp.p( 'a.workflow_item_type ='||a.workflow_item_type ||', b = '||b.workflow_item_type);

Line 1650: htp.p( 'a.Dimension5_Level_ID ='||a.Dimension5_Level_ID ||', b = '||b.Dimension5_Level_ID );

1646: htp.p( 'a.Dimension1_Level_ID ='||a.Dimension1_Level_ID ||', b = '||b.Dimension1_Level_ID);
1647: htp.p( 'a.Dimension2_Level_ID ='||a.Dimension2_Level_ID ||', b = '||b.Dimension2_Level_ID );
1648: htp.p( 'a.Dimension3_Level_ID ='||a.Dimension3_Level_ID ||', b = '||b.Dimension3_Level_ID );
1649: htp.p( 'a.Dimension4_Level_ID ='||a.Dimension4_Level_ID ||', b = '||b.Dimension4_Level_ID );
1650: htp.p( 'a.Dimension5_Level_ID ='||a.Dimension5_Level_ID ||', b = '||b.Dimension5_Level_ID );
1651: htp.p( 'a.Unit_of_Measure ='||a.Unit_of_Measure ||', b = '||b.Unit_of_Measure );
1652: htp.p( 'a.WF_Process_Short_Name ='||a.workflow_Process_Short_Name||', b = '||b.workflow_Process_Short_Name);
1653: htp.p( 'a.workflow_item_type ='||a.workflow_item_type ||', b = '||b.workflow_item_type);
1654: htp.p( 'a.Def_Notify_Res.ID ='||a.Default_Notify_Resp_ID ||', b = '||b.Default_Notify_Resp_ID );

Line 1651: htp.p( 'a.Unit_of_Measure ='||a.Unit_of_Measure ||', b = '||b.Unit_of_Measure );

1647: htp.p( 'a.Dimension2_Level_ID ='||a.Dimension2_Level_ID ||', b = '||b.Dimension2_Level_ID );
1648: htp.p( 'a.Dimension3_Level_ID ='||a.Dimension3_Level_ID ||', b = '||b.Dimension3_Level_ID );
1649: htp.p( 'a.Dimension4_Level_ID ='||a.Dimension4_Level_ID ||', b = '||b.Dimension4_Level_ID );
1650: htp.p( 'a.Dimension5_Level_ID ='||a.Dimension5_Level_ID ||', b = '||b.Dimension5_Level_ID );
1651: htp.p( 'a.Unit_of_Measure ='||a.Unit_of_Measure ||', b = '||b.Unit_of_Measure );
1652: htp.p( 'a.WF_Process_Short_Name ='||a.workflow_Process_Short_Name||', b = '||b.workflow_Process_Short_Name);
1653: htp.p( 'a.workflow_item_type ='||a.workflow_item_type ||', b = '||b.workflow_item_type);
1654: htp.p( 'a.Def_Notify_Res.ID ='||a.Default_Notify_Resp_ID ||', b = '||b.Default_Notify_Resp_ID );
1655: htp.p( 'a.Default_Cmp_Target_ID ='||a.Computing_function_ID ||', b = '||b.computing_function_ID );

Line 1652: htp.p( 'a.WF_Process_Short_Name ='||a.workflow_Process_Short_Name||', b = '||b.workflow_Process_Short_Name);

1648: htp.p( 'a.Dimension3_Level_ID ='||a.Dimension3_Level_ID ||', b = '||b.Dimension3_Level_ID );
1649: htp.p( 'a.Dimension4_Level_ID ='||a.Dimension4_Level_ID ||', b = '||b.Dimension4_Level_ID );
1650: htp.p( 'a.Dimension5_Level_ID ='||a.Dimension5_Level_ID ||', b = '||b.Dimension5_Level_ID );
1651: htp.p( 'a.Unit_of_Measure ='||a.Unit_of_Measure ||', b = '||b.Unit_of_Measure );
1652: htp.p( 'a.WF_Process_Short_Name ='||a.workflow_Process_Short_Name||', b = '||b.workflow_Process_Short_Name);
1653: htp.p( 'a.workflow_item_type ='||a.workflow_item_type ||', b = '||b.workflow_item_type);
1654: htp.p( 'a.Def_Notify_Res.ID ='||a.Default_Notify_Resp_ID ||', b = '||b.Default_Notify_Resp_ID );
1655: htp.p( 'a.Default_Cmp_Target_ID ='||a.Computing_function_ID ||', b = '||b.computing_function_ID );
1656: htp.p( 'a.System_Flag ='||a.System_Flag ||', b = '||b.System_Flag );

Line 1653: htp.p( 'a.workflow_item_type ='||a.workflow_item_type ||', b = '||b.workflow_item_type);

1649: htp.p( 'a.Dimension4_Level_ID ='||a.Dimension4_Level_ID ||', b = '||b.Dimension4_Level_ID );
1650: htp.p( 'a.Dimension5_Level_ID ='||a.Dimension5_Level_ID ||', b = '||b.Dimension5_Level_ID );
1651: htp.p( 'a.Unit_of_Measure ='||a.Unit_of_Measure ||', b = '||b.Unit_of_Measure );
1652: htp.p( 'a.WF_Process_Short_Name ='||a.workflow_Process_Short_Name||', b = '||b.workflow_Process_Short_Name);
1653: htp.p( 'a.workflow_item_type ='||a.workflow_item_type ||', b = '||b.workflow_item_type);
1654: htp.p( 'a.Def_Notify_Res.ID ='||a.Default_Notify_Resp_ID ||', b = '||b.Default_Notify_Resp_ID );
1655: htp.p( 'a.Default_Cmp_Target_ID ='||a.Computing_function_ID ||', b = '||b.computing_function_ID );
1656: htp.p( 'a.System_Flag ='||a.System_Flag ||', b = '||b.System_Flag );
1657: */

Line 1654: htp.p( 'a.Def_Notify_Res.ID ='||a.Default_Notify_Resp_ID ||', b = '||b.Default_Notify_Resp_ID );

1650: htp.p( 'a.Dimension5_Level_ID ='||a.Dimension5_Level_ID ||', b = '||b.Dimension5_Level_ID );
1651: htp.p( 'a.Unit_of_Measure ='||a.Unit_of_Measure ||', b = '||b.Unit_of_Measure );
1652: htp.p( 'a.WF_Process_Short_Name ='||a.workflow_Process_Short_Name||', b = '||b.workflow_Process_Short_Name);
1653: htp.p( 'a.workflow_item_type ='||a.workflow_item_type ||', b = '||b.workflow_item_type);
1654: htp.p( 'a.Def_Notify_Res.ID ='||a.Default_Notify_Resp_ID ||', b = '||b.Default_Notify_Resp_ID );
1655: htp.p( 'a.Default_Cmp_Target_ID ='||a.Computing_function_ID ||', b = '||b.computing_function_ID );
1656: htp.p( 'a.System_Flag ='||a.System_Flag ||', b = '||b.System_Flag );
1657: */
1658:

Line 1655: htp.p( 'a.Default_Cmp_Target_ID ='||a.Computing_function_ID ||', b = '||b.computing_function_ID );

1651: htp.p( 'a.Unit_of_Measure ='||a.Unit_of_Measure ||', b = '||b.Unit_of_Measure );
1652: htp.p( 'a.WF_Process_Short_Name ='||a.workflow_Process_Short_Name||', b = '||b.workflow_Process_Short_Name);
1653: htp.p( 'a.workflow_item_type ='||a.workflow_item_type ||', b = '||b.workflow_item_type);
1654: htp.p( 'a.Def_Notify_Res.ID ='||a.Default_Notify_Resp_ID ||', b = '||b.Default_Notify_Resp_ID );
1655: htp.p( 'a.Default_Cmp_Target_ID ='||a.Computing_function_ID ||', b = '||b.computing_function_ID );
1656: htp.p( 'a.System_Flag ='||a.System_Flag ||', b = '||b.System_Flag );
1657: */
1658:
1659: IF a.Measure_ID = b.Measure_ID

Line 1656: htp.p( 'a.System_Flag ='||a.System_Flag ||', b = '||b.System_Flag );

1652: htp.p( 'a.WF_Process_Short_Name ='||a.workflow_Process_Short_Name||', b = '||b.workflow_Process_Short_Name);
1653: htp.p( 'a.workflow_item_type ='||a.workflow_item_type ||', b = '||b.workflow_item_type);
1654: htp.p( 'a.Def_Notify_Res.ID ='||a.Default_Notify_Resp_ID ||', b = '||b.Default_Notify_Resp_ID );
1655: htp.p( 'a.Default_Cmp_Target_ID ='||a.Computing_function_ID ||', b = '||b.computing_function_ID );
1656: htp.p( 'a.System_Flag ='||a.System_Flag ||', b = '||b.System_Flag );
1657: */
1658:
1659: IF a.Measure_ID = b.Measure_ID
1660: AND a.Target_Level_ID = b.Target_Level_ID

Line 1899: htp.p('Exception in Update_Target_Level_Rec: '||SQLERRM);

1895: END IF;
1896:
1897: EXCEPTION
1898: WHEN OTHERS THEN
1899: htp.p('Exception in Update_Target_Level_Rec: '||SQLERRM);
1900: END Update_Target_Level_Rec;
1901: --
1902: -- Update_Target_Levels
1903: PROCEDURE Update_Target_Level