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 ---------------
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;
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 */
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;
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;