eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on FND_PROFILE

Line 79: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');

75: -- 01/16/2013 ninarasi Bug 16029659 - OFFER IN TRADE PLANNING CREATING IMPROPER ADJUSTMENTS
76: ---------------------------------------------------------------------------------------------------
77:
78: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_Adjustment_Ext_PVT';
79: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
80: g_order_gl_phase CONSTANT VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
81: g_debug_flag VARCHAR2 (1) := 'N';
82: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
83: -- 13579540 changed g_bulk_limit from 5k to 10k as per the discussion with performance team

Line 80: g_order_gl_phase CONSTANT VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');

76: ---------------------------------------------------------------------------------------------------
77:
78: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_Adjustment_Ext_PVT';
79: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
80: g_order_gl_phase CONSTANT VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
81: g_debug_flag VARCHAR2 (1) := 'N';
82: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
83: -- 13579540 changed g_bulk_limit from 5k to 10k as per the discussion with performance team
84: -- Also, we would want to see the performance on customer's instance and then decide on the

Line 1237: l_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');

1233: l_value VARCHAR2(1024);
1234: l_cntr NUMBER := 0;
1235: l_num_chars VARCHAR2(1024);
1236: l_sales_transaction_rec OZF_SALES_TRANSACTIONS_PVT.SALES_TRANSACTION_REC_TYPE;
1237: l_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
1238: l_sales_transaction_id NUMBER;
1239: l_gl_date DATE;
1240: l_shipment_date DATE;
1241: l_shipped_qty NUMBER;

Line 1367: ' from mtl_system_items where ORGANIZATION_ID = FND_PROFILE.VALUE(''QP_ORGANIZATION_ID'') and inventory_item_id =:1 and rownum = 1';

1363: l_prod_attr_val :=l_order_line_tbl(j).inventory_item_id;
1364: IF l_cond_id_column IS NOT NULL THEN --if product context
1365:
1366: l_stmt := 'select ' || l_cond_id_column ||
1367: ' from mtl_system_items where ORGANIZATION_ID = FND_PROFILE.VALUE(''QP_ORGANIZATION_ID'') and inventory_item_id =:1 and rownum = 1';
1368: write_conc_log(l_stmt);
1369:
1370: OPEN l_product_val_cursor FOR l_stmt using l_prod_attr_val;
1371: LOOP

Line 4209: l_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');

4205: l_api_name CONSTANT VARCHAR2(30) := 'Process_VO_Result';
4206: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
4207: l_return_status VARCHAR2(30);
4208:
4209: l_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
4210: l_sales_transaction_rec OZF_SALES_TRANSACTIONS_PVT.SALES_TRANSACTION_REC_TYPE;
4211: l_offer_info c_offer_info%ROWTYPE;
4212: l_sales_trans NUMBER;
4213: l_sales_transaction_id NUMBER;

Line 4279: ' from mtl_system_items where ORGANIZATION_ID = FND_PROFILE.VALUE(''QP_ORGANIZATION_ID'') and inventory_item_id =:1 and rownum = 1';

4275: l_prod_attr_val :=l_order_line_tbl(j).inventory_item_id;
4276: IF l_cond_id_column IS NOT NULL THEN --if product context
4277:
4278: l_stmt := 'select ' || l_cond_id_column ||
4279: ' from mtl_system_items where ORGANIZATION_ID = FND_PROFILE.VALUE(''QP_ORGANIZATION_ID'') and inventory_item_id =:1 and rownum = 1';
4280: write_conc_log(l_stmt);
4281:
4282: OPEN l_product_val_cursor FOR l_stmt using l_prod_attr_val;
4283: LOOP

Line 5065: l_column_name := FND_PROFILE.VALUE('OZF_ITEM_COST_COLUMN');

5061: ozf_utility_pvt.write_conc_log('l_act_budgets_rec.request_currency = ' || l_act_budgets_rec.request_currency);
5062: END IF;
5063:
5064: MO_GLOBAL.set_policy_context('S', l_order_org_id);
5065: l_column_name := FND_PROFILE.VALUE('OZF_ITEM_COST_COLUMN');
5066:
5067: IF l_column_name IS NOT NULL AND l_column_name <> FND_API.G_MISS_CHAR THEN
5068: l_stmt := 'SELECT ' || l_column_name ||' FROM oe_order_lines_all WHERE line_id = :1 AND org_id = :2';
5069: IF g_debug_flag = 'Y' THEN

Line 7614: -- l_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');

7610: l_conv_amount NUMBER;
7611: l_rate NUMBER;
7612:
7613: --profile: 'OZF: Create GL Entries for Orders' -- change as global constant by feliu on 06/21/2005
7614: -- l_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
7615:
7616: BEGIN
7617: x_return_status := fnd_api.g_ret_sts_success;
7618: