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: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');

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: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
28: G_ORDER_GL_PHASE VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');

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: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
28: G_ORDER_GL_PHASE VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
29: G_IDSM_PRICING_ADJ_BASIS VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_IDSM_PRICING_ADJ_BASIS'), 'ORDER_DATE');

Line 27: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');

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: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
28: G_ORDER_GL_PHASE VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
29: G_IDSM_PRICING_ADJ_BASIS VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_IDSM_PRICING_ADJ_BASIS'), 'ORDER_DATE');
30:
31:

Line 28: G_ORDER_GL_PHASE VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');

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: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
28: G_ORDER_GL_PHASE VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
29: G_IDSM_PRICING_ADJ_BASIS VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_IDSM_PRICING_ADJ_BASIS'), 'ORDER_DATE');
30:
31:
32: ---------------------------------------------------------------------

Line 29: G_IDSM_PRICING_ADJ_BASIS VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_IDSM_PRICING_ADJ_BASIS'), 'ORDER_DATE');

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: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
28: G_ORDER_GL_PHASE VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
29: G_IDSM_PRICING_ADJ_BASIS VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_IDSM_PRICING_ADJ_BASIS'), 'ORDER_DATE');
30:
31:
32: ---------------------------------------------------------------------
33: -- FUNCTION

Line 1169: l_ssd_on_idsm := fnd_profile.value('OZF_SSD_ON_IDSM');

1165: l_act_util_rec.discount_amount_currency_code := l_act_budgets_rec.request_currency;
1166: END IF;
1167:
1168: MO_GLOBAL.set_policy_context('S', l_adjustment_rec.org_id);
1169: l_ssd_on_idsm := fnd_profile.value('OZF_SSD_ON_IDSM');
1170: IF OZF_DEBUG_LOW_ON THEN
1171: ozf_utility_pvt.debug_message('l_ssd_on_idsm = ' || l_ssd_on_idsm);
1172: END IF;
1173:

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

1717: AND b.duplicated_line_id = c.resale_line_id
1718: AND c.resale_header_id = a.resale_header_id;
1719: */
1720:
1721: l_fund_id NUMBER:= G_PRC_DIFF_BUDGET; --fnd_profile.value('OZF_THRDPTY_PRCDIFF_BUDGET');
1722: l_id_type VARCHAR2(30);
1723:
1724: CURSOR batch_info_csr (p_id IN NUMBER) IS
1725: SELECT partner_cust_account_id,

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

2432: -- We need to UPDATE the order FROM indirect customers so that they're not to be included in the
2433: -- pricing simulation;
2434:
2435: -- Get profile value for price list
2436: l_default_price_list_id := G_TP_DEFAULT_PRICE_LIST; --fnd_profile.value('OZF_TP_ACCRUAL_PRICE_LIST');
2437:
2438: -- Define control rec
2439: -- setup pricing_event based on purpose code and profile
2440: -- privcing_event is based on profile

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

2438: -- Define control rec
2439: -- setup pricing_event based on purpose code and profile
2440: -- privcing_event is based on profile
2441:
2442: l_control_rec.pricing_event := fnd_profile.value('OZF_PRICING_SIMULATION_EVENT');
2443:
2444: IF l_control_rec.pricing_event is NULL THEN
2445: IF OZF_DEBUG_LOW_ON THEN
2446: ozf_utility_PVT.debug_message('pricing event default');

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

2481: CLOSE header_id_csr;
2482:
2483: IF l_header_id_tbl.EXISTS(1) THEN
2484: -- setup price_flag based on profile
2485: l_accrual_on_selling := G_ACCRUAL_ON_SELLING; --fnd_profile.value('OZF_ACC_ON_SELLING_PRICE');
2486:
2487: -- If this profile is not set, we default the value to 'N'
2488:
2489: IF l_accrual_on_selling is NULL THEN

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

3791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3792: END IF;
3793: END IF;
3794: -- Get profile value for price list
3795: l_default_price_list_id := G_TP_DEFAULT_PRICE_LIST; --fnd_profile.value('OZF_TP_ACCRUAL_PRICE_LIST');
3796:
3797: -- Define control rec
3798: -- setup pricing_event based on purpose code and profile
3799: -- privcing_event is based on profile

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

3799: -- privcing_event is based on profile
3800:
3801: -- We need to UPDATE the order FROM indirect customers so that they're not to be included in the
3802: -- pricing simulation;
3803: l_control_rec.pricing_event := G_PRICING_SIM_EVENT; --fnd_profile.value('OZF_PRICING_SIMULATION_EVENT');
3804: IF l_control_rec.pricing_event is NULL THEN
3805: l_control_rec.pricing_event := 'BATCH,BOOK,SHIP';
3806: ELSE
3807: IF l_control_rec.pricing_event = 'BATCH' THEN

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

3838: CLOSE order_num_csr;
3839:
3840: IF l_order_num_tbl.EXISTS(1) THEN
3841:
3842: l_accrual_on_selling := fnd_profile.value('OZF_ACC_ON_SELLING_PRICE');
3843:
3844: -- If this profile is not set, we default the value to 'N'
3845:
3846: IF l_accrual_on_selling IS NULL THEN

Line 4971: l_partner_party_id := FND_PROFILE.VALUE('OZF_IDSM_ORDER_SRC_PARTY_ID');

4967: Checking the profile of partner party and if it same
4968: as that of the party uploading the batch then the batch is considered
4969: as the direct batch. i.e., setting the direct_order_flag as 'Y'
4970: */
4971: l_partner_party_id := FND_PROFILE.VALUE('OZF_IDSM_ORDER_SRC_PARTY_ID');
4972:
4973: IF l_party_id = l_partner_party_id THEN
4974: l_direct_order_flag := 'Y';
4975: END IF;