DBA Data[Home] [Help]

APPS.BIS_PMV_PMF_PVT dependencies on BIS_UTILITIES_PUB

Line 61: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

57: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
58: l_target_rec BIS_TARGET_PUB.TARGET_REC_TYPE;
59: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
60: l_target_rec_p BIS_TARGET_PUB.TARGET_REC_TYPE;
61: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
62: v_range1_low varchar2(200);
63: v_range1_high varchar2(200);
64: l_target VARCHAR2(32000);
65: l_target_url VARCHAR2(32000);

Line 1715: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;

1711: l_return_Status VARCHAR2(32000);
1712: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
1713: l_target_rec BIS_TARGET_PUB.TARGET_REC_TYPE;
1714: l_target_rec_p BIS_TARGET_PUB.TARGET_REC_TYPE;
1715: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1716: l_range1_low varchar2(200);
1717: l_range1_high varchar2(200);
1718: l_target VARCHAR2(32000);
1719:

Line 1771: IF( BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Target_ID)

1767: );
1768:
1769: -- from retrieve_target_pvt---------------------------------------------
1770:
1771: IF( BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Target_ID)
1772: = FND_API.G_TRUE
1773: AND l_Target_Rec.Target_ID IS NOT NULL
1774: ) THEN
1775: SELECT *

Line 1781: ELSIF( BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Target_Level_ID)

1777: FROM bisfv_targets bisfv_targets
1778: WHERE bisfv_targets.TARGET_ID = l_Target_Rec.Target_ID;
1779:
1780:
1781: ELSIF( BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Target_Level_ID)
1782: = FND_API.G_TRUE
1783: AND l_Target_Rec.Target_Level_ID IS NOT NULL
1784: ) THEN
1785: SELECT *

Line 1793: if (BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Plan_ID)

1789: = l_Target_Rec.Target_Level_ID;
1790:
1791: ---If Plan Id is not given, get Plan Id from Short name
1792:
1793: if (BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Plan_ID)
1794: = FND_API.G_TRUE) then
1795: if (BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Plan_Short_Name)
1796: = FND_API.G_TRUE) then
1797: l_Business_Plan_Rec.Business_Plan_Short_Name := l_Target_Rec.Plan_Short_Name;

Line 1795: if (BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Plan_Short_Name)

1791: ---If Plan Id is not given, get Plan Id from Short name
1792:
1793: if (BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Plan_ID)
1794: = FND_API.G_TRUE) then
1795: if (BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Plan_Short_Name)
1796: = FND_API.G_TRUE) then
1797: l_Business_Plan_Rec.Business_Plan_Short_Name := l_Target_Rec.Plan_Short_Name;
1798: l_Business_Plan_Rec_p := l_Business_Plan_Rec;
1799: -- BugFix 2762795

Line 1815: if(BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Org_Level_Value_ID) = FND_API.G_TRUE)

1811: else
1812: l_plan_id := l_Target_Rec.Plan_ID ;
1813: end if;
1814:
1815: if(BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Org_Level_Value_ID) = FND_API.G_TRUE)
1816: then l_org_level_value_id := NULL;
1817: else
1818: l_org_level_value_id := l_Target_Rec.Org_Level_Value_ID;
1819: end if;

Line 1822: if(BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Time_Level_Value_ID) = FND_API.G_TRUE)

1818: l_org_level_value_id := l_Target_Rec.Org_Level_Value_ID;
1819: end if;
1820:
1821:
1822: if(BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Time_Level_Value_ID) = FND_API.G_TRUE)
1823: then l_time_level_value_id := NULL;
1824: else
1825: l_time_level_value_id := l_Target_Rec.Time_Level_Value_ID;
1826: end if;

Line 1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)

1886: END IF;
1887: -----------------------------------------------------------------
1888: lTarget := l_bisfv_targets_rec.target;
1889:
1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)
1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))
1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)

Line 1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))

1887: -----------------------------------------------------------------
1888: lTarget := l_bisfv_targets_rec.target;
1889:
1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)
1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))
1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)
1895: AND (BIS_UTILITIES_PUB.Value_Not_Null

Line 1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing

1889:
1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)
1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))
1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)
1895: AND (BIS_UTILITIES_PUB.Value_Not_Null
1896: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE))
1897: THEN

Line 1895: AND (BIS_UTILITIES_PUB.Value_Not_Null

1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))
1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)
1895: AND (BIS_UTILITIES_PUB.Value_Not_Null
1896: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE))
1897: THEN
1898: Select
1899: COMPUTING_FUNCTION_ID

Line 1909: IF ((BIS_UTILITIES_PUB.Value_Not_Missing

1905: END IF;
1906:
1907: -- only compute target if found computing fn id
1908: --
1909: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1910: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE)
1911: AND (BIS_UTILITIES_PUB.Value_Not_Null
1912: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE))
1913: THEN

Line 1911: AND (BIS_UTILITIES_PUB.Value_Not_Null

1907: -- only compute target if found computing fn id
1908: --
1909: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1910: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE)
1911: AND (BIS_UTILITIES_PUB.Value_Not_Null
1912: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE))
1913: THEN
1914: l_Target_Rec.Target_ID := l_bisfv_targets_rec.Target_ID;
1915: l_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;