APPS.GME_POST_MIGRATION dependencies on FND_PROFILE

Line 4: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');

1: PACKAGE BODY gme_post_migration AS
2: /* $Header: GMEVRCBB.pls 120.20.12020000.4 2013/04/01 02:40:16 shalchen ship $ */
3: g_migration_run_id NUMBER;
4: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
5: PROCEDURE recreate_open_batches(err_buf OUT NOCOPY VARCHAR2,
6: ret_code OUT NOCOPY VARCHAR2) IS
7: l_api_name VARCHAR2(30) := 'RECREATE_OPEN_BATCHES';
8: l_item_rec mtl_system_items_vl%ROWTYPE;

Line 42: l_batch_prefix VARCHAR2(30) := FND_PROFILE.VALUE('GME_BATCH_PREFIX');

38: l_return_status VARCHAR2(1);
39: l_def_whse VARCHAR2(4);
40: l_subinventory VARCHAR2(10);
41: l_msg_data VARCHAR2(2000);
42: l_batch_prefix VARCHAR2(30) := FND_PROFILE.VALUE('GME_BATCH_PREFIX');
43: l_fpo_prefix VARCHAR2(30) := FND_PROFILE.VALUE('GME_FPO_PREFIX');
44: l_prefix VARCHAR2(30);
45: l_item_no VARCHAR2(32);
46:

Line 43: l_fpo_prefix VARCHAR2(30) := FND_PROFILE.VALUE('GME_FPO_PREFIX');

39: l_def_whse VARCHAR2(4);
40: l_subinventory VARCHAR2(10);
41: l_msg_data VARCHAR2(2000);
42: l_batch_prefix VARCHAR2(30) := FND_PROFILE.VALUE('GME_BATCH_PREFIX');
43: l_fpo_prefix VARCHAR2(30) := FND_PROFILE.VALUE('GME_FPO_PREFIX');
44: l_prefix VARCHAR2(30);
45: l_item_no VARCHAR2(32);
46:
47: l_primary_item_id NUMBER; -- Bug 13706812/13839066.

Line 2228: l_def_location VARCHAR2(100) := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

2224: l_lot_no VARCHAR2(32);
2225: l_sublot_no VARCHAR2(32);
2226: l_lot_number VARCHAR2(80);
2227: l_parent_lot_no VARCHAR2(80);
2228: l_def_location VARCHAR2(100) := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
2229: l_msg_data VARCHAR2(2000);
2230: l_txn_data VARCHAR2(2000);
2231: l_new_data VARCHAR2(2000);
2232:

Line 3262: l_def_location VARCHAR2(100) := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

3258: l_api_name VARCHAR2(30) := 'create_issue_receipt';
3259: l_organization_code VARCHAR2(3);
3260: l_org VARCHAR2(3);
3261: l_return_status VARCHAR2(1);
3262: l_def_location VARCHAR2(100) := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
3263: l_lot_number VARCHAR2(80);
3264: l_parent_lot_no VARCHAR2(80);
3265: l_msg_name VARCHAR2(32);
3266: l_msg_data VARCHAR2(2000);