DBA Data[Home] [Help]

APPS.OZF_TP_ACCRUAL_PVT dependencies on FND_PROFILE

Line 20: G_PRC_DIFF_BUDGET NUMBER := FND_PROFILE.value('OZF_THRDPTY_PRCDIFF_BUDGET');

16:
17: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
18: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
19:
20: G_PRC_DIFF_BUDGET NUMBER := FND_PROFILE.value('OZF_THRDPTY_PRCDIFF_BUDGET');
21: G_TP_DEFAULT_PRICE_LIST NUMBER := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');
22: G_PRICING_SIM_EVENT VARCHAR2(30) := FND_PROFILE.value('OZF_PRICING_SIMULATION_EVENT');
23: G_ACCRUAL_ON_SELLING VARCHAR2(1) := FND_PROFILE.value('OZF_ACC_ON_SELLING_PRICE');
24: G_BULK_LIMIT NUMBER := NVL(FND_PROFILE.value('OZF_BULK_LIMIT_SIZE') , 500);

Line 21: G_TP_DEFAULT_PRICE_LIST NUMBER := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');

17: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
18: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
19:
20: G_PRC_DIFF_BUDGET NUMBER := FND_PROFILE.value('OZF_THRDPTY_PRCDIFF_BUDGET');
21: G_TP_DEFAULT_PRICE_LIST NUMBER := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');
22: G_PRICING_SIM_EVENT VARCHAR2(30) := FND_PROFILE.value('OZF_PRICING_SIMULATION_EVENT');
23: G_ACCRUAL_ON_SELLING VARCHAR2(1) := FND_PROFILE.value('OZF_ACC_ON_SELLING_PRICE');
24: G_BULK_LIMIT NUMBER := NVL(FND_PROFILE.value('OZF_BULK_LIMIT_SIZE') , 500);
25: G_ALLOW_INTER_COMMIT VARCHAR2(1) := NVL(FND_PROFILE.value('OZF_ALLOW_INTER_COMMIT'), 'Y');

Line 22: G_PRICING_SIM_EVENT VARCHAR2(30) := FND_PROFILE.value('OZF_PRICING_SIMULATION_EVENT');

18: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
19:
20: G_PRC_DIFF_BUDGET NUMBER := FND_PROFILE.value('OZF_THRDPTY_PRCDIFF_BUDGET');
21: G_TP_DEFAULT_PRICE_LIST NUMBER := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');
22: G_PRICING_SIM_EVENT VARCHAR2(30) := FND_PROFILE.value('OZF_PRICING_SIMULATION_EVENT');
23: G_ACCRUAL_ON_SELLING VARCHAR2(1) := FND_PROFILE.value('OZF_ACC_ON_SELLING_PRICE');
24: G_BULK_LIMIT NUMBER := NVL(FND_PROFILE.value('OZF_BULK_LIMIT_SIZE') , 500);
25: G_ALLOW_INTER_COMMIT VARCHAR2(1) := NVL(FND_PROFILE.value('OZF_ALLOW_INTER_COMMIT'), 'Y');
26: G_CONC_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

Line 23: G_ACCRUAL_ON_SELLING VARCHAR2(1) := FND_PROFILE.value('OZF_ACC_ON_SELLING_PRICE');

19:
20: G_PRC_DIFF_BUDGET NUMBER := FND_PROFILE.value('OZF_THRDPTY_PRCDIFF_BUDGET');
21: G_TP_DEFAULT_PRICE_LIST NUMBER := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');
22: G_PRICING_SIM_EVENT VARCHAR2(30) := FND_PROFILE.value('OZF_PRICING_SIMULATION_EVENT');
23: G_ACCRUAL_ON_SELLING VARCHAR2(1) := FND_PROFILE.value('OZF_ACC_ON_SELLING_PRICE');
24: G_BULK_LIMIT NUMBER := NVL(FND_PROFILE.value('OZF_BULK_LIMIT_SIZE') , 500);
25: G_ALLOW_INTER_COMMIT VARCHAR2(1) := NVL(FND_PROFILE.value('OZF_ALLOW_INTER_COMMIT'), 'Y');
26: G_CONC_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
27:

Line 24: G_BULK_LIMIT NUMBER := NVL(FND_PROFILE.value('OZF_BULK_LIMIT_SIZE') , 500);

20: G_PRC_DIFF_BUDGET NUMBER := FND_PROFILE.value('OZF_THRDPTY_PRCDIFF_BUDGET');
21: G_TP_DEFAULT_PRICE_LIST NUMBER := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');
22: G_PRICING_SIM_EVENT VARCHAR2(30) := FND_PROFILE.value('OZF_PRICING_SIMULATION_EVENT');
23: G_ACCRUAL_ON_SELLING VARCHAR2(1) := FND_PROFILE.value('OZF_ACC_ON_SELLING_PRICE');
24: G_BULK_LIMIT NUMBER := NVL(FND_PROFILE.value('OZF_BULK_LIMIT_SIZE') , 500);
25: G_ALLOW_INTER_COMMIT VARCHAR2(1) := NVL(FND_PROFILE.value('OZF_ALLOW_INTER_COMMIT'), 'Y');
26: G_CONC_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
27:
28: ---------------------------------------------------------------------

