DBA Data[Home] [Help]

APPS.ONT_LINE_DEF_UTIL dependencies on ONT_ORDER_CAT_DEF_UTIL

Line 4001: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

3997: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
3998: IF NVL(p_record.LINE_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
3999: RETURN NULL;
4000: END IF;
4001: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4002: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4003: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
4004: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4005: END IF;

Line 4003: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2

3999: RETURN NULL;
4000: END IF;
4001: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4002: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4003: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
4004: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4005: END IF;
4006:
4007: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_ITEM_BILLTO_V') THEN

Line 4004: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

4000: END IF;
4001: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4002: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4003: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
4004: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4005: END IF;
4006:
4007: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_ITEM_BILLTO_V') THEN
4008: IF ( NVL(p_record.INVOICE_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )

Line 4255: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

4251: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
4252: IF NVL(p_record.LINE_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4253: RETURN NULL;
4254: END IF;
4255: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4256: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4257: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
4258: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4259: END IF;

Line 4257: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2

4253: RETURN NULL;
4254: END IF;
4255: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4256: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4257: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
4258: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4259: END IF;
4260:
4261: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_CUST_ITEMS_V') THEN

Line 4258: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

4254: END IF;
4255: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4256: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4257: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
4258: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4259: END IF;
4260:
4261: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_CUST_ITEMS_V') THEN
4262: IF ( NVL(p_record.SOLD_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )

Line 4582: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

4578: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
4579: IF NVL(p_record.LINE_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4580: RETURN NULL;
4581: END IF;
4582: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4583: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4584: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4585: END IF;
4586:

Line 4584: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

4580: RETURN NULL;
4581: END IF;
4582: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4583: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4584: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4585: END IF;
4586:
4587: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_ITEM_BILLTO_V') THEN
4588: IF ( NVL(p_record.INVOICE_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )

Line 4815: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

4811: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
4812: IF NVL(p_record.LINE_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4813: RETURN NULL;
4814: END IF;
4815: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4816: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4817: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4818: END IF;
4819:

Line 4817: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

4813: RETURN NULL;
4814: END IF;
4815: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4816: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4817: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4818: END IF;
4819:
4820: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_CUST_ITEMS_V') THEN
4821: IF ( NVL(p_record.SOLD_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )