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 57: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');

53: -- 08/01/2008 nirprasa fixed bug 7030415
54: ------------------------------------------------------------
55:
56: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_Adjustment_Ext_PVT';
57: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
58: g_order_gl_phase CONSTANT VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
59: g_debug_flag VARCHAR2 (1) := 'N';
60: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
61: g_bulk_limit CONSTANT NUMBER := 5000;

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

54: ------------------------------------------------------------
55:
56: g_pkg_name CONSTANT VARCHAR2 (30) := 'OZF_Adjustment_Ext_PVT';
57: g_recal_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('OZF_BUDGET_ADJ_ALLOW_RECAL'),'N');
58: g_order_gl_phase CONSTANT VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
59: g_debug_flag VARCHAR2 (1) := 'N';
60: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
61: g_bulk_limit CONSTANT NUMBER := 5000;
62:

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

1069: l_value VARCHAR2(1024);
1070: l_cntr NUMBER := 0;
1071: l_num_chars VARCHAR2(1024);
1072: l_sales_transaction_rec OZF_SALES_TRANSACTIONS_PVT.SALES_TRANSACTION_REC_TYPE;
1073: l_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
1074: l_sales_transaction_id NUMBER;
1075: l_gl_date DATE;
1076: l_shipment_date DATE;
1077: l_shipped_qty NUMBER;

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

1192: l_prod_attr_val :=l_order_line_tbl(j).inventory_item_id;
1193: IF l_cond_id_column IS NOT NULL THEN --if product context
1194:
1195: l_stmt := 'select ' || l_cond_id_column ||
1196: ' from mtl_system_items where ORGANIZATION_ID = FND_PROFILE.VALUE(''QP_ORGANIZATION_ID'') and inventory_item_id =:1 and rownum = 1';
1197: write_conc_log(l_stmt);
1198:
1199: OPEN l_product_val_cursor FOR l_stmt using l_prod_attr_val;
1200: LOOP

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

3571: l_conv_amount NUMBER;
3572: l_rate NUMBER;
3573:
3574: --profile: 'OZF: Create GL Entries for Orders' -- change as global constant by feliu on 06/21/2005
3575: -- l_order_gl_phase CONSTANT VARCHAR2 (15) := NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
3576:
3577: BEGIN
3578: x_return_status := fnd_api.g_ret_sts_success;
3579: