DBA Data[Home] [Help]

APPS.ONT_LINE_DEF_UTIL dependencies on ONT_ORDER_CAT_DEF_UTIL

Line 3792: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

3788: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
3789: IF NVL(p_record.LINE_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
3790: RETURN NULL;
3791: END IF;
3792: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
3793: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
3794: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
3795: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
3796: END IF;

Line 3794: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2

3790: RETURN NULL;
3791: END IF;
3792: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
3793: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
3794: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
3795: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
3796: END IF;
3797:
3798: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_CUST_ITEMS_V') THEN

Line 3795: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

3791: END IF;
3792: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
3793: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
3794: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
3795: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
3796: END IF;
3797:
3798: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_CUST_ITEMS_V') THEN
3799: IF ( NVL(p_record.SOLD_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )

Line 4124: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

4120: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
4121: IF NVL(p_record.LINE_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4122: RETURN NULL;
4123: END IF;
4124: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4125: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4126: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
4127: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4128: END IF;

Line 4126: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2

4122: RETURN NULL;
4123: END IF;
4124: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4125: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4126: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
4127: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4128: END IF;
4129:
4130: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_ITEM_BILLTO_V') THEN

Line 4127: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

4123: END IF;
4124: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4125: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4126: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
4127: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4128: END IF;
4129:
4130: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_ITEM_BILLTO_V') THEN
4131: IF ( NVL(p_record.INVOICE_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )

Line 4389: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

4385: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
4386: IF NVL(p_record.LINE_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4387: RETURN NULL;
4388: END IF;
4389: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4390: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4391: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4392: END IF;
4393:

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

4387: RETURN NULL;
4388: END IF;
4389: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4390: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4391: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4392: END IF;
4393:
4394: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_CUST_ITEMS_V') THEN
4395: IF ( NVL(p_record.SOLD_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )

Line 4690: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

4686: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
4687: IF NVL(p_record.LINE_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4688: RETURN NULL;
4689: END IF;
4690: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4691: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4692: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4693: END IF;
4694:

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

4688: RETURN NULL;
4689: END IF;
4690: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
4691: (p_ORDER_CATEGORY_CODE => p_record.LINE_CATEGORY_CODE) = 1 then
4692: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
4693: END IF;
4694:
4695: ELSIF (p_foreign_database_object_name = 'OE_AK_TOL_ITEM_BILLTO_V') THEN
4696: IF ( NVL(p_record.INVOICE_TO_ORG_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )