DBA Data[Home] [Help]

APPS.MSC_CL_COLLECTION dependencies on FND_PROFILE

Line 9: v_inv_ctp_val NUMBER := NVL(FND_PROFILE.Value('INV_CTP'),0);

5:
6: TYPE NumTblTyp IS TABLE OF NUMBER;
7: TYPE TblLstTyp IS TABLE OF VARCHAR2(30);
8: --------PROFILE OPTION VALUES ------------------------------------------
9: v_inv_ctp_val NUMBER := NVL(FND_PROFILE.Value('INV_CTP'),0);
10: G_MSC_DEBUG VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
11: G_DEG_PARALLEL NUMBER := to_number(fnd_profile.value('MSC_INDEX_PARALLEL_THREADS') );
12:
13: --------Instance information ---------------

Line 10: G_MSC_DEBUG VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');

6: TYPE NumTblTyp IS TABLE OF NUMBER;
7: TYPE TblLstTyp IS TABLE OF VARCHAR2(30);
8: --------PROFILE OPTION VALUES ------------------------------------------
9: v_inv_ctp_val NUMBER := NVL(FND_PROFILE.Value('INV_CTP'),0);
10: G_MSC_DEBUG VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
11: G_DEG_PARALLEL NUMBER := to_number(fnd_profile.value('MSC_INDEX_PARALLEL_THREADS') );
12:
13: --------Instance information ---------------
14: v_instance_id NUMBER;

Line 11: G_DEG_PARALLEL NUMBER := to_number(fnd_profile.value('MSC_INDEX_PARALLEL_THREADS') );

7: TYPE TblLstTyp IS TABLE OF VARCHAR2(30);
8: --------PROFILE OPTION VALUES ------------------------------------------
9: v_inv_ctp_val NUMBER := NVL(FND_PROFILE.Value('INV_CTP'),0);
10: G_MSC_DEBUG VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
11: G_DEG_PARALLEL NUMBER := to_number(fnd_profile.value('MSC_INDEX_PARALLEL_THREADS') );
12:
13: --------Instance information ---------------
14: v_instance_id NUMBER;
15: v_exchange_mode NUMBER:= 2; /* default to SYS_NO */

Line 43: G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');

39: v_chr13 VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(13);
40: v_sub_str VARCHAR2(32767):=NULL;
41: -- v_depot_org_str VARCHAR2(15000):='NULL';
42: -- v_non_depot_org_str VARCHAR2(15000):='NULL';
43: G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');
44: v_sourcing_flag NUMBER;
45: link_top_transaction_id_req BOOLEAN := FALSE;
46: G_MSC_CONFIGURATION VARCHAR2(240) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), 1);
47: SUPPLIES_INDEX_FAIL EXCEPTION;

Line 46: G_MSC_CONFIGURATION VARCHAR2(240) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), 1);

42: -- v_non_depot_org_str VARCHAR2(15000):='NULL';
43: G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');
44: v_sourcing_flag NUMBER;
45: link_top_transaction_id_req BOOLEAN := FALSE;
46: G_MSC_CONFIGURATION VARCHAR2(240) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), 1);
47: SUPPLIES_INDEX_FAIL EXCEPTION;
48: v_recalc_nra NUMBER;
49: v_bom_refresh_type NUMBER :=0;
50: v_discrete_flag NUMBER:= 2;