eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_PUBLISH dependencies on MSC_CL_COLLECTION

Line 2479: IF ( v_lrtype = 'P' AND p_po_enabled_flag = MSC_CL_COLLECTION.SYS_YES) THEN

2475: COMMIT;
2476:
2477: END IF;
2478:
2479: IF ( v_lrtype = 'P' AND p_po_enabled_flag = MSC_CL_COLLECTION.SYS_YES) THEN
2480:
2481: v_sql_stmt:=
2482: ' delete msc_sup_dem_entries msde'
2483: ||' where msde.publisher_id = 1'

Line 2497: IF ( v_lrtype = 'P' AND p_oh_enabled_flag = MSC_CL_COLLECTION.SYS_YES) THEN

2493: COMMIT;
2494:
2495: END IF;
2496:
2497: IF ( v_lrtype = 'P' AND p_oh_enabled_flag = MSC_CL_COLLECTION.SYS_YES) THEN
2498:
2499: v_sql_stmt:=
2500: ' delete msc_sup_dem_entries msde'
2501: ||' where msde.publisher_id = 1'

Line 2515: IF ( v_lrtype = 'P' AND p_so_enabled_flag = MSC_CL_COLLECTION.SYS_YES) THEN

2511: COMMIT;
2512:
2513: END IF;
2514:
2515: IF ( v_lrtype = 'P' AND p_so_enabled_flag = MSC_CL_COLLECTION.SYS_YES) THEN
2516:
2517: v_sql_stmt:=
2518: ' delete msc_sup_dem_entries msde'
2519: ||' where msde.publisher_id = 1'

Line 2602: (v_lrtype = 'I' AND p_po_enabled_flag = MSC_CL_COLLECTION.SYS_YES))

2598: RETURN;
2599: END;
2600:
2601: ELSIF (
2602: (v_lrtype = 'I' AND p_po_enabled_flag = MSC_CL_COLLECTION.SYS_YES))
2603: OR
2604: (v_lrtype = 'T' AND (nvl(p_po_enabled_flag, SYS_NO) = SYS_YES AND nvl(p_po_sn_flag, G_AUTO_NO_COLL) = G_AUTO_NET_COLL)
2605: ) THEN
2606:

Line 2652: (v_lrtype = 'P' AND p_po_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR

2648: --=======================
2649:
2650: IF ((v_lrtype = 'C') OR
2651: (v_lrtype = 'I') OR
2652: (v_lrtype = 'P' AND p_po_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR
2653: (v_lrtype = 'T' AND nvl(p_po_sn_flag, G_AUTO_NO_COLL) <> G_AUTO_NO_COLL )) THEN
2654:
2655: OPEN mscSupply(v_supply_refresh_number,
2656: p_sr_instance_id,

Line 3236: (v_lrtype = 'P' AND p_oh_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR

3232:
3233: ELSE
3234:
3235: IF ((v_lrtype = 'C') OR
3236: (v_lrtype = 'P' AND p_oh_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR
3237: (v_lrtype = 'T' AND nvl(p_oh_sn_flag, G_AUTO_NO_COLL) = G_AUTO_TAR_COLL)) THEN
3238:
3239: OPEN unallocOnhand (v_oh_refresh_number,
3240: p_sr_instance_id,

Line 3286: (v_lrtype = 'P' AND p_oh_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR

3282: --=======================================
3283:
3284: IF ((v_lrtype = 'C') OR
3285: (v_lrtype = 'I') OR
3286: (v_lrtype = 'P' AND p_oh_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR
3287: (v_lrtype = 'T' AND nvl(p_oh_sn_flag, G_AUTO_NO_COLL) <> G_AUTO_NO_COLL)) THEN
3288:
3289: LOG_MESSAGE('Total records fetched for UnAllocated Onhand:'||t_plan_id.COUNT);
3290:

Line 3619: (v_lrtype = 'P' AND p_oh_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR

3615:
3616: CLOSE allocOnhandNetChange;
3617: ELSE
3618: IF ((v_lrtype = 'C') OR
3619: (v_lrtype = 'P' AND p_oh_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR
3620: (v_lrtype = 'T' AND nvl(p_oh_sn_flag, G_AUTO_NO_COLL) = G_AUTO_TAR_COLL)) THEN
3621:
3622: OPEN allocOnhand (v_oh_refresh_number,
3623: p_sr_instance_id,

Line 3679: (v_lrtype = 'P' AND p_oh_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR

3675: --=======================================
3676:
3677: IF ((v_lrtype = 'C') OR
3678: (v_lrtype = 'I') OR
3679: (v_lrtype = 'P' AND p_oh_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR
3680: (v_lrtype = 'T' AND nvl(p_oh_sn_flag, G_AUTO_NO_COLL) <> G_AUTO_NO_COLL)) THEN
3681:
3682: LOG_MESSAGE('Total records fetched for Allocated Onhand:'||t_plan_id.COUNT);
3683:

Line 4202: (v_lrtype = 'P' AND p_so_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR

4198: -- Populate Sales Order Records
4199: --=============================
4200: IF ((v_lrtype = 'C') OR
4201: (v_lrtype = 'I') OR
4202: (v_lrtype = 'P' AND p_so_enabled_flag = MSC_CL_COLLECTION.SYS_YES) OR
4203: (v_lrtype = 'T' AND nvl(p_so_sn_flag, G_AUTO_NO_COLL) <> G_AUTO_NO_COLL)
4204: ) THEN
4205:
4206: BEGIN

Line 4762: (v_lrtype = 'P' AND p_sup_resp_flag = MSC_CL_COLLECTION.SYS_YES) OR

4758: --===============================================================================
4759:
4760: IF ((v_lrtype = 'C') OR
4761: (v_lrtype = 'I') OR
4762: (v_lrtype = 'P' AND p_sup_resp_flag = MSC_CL_COLLECTION.SYS_YES) OR
4763: (v_lrtype = 'T' AND nvl(p_suprep_sn_flag, G_AUTO_NO_COLL) <> G_AUTO_NO_COLL)
4764: ) THEN
4765:
4766: IF (v_lrtype = 'T' and nvl(p_suprep_sn_flag, G_AUTO_NO_COLL) <> G_AUTO_NO_COLL) THEN

Line 4797: if (p_so_enabled_flag = MSC_CL_COLLECTION.SYS_YES ) then

4793:
4794:
4795: ---=====================PRAGNESH=================================
4796:
4797: if (p_so_enabled_flag = MSC_CL_COLLECTION.SYS_YES ) then
4798:
4799: /* PS: added code to initialize the variables */
4800:
4801: t_pub := msc_sce_loads_pkg.publisherList();

Line 5994: /* IF (p_asl_enabled_flag = MSC_CL_COLLECTION.SYS_YES) THEN

5990: -- Publish ODS is done. Now we need to call API to compute
5991: -- average daily demand for VMI Items.
5992: ---- Not required from 11.5.10
5993: --======================================================================
5994: /* IF (p_asl_enabled_flag = MSC_CL_COLLECTION.SYS_YES) THEN
5995:
5996: BEGIN
5997:
5998: MSC_X_PLANNING.CALCULATE_AVERAGE_DEMAND;