DBA Data[Home] [Help]

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.9 2007/01/26 23:05:29 snene noship $ */
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: setup_failed EXCEPTION;

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: setup_failed EXCEPTION;
47: calc_mtl_req_date_err EXCEPTION;

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

2007: l_lot_no VARCHAR2(32);
2008: l_sublot_no VARCHAR2(32);
2009: l_lot_number VARCHAR2(80);
2010: l_parent_lot_no VARCHAR2(80);
2011: l_def_location VARCHAR2(100) := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
2012: l_msg_data VARCHAR2(2000);
2013: l_txn_data VARCHAR2(2000);
2014: l_new_data VARCHAR2(2000);
2015:

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

2845: l_api_name VARCHAR2(30) := 'create_issue_receipt';
2846: l_organization_code VARCHAR2(3);
2847: l_org VARCHAR2(3);
2848: l_return_status VARCHAR2(1);
2849: l_def_location VARCHAR2(100) := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
2850: l_lot_number VARCHAR2(80);
2851: l_parent_lot_no VARCHAR2(80);
2852: l_msg_name VARCHAR2(32);
2853: l_msg_data VARCHAR2(2000);