Line 25: G_ALLOW_INTER_COMMIT VARCHAR2(1) := NVL(FND_PROFILE.value('OZF_ALLOW_INTER_COMMIT'), 'Y');

21: G_TP_DEFAULT_PRICE_LIST NUMBER := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');
22: G_PRICING_SIM_EVENT VARCHAR2(30) := FND_PROFILE.value('OZF_PRICING_SIMULATION_EVENT');
23: G_ACCRUAL_ON_SELLING VARCHAR2(1) := FND_PROFILE.value('OZF_ACC_ON_SELLING_PRICE');
24: G_BULK_LIMIT NUMBER := NVL(FND_PROFILE.value('OZF_BULK_LIMIT_SIZE') , 500);
25: G_ALLOW_INTER_COMMIT VARCHAR2(1) := NVL(FND_PROFILE.value('OZF_ALLOW_INTER_COMMIT'), 'Y');
26: G_CONC_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
27:
28: ---------------------------------------------------------------------
29: -- FUNCTION

Line 1335: l_fund_id NUMBER:= G_PRC_DIFF_BUDGET; --fnd_profile.value('OZF_THRDPTY_PRCDIFF_BUDGET');

1331: AND b.status_code = 'DUPLICATED'
1332: AND b.duplicated_line_id = c.resale_line_id
1333: AND c.resale_header_id = a.resale_header_id;
1334:
1335: l_fund_id NUMBER:= G_PRC_DIFF_BUDGET; --fnd_profile.value('OZF_THRDPTY_PRCDIFF_BUDGET');
1336: l_id_type VARCHAR2(30);
1337:
1338: CURSOR batch_info_csr (p_id IN NUMBER) IS
1339: SELECT partner_cust_account_id,

Line 1910: l_default_price_list_id := G_TP_DEFAULT_PRICE_LIST; --fnd_profile.value('OZF_TP_ACCRUAL_PRICE_LIST');

1906: -- We need to UPDATE the order FROM indirect customers so that they're not to be included in the
1907: -- pricing simulation;
1908:
1909: -- Get profile value for price list
1910: l_default_price_list_id := G_TP_DEFAULT_PRICE_LIST; --fnd_profile.value('OZF_TP_ACCRUAL_PRICE_LIST');
1911:
1912: -- Define control rec
1913: -- setup pricing_event based on purpose code and profile
1914: -- privcing_event is based on profile

Line 1916: l_control_rec.pricing_event := fnd_profile.value('OZF_PRICING_SIMULATION_EVENT');

1912: -- Define control rec
1913: -- setup pricing_event based on purpose code and profile
1914: -- privcing_event is based on profile
1915:
1916: l_control_rec.pricing_event := fnd_profile.value('OZF_PRICING_SIMULATION_EVENT');
1917: IF l_control_rec.pricing_event is NULL THEN
1918: IF OZF_DEBUG_LOW_ON THEN
1919: ozf_utility_PVT.debug_message('pricing event default');
1920: END IF;

Line 1958: l_accrual_on_selling := G_ACCRUAL_ON_SELLING; --fnd_profile.value('OZF_ACC_ON_SELLING_PRICE');

1954: CLOSE header_id_csr;
1955:
1956: IF l_header_id_tbl.EXISTS(1) THEN
1957: -- setup price_flag based on profile
1958: l_accrual_on_selling := G_ACCRUAL_ON_SELLING; --fnd_profile.value('OZF_ACC_ON_SELLING_PRICE');
1959:
1960: -- If this profile is not set, we default the value to 'N'
1961:
1962: IF l_accrual_on_selling is NULL THEN

Line 3124: l_default_price_list_id := G_TP_DEFAULT_PRICE_LIST; --fnd_profile.value('OZF_TP_ACCRUAL_PRICE_LIST');

3120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3121: END IF;
3122:
3123: -- Get profile value for price list
3124: l_default_price_list_id := G_TP_DEFAULT_PRICE_LIST; --fnd_profile.value('OZF_TP_ACCRUAL_PRICE_LIST');
3125:
3126: -- Define control rec
3127: -- setup pricing_event based on purpose code and profile
3128: -- privcing_event is based on profile

Line 3132: l_control_rec.pricing_event := G_PRICING_SIM_EVENT; --fnd_profile.value('OZF_PRICING_SIMULATION_EVENT');

3128: -- privcing_event is based on profile
3129:
3130: -- We need to UPDATE the order FROM indirect customers so that they're not to be included in the
3131: -- pricing simulation;
3132: l_control_rec.pricing_event := G_PRICING_SIM_EVENT; --fnd_profile.value('OZF_PRICING_SIMULATION_EVENT');
3133: IF l_control_rec.pricing_event is NULL THEN
3134: l_control_rec.pricing_event := 'BATCH,BOOK,SHIP';
3135: ELSE
3136: IF l_control_rec.pricing_event = 'BATCH' THEN

Line 3171: l_accrual_on_selling := fnd_profile.value('OZF_ACC_ON_SELLING_PRICE');

3167: CLOSE order_num_csr;
3168:
3169: IF l_order_num_tbl.EXISTS(1) THEN
3170:
3171: l_accrual_on_selling := fnd_profile.value('OZF_ACC_ON_SELLING_PRICE');
3172:
3173: -- If this profile is not set, we default the value to 'N'
3174:
3175: IF l_accrual_on_selling IS NULL THEN