DBA Data[Home] [Help]

APPS.OZF_SD_BATCH_PVT dependencies on FND_PROFILE

Line 49: l_idsm_inv_org NUMBER :=fnd_profile.value('AMS_ITEM_ORGANIZATION_ID');

45: g_ret_level NUMBER := 0;
46:
47: type c_batch_header is REF CURSOR;
48: --Start:Added for Bug#9447673 Fix
49: l_idsm_inv_org NUMBER :=fnd_profile.value('AMS_ITEM_ORGANIZATION_ID');
50: --End:Added for Bug#9447673 Fix
51:
52:
53: --Start: Added for Bug#10011106 fix

Line 439: l_order_source_type :=fnd_profile.value('OZF_SSD_ON_IDSM');

435: Based on the Profile option OZF:Supplier Ship and Debit on Indirect Sales
436: batch types array is populated
437: */
438:
439: l_order_source_type :=fnd_profile.value('OZF_SSD_ON_IDSM');
440: IF l_order_source_type = 'Y' THEN
441: l_batch_types := BatchTypes('OM','IDSM');
442: ELSE
443: l_batch_types := BatchTypes('OM');

Line 1751: fnd_profile.value('AMS_CAMPAIGN_DEFAULT_CALENDER');

1747: SELECT start_date, end_date
1748: FROM gl_periods
1749: WHERE period_name = c_period and
1750: period_set_name =
1751: fnd_profile.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
1752:
1753: BEGIN
1754: l_batch_id := p_batch_id;
1755: l_org_id := p_org_id;

Line 1763: l_ozf_gl_entries := fnd_profile.value('OZF_ORDER_GLPOST_PHASE');

1759: l_fund_id := p_fund_id;
1760: l_start_date := p_start_date;
1761: l_end_date := p_end_date;
1762: l_period := p_period;
1763: l_ozf_gl_entries := fnd_profile.value('OZF_ORDER_GLPOST_PHASE');
1764: l_date := sysdate;
1765:
1766: IF l_ozf_gl_entries is null then
1767: l_ozf_gl_entries := 'SHIPPED';

Line 2620: fnd_profile.value('AMS_CAMPAIGN_DEFAULT_CALENDER');

2616: SELECT start_date, end_date
2617: FROM gl_periods
2618: WHERE period_name = c_period and
2619: period_set_name =
2620: fnd_profile.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
2621:
2622: BEGIN
2623: l_batch_id := p_batch_id;
2624: l_org_id := p_org_id;

Line 2632: l_ozf_gl_entries := fnd_profile.value('OZF_ORDER_GLPOST_PHASE');

2628: l_fund_id := p_fund_id;
2629: l_start_date := p_start_date;
2630: l_end_date := p_end_date;
2631: l_period := p_period;
2632: l_ozf_gl_entries := fnd_profile.value('OZF_ORDER_GLPOST_PHASE');
2633: l_date := sysdate;
2634:
2635: IF l_ozf_gl_entries is null then
2636: l_ozf_gl_entries := 'SHIPPED';