DBA Data[Home] [Help]

APPS.OZF_PROMOTIONAL_OFFERS_PKG dependencies on FND_PROFILE

Line 215: DECODE( p_confidential_flag, FND_API.g_miss_char, NVL(FND_PROFILE.value('OZF_OFFR_CONFIDENTIAL_FLAG'), 'N'), NULL, NVL(FND_PROFILE.value('OZF_OFFR_CONFIDENTIAL_FLAG'), 'N'), p_confidential_flag),

211: DECODE( p_budget_offer_yn, 'Y','Y', 'N'),
212: DECODE( p_break_type, FND_API.g_miss_char, NULL, p_break_type),
213: DECODE( p_retroactive, FND_API.g_miss_char, NULL, p_retroactive),
214: DECODE( p_volume_offer_type, FND_API.g_miss_char, NULL, p_volume_offer_type),
215: DECODE( p_confidential_flag, FND_API.g_miss_char, NVL(FND_PROFILE.value('OZF_OFFR_CONFIDENTIAL_FLAG'), 'N'), NULL, NVL(FND_PROFILE.value('OZF_OFFR_CONFIDENTIAL_FLAG'), 'N'), p_confidential_flag),
216: DECODE(p_budget_source_type, FND_API.g_miss_char,NULL,p_budget_source_type),
217: DECODE(p_budget_source_id , FND_API.g_miss_num,NULL,p_budget_source_id),
218: DECODE(p_source_from_parent , FND_API.g_miss_char,NULL,p_source_from_parent),
219: DECODE(p_buyer_name , FND_API.g_miss_char,NULL,p_buyer_name),

Line 232: DECODE(p_fund_request_curr_code, FND_API.G_MISS_CHAR,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'),null, FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'),p_fund_request_curr_code)

228: DECODE(p_na_rule_header_id,FND_API.g_miss_num,NULL,p_na_rule_header_id),
229: DECODE(p_beneficiary_account_id,FND_API.g_miss_num,NULL,p_beneficiary_account_id),
230: DECODE(p_sales_method_flag,FND_API.g_miss_char,NULL,p_sales_method_flag),
231: DECODE(p_org_id,FND_API.g_miss_num,NULL,p_org_id),
232: DECODE(p_fund_request_curr_code, FND_API.G_MISS_CHAR,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'),null, FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'),p_fund_request_curr_code)
233: );
234: END Insert_Row;
235:
236:

Line 354: confidential_flag = DECODE( p_confidential_flag, FND_API.g_miss_char, confidential_flag, NULL, NVL(FND_PROFILE.value('OZF_OFFR_CONFIDENTIAL_FLAG'), 'N'), p_confidential_flag),

350: budget_offer_yn = DECODE( p_budget_offer_yn,'Y','Y', FND_API.g_miss_char, budget_offer_yn, 'N'),
351: break_type = DECODE( p_break_type, FND_API.g_miss_char, break_type, p_break_type),
352: retroactive = DECODE( p_retroactive, FND_API.g_miss_char, retroactive, p_retroactive),
353: volume_offer_type = DECODE( p_volume_offer_type, FND_API.g_miss_char, volume_offer_type, p_volume_offer_type),
354: confidential_flag = DECODE( p_confidential_flag, FND_API.g_miss_char, confidential_flag, NULL, NVL(FND_PROFILE.value('OZF_OFFR_CONFIDENTIAL_FLAG'), 'N'), p_confidential_flag),
355: budget_source_type = DECODE(p_budget_source_type,FND_API.g_miss_char,budget_source_type,p_budget_source_type),
356: budget_source_id = DECODE(p_budget_source_id , FND_API.g_miss_num,budget_source_id,p_budget_source_id),
357: source_from_parent = DECODE(p_source_from_parent , FND_API.g_miss_char,source_from_parent,p_source_from_parent),
358: buyer_name = DECODE(p_buyer_name , FND_API.g_miss_char,buyer_name,p_buyer_name),