APPS.MSC_CL_PULL dependencies on MSC_COLL_PARAMETERS

Line 870: FROM msc_coll_parameters

866: p_prec.delivery_details_flag,p_prec.ibuc_history_flag,p_prec.notes_attach_flag,
867: p_prec.eAM_info_flag, p_prec.eAM_forecasts_flag, p_prec.eam_fc_st_date, p_prec.eam_fc_end_date,
868: p_prec.cmro_flag, p_prec.cmro_forecasts_flag, p_prec.cmro_fc_st_date, p_prec.cmro_fc_end_date
869: ,p_prec.cmro_closed_wo,p_prec.osp_supply
870: FROM msc_coll_parameters
871: WHERE instance_id = p_instance_id;
872:
873: END GET_COLL_PARAM;
874:

Line 1004: msc_coll_parameters mcp

1000:
1001: cursor org IS
1002: select mio.organization_id org_id
1003: from msc_instance_orgs mio,
1004: msc_coll_parameters mcp
1005: where mio.sr_instance_id= p_instance_id
1006: and mcp.instance_id = p_instance_id
1007: and mio.enabled_flag= 1
1008: and (( mcp.org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or

Line 1574: FROM msc_coll_parameters

1570: ,prec.delivery_details_flag,prec.ibuc_history_flag,prec.notes_attach_flag,
1571: prec.eAM_info_flag, prec.eAM_forecasts_flag, prec.eam_fc_st_date, prec.eam_fc_end_date,
1572: prec.cmro_flag, prec.cmro_forecasts_flag, prec.cmro_fc_st_date, prec.cmro_fc_end_date, prec.cmro_closed_wo,
1573: prec.osp_supply
1574: FROM msc_coll_parameters
1575: WHERE instance_id = pINSTANCE_ID;
1576: end if;
1577:
1578:

Line 2285: UPDATE msc_coll_parameters

2281: END If;
2282:
2283:
2284: --bug#6126924 (bcaru)
2285: UPDATE msc_coll_parameters
2286: SET COLLECTIONS_START_TIME = sysdate
2287: WHERE INSTANCE_ID = pINSTANCE_ID;
2288:
2289:

Line 2375: FROM msc_coll_parameters

2371: -- Indicate the data pull type in MSC_APPS_INSTANCES
2372:
2373: SELECT count(*)
2374: INTO lv_param_rec_count
2375: FROM msc_coll_parameters
2376: WHERE instance_id = pINSTANCE_ID;
2377:
2378:
2379: IF lv_param_rec_count = 0 THEN

Line 2385: INSERT INTO msc_coll_parameters

2381: -- Initialize session information if no records
2382: -- found for the particular source_instance.
2383: --agmcont
2384:
2385: INSERT INTO msc_coll_parameters
2386: (INSTANCE_ID,org_group,threshold, delete_ods_data, supplier_capacity, atp_rules,
2387: bom, bor, calendar_check, demand_class, forecast, item,
2388: kpi_targets_bis, mds, mps, oh, parameter, planners,
2389: item_substitutes, projects, po, reservations, nra, safety_stock,

Line 2428: DELETE FROM msc_coll_parameters

2424: WHERE instance_id = pINSTANCE_ID;
2425:
2426: IF lv_coll_stat = MSC_UTIL.G_ST_EMPTY THEN
2427:
2428: DELETE FROM msc_coll_parameters
2429: WHERE instance_id = pINSTANCE_ID;
2430:
2431: -- If collection status is NOT in progress then
2432: -- delete old collection session info and insert

Line 2435: INSERT INTO msc_coll_parameters

2431: -- If collection status is NOT in progress then
2432: -- delete old collection session info and insert
2433: -- new collection session info.
2434:
2435: INSERT INTO msc_coll_parameters
2436: (INSTANCE_ID,org_group,threshold, delete_ods_data, supplier_capacity, atp_rules,
2437: bom, bor, calendar_check, demand_class, forecast, item,
2438: kpi_targets_bis, mds, mps, oh, parameter, planners,
2439: item_substitutes,projects, po, reservations, nra,

Line 2703: to be refreshed and this will be inserted into msc_coll_parameters*/

2699: lv_suprep_sn_flag,
2700: lv_trip_sn_flag );-- DRP
2701:
2702: /* The following will finally determine based on user settings whether the entity really needs
2703: to be refreshed and this will be inserted into msc_coll_parameters*/
2704: IF (prec.bom_flag = MSC_UTIL.SYS_YES) THEN
2705: prec.bom_sn_flag := lv_bom_sn_flag;
2706: ELSE
2707: prec.bom_sn_flag := MSC_UTIL.SYS_NO;

Line 2812: UPDATE msc_coll_parameters

2808: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, '*****************************************************************');
2809: -- agmcont:
2810:
2811:
2812: UPDATE msc_coll_parameters
2813: SET bom_sn_flag = prec.bom_sn_flag,
2814: bor_sn_flag = prec.bor_sn_flag,
2815: item_sn_flag = prec.item_sn_flag,
2816: oh_sn_flag = prec.oh_sn_flag,

Line 3032: UPDATE msc_coll_parameters

3028: 'SELECT sysdate FROM DUAL'||v_dblink;
3029:
3030: EXECUTE IMMEDIATE v_sql_stmt INTO lv_src_time;
3031:
3032: UPDATE msc_coll_parameters
3033: SET PULL_WRKR_START_TIME = lv_src_time
3034: WHERE INSTANCE_ID = pINSTANCE_ID;
3035: END;
3036:

Line 4297: lv_cont_coll_mode msc_coll_parameters.so_sn_flag%type;

4293:
4294: lv_staging_table_status NUMBER;
4295: lv_instance_enabled NUMBER;
4296: lv_refresh_type NUMBER;
4297: lv_cont_coll_mode msc_coll_parameters.so_sn_flag%type;
4298: lv_inv_ctp_val NUMBER := NVL(FND_PROFILE.Value('INV_CTP'),0);
4299: BEGIN
4300:
4301: ---===================== PULLING ====================

Line 4320: FROM msc_coll_parameters

4316: IF lv_refresh_type = MSC_UTIL.G_CONT THEN
4317: BEGIN
4318: SELECT so_sn_flag
4319: INTO lv_cont_coll_mode
4320: FROM msc_coll_parameters
4321: WHERE instance_id = pINSTANCE_ID;
4322: EXCEPTION
4323: WHEN others THEN
4324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, ERRBUF);