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.RLM_MANAGE_DEMAND_SV dependencies on RLM_DP_SV

Line 18: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

14: ===========================================================================*/
15:
16: PROCEDURE ManageDemand(x_InterfaceHeaderId IN NUMBER,
17: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
18: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
19: x_ReturnStatus OUT NOCOPY NUMBER)
20: IS
21: --
22: v_Progress VARCHAR2(30) := '010';

Line 24: v_SrcGroup_rec rlm_dp_sv.t_Group_rec;

20: IS
21: --
22: v_Progress VARCHAR2(30) := '010';
23: v_SrcGroup_ref t_Cursor_ref;
24: v_SrcGroup_rec rlm_dp_sv.t_Group_rec;
25: v_SourcedDemand_Tab t_MD_Tab;
26: v_HeaderLockStatus NUMBER;
27: v_LineLockStatus NUMBER;
28: e_headerLocked EXCEPTION;

Line 245: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

241:
242: ===========================================================================*/
243:
244: PROCEDURE ManageGroupDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
245: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
246: x_ReturnStatus OUT NOCOPY NUMBER)
247: IS
248: --
249: v_Progress VARCHAR2(30) := '010';

Line 404: x_Group_rec IN rlm_dp_sv.t_Group_rec)

400:
401: ===========================================================================*/
402:
403: PROCEDURE PopulateLastReceiptRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
404: x_Group_rec IN rlm_dp_sv.t_Group_rec)
405: IS
406: --
407: CURSOR c_LastReceipt IS
408: SELECT x_group_rec.customer_id,

Line 489: x_Group_rec IN rlm_dp_sv.t_Group_rec)

485:
486: ===========================================================================*/
487:
488: PROCEDURE PopulateCUMRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
489: x_Group_rec IN rlm_dp_sv.t_Group_rec)
490: IS
491: --Created cursor for Bugfix 7007638
492: CURSOR c_CUMRec IS
493: SELECT x_group_rec.customer_id,

Line 638: x_Group_rec IN rlm_dp_sv.t_Group_rec,

634:
635: ===========================================================================*/
636:
637: PROCEDURE PopulateMD(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
638: x_Group_rec IN rlm_dp_sv.t_Group_rec,
639: x_IncludeCUM IN VARCHAR2)
640: IS
641: --
642: CURSOR c_Demand IS

Line 754: PROCEDURE UOMConversion(x_Group_rec IN rlm_dp_sv.t_Group_rec)

750: PROCEDURE NAME: UOMConversion
751:
752: ===========================================================================*/
753:
754: PROCEDURE UOMConversion(x_Group_rec IN rlm_dp_sv.t_Group_rec)
755: IS
756:
757: v_Count NUMBER := 1;
758: v_CustomerUOMCode VARCHAR2(30) := NULL;

Line 791: x_Group_rec IN rlm_dp_sv.t_Group_rec)

787:
788: ===========================================================================*/
789:
790: PROCEDURE CUMDiscrepancyCheck( x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
791: x_Group_rec IN rlm_dp_sv.t_Group_rec)
792: IS
793: --
794: v_ReturnStatus VARCHAR2(30) := 'SUCCESS';
795: v_Progress VARCHAR2(3) := '010';

Line 1428: x_Group_rec IN rlm_dp_sv.t_Group_rec)

1424:
1425: ===========================================================================*/
1426:
1427: PROCEDURE CUMToDiscrete(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1428: x_Group_rec IN rlm_dp_sv.t_Group_rec)
1429: IS
1430: --
1431: v_current_rec NUMBER;
1432: v_EarlierDiscreteQty NUMBER := 0;

Line 1948: x_Group_rec IN rlm_dp_sv.t_Group_rec,

1944: PROCEDURE NAME: ApplySourceRules
1945:
1946: ===========================================================================*/
1947: PROCEDURE ApplySourceRules(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
1948: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1949: x_SourcedDemand_tab OUT NOCOPY rlm_manage_demand_sv.t_MD_Tab,
1950: x_Source_Tab OUT NOCOPY rlm_manage_demand_sv.t_Source_Tab)
1951: IS
1952: --

Line 1982: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND

1978: AND mislv.source_type IN (1,2)
1979: --Bugfix 10053830 Start
1980: /*AND (SYSDATE BETWEEN mislv.effective_date AND
1981: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
1982: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND
1983: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
1984: --Bugfix 10053830 End
1985: AND mislv.rank = x_rank
1986: AND mislv.ship_to_site_id = x_ship_to_site_id

Line 1983: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397

1979: --Bugfix 10053830 Start
1980: /*AND (SYSDATE BETWEEN mislv.effective_date AND
1981: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
1982: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND
1983: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
1984: --Bugfix 10053830 End
1985: AND mislv.rank = x_rank
1986: AND mislv.ship_to_site_id = x_ship_to_site_id
1987: AND exists (SELECT null

Line 2010: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND

2006: AND mislv.source_type IN (1,2)
2007: --Bugfix 10053830 Start
2008: /*AND (SYSDATE BETWEEN mislv.effective_date AND
2009: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2010: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND
2011: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2012: --Bugfix 10053830 End
2013: AND mislv.rank = x_rank
2014: AND mislv.ship_to_site_id = x_ship_to_site_id

Line 2011: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397

2007: --Bugfix 10053830 Start
2008: /*AND (SYSDATE BETWEEN mislv.effective_date AND
2009: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2010: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND
2011: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2012: --Bugfix 10053830 End
2013: AND mislv.rank = x_rank
2014: AND mislv.ship_to_site_id = x_ship_to_site_id
2015: AND exists (SELECT null

Line 2029: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date

2025: AND mislv.source_type IN (1,2)
2026: --Bugfix 10053830 Start
2027: /* AND (SYSDATE BETWEEN mislv.effective_date
2028: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2029: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date
2030: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2031: --Bugfix 10053830 End
2032: AND mislv.ship_to_site_id = x_Group_rec.ship_to_site_use_id
2033: AND exists (SELECT null

Line 2030: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397

2026: --Bugfix 10053830 Start
2027: /* AND (SYSDATE BETWEEN mislv.effective_date
2028: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2029: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date
2030: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2031: --Bugfix 10053830 End
2032: AND mislv.ship_to_site_id = x_Group_rec.ship_to_site_use_id
2033: AND exists (SELECT null
2034: FROM msc_sourcing_rules

Line 2046: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date

2042: AND mislv.source_type IN (1,2)
2043: --Bugfix 10053830 Start
2044: /*AND (SYSDATE BETWEEN mislv.effective_date
2045: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2046: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date
2047: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2048: --Bugfix 10053830 End
2049: AND mislv.ship_to_site_id = x_Group_rec.ship_to_site_use_id
2050: AND exists (SELECT null

Line 2047: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397

2043: --Bugfix 10053830 Start
2044: /*AND (SYSDATE BETWEEN mislv.effective_date
2045: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2046: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date
2047: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2048: --Bugfix 10053830 End
2049: AND mislv.ship_to_site_id = x_Group_rec.ship_to_site_use_id
2050: AND exists (SELECT null
2051: FROM mrp_sourcing_rules

Line 2076: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND

2072: AND mislv.source_type IN (1,2)
2073: --Bugfix 10053830 Start
2074: /*AND (SYSDATE BETWEEN mislv.effective_date AND
2075: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2076: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND
2077: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2078: --Bugfix 10053830 End
2079: AND mislv.rank = x_rank
2080: AND exists (SELECT null

Line 2077: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397

2073: --Bugfix 10053830 Start
2074: /*AND (SYSDATE BETWEEN mislv.effective_date AND
2075: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2076: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND
2077: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2078: --Bugfix 10053830 End
2079: AND mislv.rank = x_rank
2080: AND exists (SELECT null
2081: FROM msc_sourcing_rules

Line 2104: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND

2100: AND mislv.source_type IN (1,2)
2101: --Bugfix 10053830 Start
2102: /*AND (SYSDATE BETWEEN mislv.effective_date AND
2103: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2104: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND
2105: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2106: --Bugfix 10053830 End
2107: AND mislv.rank = x_rank
2108: AND exists (SELECT null

Line 2105: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397

2101: --Bugfix 10053830 Start
2102: /*AND (SYSDATE BETWEEN mislv.effective_date AND
2103: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2104: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date AND
2105: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2106: --Bugfix 10053830 End
2107: AND mislv.rank = x_rank
2108: AND exists (SELECT null
2109: FROM mrp_sourcing_rules

Line 2124: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date

2120: AND mislv.source_type IN (1,2)
2121: --Bugfix 10053830 Start
2122: /*AND (SYSDATE BETWEEN mislv.effective_date
2123: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2124: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date
2125: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2126: --Bugfix 10053830 End
2127: AND exists (SELECT null
2128: FROM msc_sourcing_rules

Line 2125: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397

2121: --Bugfix 10053830 Start
2122: /*AND (SYSDATE BETWEEN mislv.effective_date
2123: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2124: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date
2125: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2126: --Bugfix 10053830 End
2127: AND exists (SELECT null
2128: FROM msc_sourcing_rules
2129: WHERE sourcing_rule_id = mislv.sourcing_rule_id

Line 2142: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date

2138: AND mislv.source_type IN (1,2)
2139: --Bugfix 10053830 Start
2140: /*AND (SYSDATE BETWEEN mislv.effective_date
2141: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2142: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date
2143: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2144: --Bugfix 10053830 End
2145: AND exists (SELECT null
2146: FROM mrp_sourcing_rules

Line 2143: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397

2139: --Bugfix 10053830 Start
2140: /*AND (SYSDATE BETWEEN mislv.effective_date
2141: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397*/
2142: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date
2143: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2144: --Bugfix 10053830 End
2145: AND exists (SELECT null
2146: FROM mrp_sourcing_rules
2147: WHERE sourcing_rule_id = mislv.sourcing_rule_id

Line 2159: v_tmpGroup_rec rlm_dp_sv.t_Group_Rec;

2155: e_NoSrcRulesSetup EXCEPTION;
2156: e_NoSrItemId EXCEPTION;
2157: v_org_found BOOLEAN DEFAULT FALSE;
2158: v_current_rec NUMBER;
2159: v_tmpGroup_rec rlm_dp_sv.t_Group_Rec;
2160: v_count_msc NUMBER DEFAULT 0;
2161: v_count_mrp NUMBER DEFAULT 0;
2162: v_normal_source VARCHAR2(3) DEFAULT 'MSC';
2163: v_source_level VARCHAR2(4) DEFAULT 'SITE'; -- possible values 'SITE', 'ITEM', 'PRFL'

Line 2417: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND

2413: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id
2414: --Bugfix 10053830 Start
2415: /*AND (SYSDATE BETWEEN effective_date AND
2416: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397 */
2417: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND
2418: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397
2419: --Bugfix 10053830 End
2420: --
2421: IF (l_debug <> -1) THEN

Line 2418: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397

2414: --Bugfix 10053830 Start
2415: /*AND (SYSDATE BETWEEN effective_date AND
2416: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397 */
2417: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND
2418: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397
2419: --Bugfix 10053830 End
2420: --
2421: IF (l_debug <> -1) THEN
2422: rlm_core_sv.dlog(C_DEBUG, 'MSC Site: Minimum sourcing level', v_srcng_lvl);

Line 2456: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND

2452: AND inventory_item_id = sr_item_id
2453: --Bugfix 10053830 Start
2454: /*AND (SYSDATE BETWEEN effective_date AND
2455: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397 */
2456: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND
2457: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397
2458: --Bugfix 10053830 End
2459: --
2460: IF (l_debug <> -1) THEN

Line 2457: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397

2453: --Bugfix 10053830 Start
2454: /*AND (SYSDATE BETWEEN effective_date AND
2455: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397 */
2456: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND
2457: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397
2458: --Bugfix 10053830 End
2459: --
2460: IF (l_debug <> -1) THEN
2461: rlm_core_sv.dlog(C_DEBUG, 'MSC Item: Minimum sourcing level', v_srcng_lvl);

Line 2495: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND

2491: AND ship_to_site_id = x_Group_rec.ship_to_site_use_id
2492: --Bugfix 10053830 Start
2493: /*AND (SYSDATE BETWEEN effective_date AND
2494: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397 */
2495: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND
2496: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397
2497: --Bugfix 10053830 End
2498: --
2499: IF (l_debug <> -1) THEN

Line 2496: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397

2492: --Bugfix 10053830 Start
2493: /*AND (SYSDATE BETWEEN effective_date AND
2494: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397 */
2495: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND
2496: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397
2497: --Bugfix 10053830 End
2498: --
2499: IF (l_debug <> -1) THEN
2500: rlm_core_sv.dlog(C_DEBUG, 'MRP Site: Minimum sourcing level', v_srcng_lvl);

Line 2535: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND

2531: AND inventory_item_id = x_Group_rec.inventory_item_id
2532: --Bugfix 10053830 Start
2533: /*AND (SYSDATE BETWEEN effective_date AND
2534: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397 */
2535: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND
2536: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397
2537: --Bugfix 10053830 End
2538: --
2539: IF (l_debug <> -1) THEN

Line 2536: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397

2532: --Bugfix 10053830 Start
2533: /*AND (SYSDATE BETWEEN effective_date AND
2534: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR SYSDATE < effective_date); --Bugfix 6051397 */
2535: AND (rlm_dp_sv.g_dsp_start_time BETWEEN effective_date AND
2536: NVL(disable_date, TO_DATE('31/12/4712', 'DD/MM/YYYY')) OR rlm_dp_sv.g_dsp_start_time < effective_date); --Bugfix 6051397
2537: --Bugfix 10053830 End
2538: --
2539: IF (l_debug <> -1) THEN
2540: rlm_core_sv.dlog(C_DEBUG, 'MRP Item: Minimum sourcing level', v_srcng_lvl);

Line 2932: x_Group_rec IN rlm_dp_sv.t_Group_rec)

2928:
2929: ===========================================================================*/
2930:
2931: PROCEDURE CalculateShipDate(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
2932: x_Group_rec IN rlm_dp_sv.t_Group_rec)
2933: IS
2934:
2935: i NUMBER;
2936: j NUMBER;

Line 3271: x_Group_rec IN rlm_dp_sv.t_Group_rec,

3267:
3268: ===========================================================================*/
3269:
3270: PROCEDURE ApplyFFFFences(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3271: x_Group_rec IN rlm_dp_sv.t_Group_rec,
3272: IsLineProcessed IN OUT NOCOPY BOOLEAN)
3273: IS
3274:
3275: i NUMBER;

Line 3292: v_Group_rec rlm_dp_sv.t_Group_rec;

3288: v_Progress VARCHAR2(3) := '010';
3289: -- Bug 4297984
3290: v_MatchAttrTxt VARCHAR2(2000);
3291: v_match_rec RLM_RD_SV.t_generic_rec;
3292: v_Group_rec rlm_dp_sv.t_Group_rec;
3293:
3294: BEGIN
3295: --
3296: IF (l_debug <> -1) THEN

Line 3302: rlm_core_sv.dlog(C_DEBUG,'TRUNC(rlm_dp_sv.g_dsp_start_time)',

3298: rlm_core_sv.dlog(C_DEBUG,' x_Sched_rec.Schedule_type',
3299: x_Sched_rec.Schedule_type);
3300: rlm_core_sv.dlog(C_DEBUG,'TRUNC(SYSDATE)',
3301: TRUNC(SYSDATE));
3302: rlm_core_sv.dlog(C_DEBUG,'TRUNC(rlm_dp_sv.g_dsp_start_time)',
3303: TRUNC(rlm_dp_sv.g_dsp_start_time)); --Bugfix 10053830
3304: rlm_core_sv.dlog(C_DEBUG,' x_Sched_rec.sched_horizon_start_date',
3305: x_Sched_rec.sched_horizon_start_date);
3306: rlm_core_sv.dlog(C_DEBUG,' x_Sched_rec.sched_horizon_end_date',

Line 3303: TRUNC(rlm_dp_sv.g_dsp_start_time)); --Bugfix 10053830

3299: x_Sched_rec.Schedule_type);
3300: rlm_core_sv.dlog(C_DEBUG,'TRUNC(SYSDATE)',
3301: TRUNC(SYSDATE));
3302: rlm_core_sv.dlog(C_DEBUG,'TRUNC(rlm_dp_sv.g_dsp_start_time)',
3303: TRUNC(rlm_dp_sv.g_dsp_start_time)); --Bugfix 10053830
3304: rlm_core_sv.dlog(C_DEBUG,' x_Sched_rec.sched_horizon_start_date',
3305: x_Sched_rec.sched_horizon_start_date);
3306: rlm_core_sv.dlog(C_DEBUG,' x_Sched_rec.sched_horizon_end_date',
3307: x_Sched_rec.sched_horizon_end_date);

Line 3445: TRUNC(rlm_dp_sv.g_dsp_start_time) ) THEN --Bugfix 10053830

3441: END IF;
3442: --
3443: IF (g_ManageDemand_tab(i).request_date <
3444: --TRUNC(SYSDATE) ) THEN --{ --Bugfix 10053830
3445: TRUNC(rlm_dp_sv.g_dsp_start_time) ) THEN --Bugfix 10053830
3446: --
3447: --pdue
3448: IF x_sched_rec.schedule_source <> 'MANUAL' THEN --{
3449: --

Line 3531: x_value5 => rlm_dp_sv.g_dsp_start_time, --Bugfix 10053830

3527: x_value3 => g_ManageDemand_tab(i).request_date,
3528: x_token4 => 'START_DATE_TIME',
3529: x_value4 => to_date(g_ManageDemand_tab(i).industry_attribute2,'YYYY/MM/DD HH24:MI:SS'),
3530: x_token5 => 'PROCDATE',
3531: x_value5 => rlm_dp_sv.g_dsp_start_time, --Bugfix 10053830
3532: x_Token6 => 'SEQ_INFO',
3533: x_value6 => nvl(g_ManageDemand_tab(i).cust_production_seq_num,'NULL') || '-' ||
3534: nvl(g_ManageDemand_tab(i).cust_model_serial_number,'NULL')|| '-' ||
3535: nvl(g_ManageDemand_tab(i).customer_job,'NULL'),

Line 3567: x_value5 => rlm_dp_sv.g_dsp_start_time, --Bugfix 10053830

3563: x_value3 => g_ManageDemand_tab(i).request_date,
3564: x_token4 => 'START_DATE_TIME',
3565: x_value4 => to_date(g_ManageDemand_tab(i).industry_attribute2,'YYYY/MM/DD HH24:MI:SS'),
3566: x_token5 => 'PROCDATE',
3567: x_value5 => rlm_dp_sv.g_dsp_start_time, --Bugfix 10053830
3568: x_Token6 => 'SCHEDULE_LINE',
3569: x_value6 => rlm_core_sv.get_schedule_line_number(g_ManageDemand_tab(i).schedule_line_id),
3570: x_Token7 => 'MATCH_ATTR',
3571: x_value7 => v_MatchAttrTxt);

Line 3631: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayFrom - 1) AND

3627: IF (g_ManageDemand_tab(i).request_date BETWEEN
3628: --Bugfix 10053830 Start
3629: /*(TRUNC(SYSDATE) + v_MRPFenceDayFrom - 1) AND
3630: (TRUNC(SYSDATE) + v_MRPFenceDayTo - 1)) THEN --{*/
3631: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayFrom - 1) AND
3632: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo - 1)) THEN --{
3633: --Bugfix 10053830 End
3634: --
3635: IF (l_debug <> -1) THEN

Line 3632: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo - 1)) THEN --{

3628: --Bugfix 10053830 Start
3629: /*(TRUNC(SYSDATE) + v_MRPFenceDayFrom - 1) AND
3630: (TRUNC(SYSDATE) + v_MRPFenceDayTo - 1)) THEN --{*/
3631: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayFrom - 1) AND
3632: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo - 1)) THEN --{
3633: --Bugfix 10053830 End
3634: --
3635: IF (l_debug <> -1) THEN
3636: rlm_core_sv.dlog(C_DEBUG, 'request date is within MRP fences');

Line 3676: g_ManageDemand_tab(i).request_date < (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FirmFenceDayTo) )--Bugfix 10053830

3672: -- Bug 4207235
3673: --
3674: IF ( v_FrozenFenceDays is NOT NULL AND
3675: --g_ManageDemand_tab(i).request_date < (TRUNC(SYSDATE) + v_FirmFenceDayTo) )--Bugfix 10053830
3676: g_ManageDemand_tab(i).request_date < (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FirmFenceDayTo) )--Bugfix 10053830
3677: OR
3678: ( v_FrozenFenceDays is NULL AND
3679: --Bugfix 10053830 Start
3680: /*g_ManageDemand_tab(i).request_date < (TRUNC(SYSDATE) + v_FirmFenceDayTo) AND

Line 3682: g_ManageDemand_tab(i).request_date < (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FirmFenceDayTo) AND

3678: ( v_FrozenFenceDays is NULL AND
3679: --Bugfix 10053830 Start
3680: /*g_ManageDemand_tab(i).request_date < (TRUNC(SYSDATE) + v_FirmFenceDayTo) AND
3681: g_ManageDemand_tab(i).request_date >=(TRUNC(SYSDATE) + v_FirmFenceDayFrom - 1) ) THEN --{*/
3682: g_ManageDemand_tab(i).request_date < (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FirmFenceDayTo) AND
3683: g_ManageDemand_tab(i).request_date >=(TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FirmFenceDayFrom - 1) ) THEN --{
3684: --Bugfix 10053830 Start
3685: --
3686: IF (l_debug <> -1) THEN

Line 3683: g_ManageDemand_tab(i).request_date >=(TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FirmFenceDayFrom - 1) ) THEN --{

3679: --Bugfix 10053830 Start
3680: /*g_ManageDemand_tab(i).request_date < (TRUNC(SYSDATE) + v_FirmFenceDayTo) AND
3681: g_ManageDemand_tab(i).request_date >=(TRUNC(SYSDATE) + v_FirmFenceDayFrom - 1) ) THEN --{*/
3682: g_ManageDemand_tab(i).request_date < (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FirmFenceDayTo) AND
3683: g_ManageDemand_tab(i).request_date >=(TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FirmFenceDayFrom - 1) ) THEN --{
3684: --Bugfix 10053830 Start
3685: --
3686: IF (l_debug <> -1) THEN
3687: rlm_core_sv.dlog(C_DEBUG,'request_date within firm fence');

Line 3695: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FirmFenceDayTo)) THEN --}{ --Bugfix 10053830

3691: SetOperation(g_ManageDemand_tab(i), k_UPDATE);
3692: --
3693: ELSIF (g_ManageDemand_tab(i).request_date >=
3694: --(TRUNC(SYSDATE) + v_FirmFenceDayTo)) THEN --}{ --Bugfix 10053830
3695: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FirmFenceDayTo)) THEN --}{ --Bugfix 10053830
3696: --
3697: IF (l_debug <> -1) THEN
3698: rlm_core_sv.dlog(C_DEBUG,'request_date outside firm fence');
3699: END IF;

Line 3718: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_ForecastFenceDayTo))THEN --{ --Bugfix 10053830

3714: END IF;
3715: --
3716: IF(g_ManageDemand_tab(i).request_date <
3717: --(TRUNC(SYSDATE) + v_ForecastFenceDayTo))THEN --{ --Bugfix 10053830
3718: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_ForecastFenceDayTo))THEN --{ --Bugfix 10053830
3719: --
3720: IF (l_debug <> -1) THEN
3721: rlm_core_sv.dlog(C_DEBUG,'request_date inside oe forecast fence');
3722: END IF;

Line 3729: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_ForecastFenceDayTo))THEN --}{ --Bugfix 10053830

3725: SetOperation(g_ManageDemand_tab(i), k_UPDATE);
3726: --
3727: ELSIF(g_ManageDemand_tab(i).request_date >=
3728: --(TRUNC(SYSDATE) + v_ForecastFenceDayTo))THEN --}{ --Bugfix 10053830
3729: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_ForecastFenceDayTo))THEN --}{ --Bugfix 10053830
3730: --
3731: IF (l_debug <> -1) THEN
3732: rlm_core_sv.dlog(C_DEBUG,'request_date outside oe forecast fence');
3733: END IF;

Line 3747: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --{ --Bugfix 10053830

3743: ELSIF v_MRPFenceDays is NOT NULL THEN --}{
3744: --
3745: IF (g_ManageDemand_tab(i).request_date <
3746: --(TRUNC(SYSDATE) + v_MRPFenceDayTo)) THEN --{ --Bugfix 10053830
3747: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --{ --Bugfix 10053830
3748: --
3749: IF (l_debug <> -1) THEN
3750: rlm_core_sv.dlog(C_DEBUG,
3751: 'request_date inside MRP forecast fence');

Line 3759: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830

3755: SetOperation(g_ManageDemand_tab(i), k_UPDATE);
3756: --
3757: ELSIF (g_ManageDemand_tab(i).request_date >=
3758: --(TRUNC(SYSDATE) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830
3759: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830
3760: --
3761: IF (l_debug <> -1) THEN
3762: rlm_core_sv.dlog(C_DEBUG,
3763: 'request_date outside MRP forecast fence');

Line 3815: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayFrom - 1) AND

3811: IF (g_ManageDemand_tab(i).request_date BETWEEN
3812: --Bugfix 10053830 Start
3813: /*(TRUNC(SYSDATE) + v_MRPFenceDayFrom - 1) AND
3814: (TRUNC(SYSDATE) + v_MRPFenceDayTo - 1)) THEN --{*/
3815: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayFrom - 1) AND
3816: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo - 1)) THEN --{
3817: --Bugfix 10053830 Start
3818: --
3819: IF (l_debug <> -1) THEN

Line 3816: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo - 1)) THEN --{

3812: --Bugfix 10053830 Start
3813: /*(TRUNC(SYSDATE) + v_MRPFenceDayFrom - 1) AND
3814: (TRUNC(SYSDATE) + v_MRPFenceDayTo - 1)) THEN --{*/
3815: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayFrom - 1) AND
3816: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo - 1)) THEN --{
3817: --Bugfix 10053830 Start
3818: --
3819: IF (l_debug <> -1) THEN
3820: rlm_core_sv.dlog(C_DEBUG,

Line 3829: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830

3825: SetOperation(g_ManageDemand_tab(i), k_UPDATE);
3826: --
3827: ELSIF (g_ManageDemand_tab(i).request_date >=
3828: --(TRUNC(SYSDATE) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830
3829: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830
3830: --
3831: IF (l_debug <> -1) THEN
3832: rlm_core_sv.dlog(C_DEBUG,
3833: 'request_date outside MRP forecast fence');

Line 3891: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_ForecastFenceDayTo))

3887: (g_ManageDemand_tab(i).request_date >=
3888: (TRUNC(SYSDATE) +
3889: v_ForecastFenceDayFrom - 1)) THEN --{*/
3890: IF (g_ManageDemand_tab(i).request_date <
3891: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_ForecastFenceDayTo))
3892: AND
3893: (g_ManageDemand_tab(i).request_date >=
3894: (TRUNC(rlm_dp_sv.g_dsp_start_time) +
3895: v_ForecastFenceDayFrom - 1)) THEN --{

Line 3894: (TRUNC(rlm_dp_sv.g_dsp_start_time) +

3890: IF (g_ManageDemand_tab(i).request_date <
3891: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_ForecastFenceDayTo))
3892: AND
3893: (g_ManageDemand_tab(i).request_date >=
3894: (TRUNC(rlm_dp_sv.g_dsp_start_time) +
3895: v_ForecastFenceDayFrom - 1)) THEN --{
3896: --
3897: --Bugfix 10053830 End
3898: IF (l_debug <> -1) THEN

Line 3907: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_ForecastFenceDayTo))THEN --}{ --Bugfix 10053830

3903: SetOperation(g_ManageDemand_tab(i), k_UPDATE);
3904: --
3905: ELSIF(g_ManageDemand_tab(i).request_date >=
3906: --(TRUNC(SYSDATE) + v_ForecastFenceDayTo))THEN --}{ --Bugfix 10053830
3907: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_ForecastFenceDayTo))THEN --}{ --Bugfix 10053830
3908: --
3909: IF (l_debug <> -1) THEN
3910: rlm_core_sv.dlog(C_DEBUG,'request_date outside oe forecast fence');
3911: END IF;

Line 3925: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --{ --Bugfix 10053830

3921: ELSIF v_MRPFenceDays is NOT NULL THEN --}{
3922: --
3923: IF (g_ManageDemand_tab(i).request_date <
3924: --(TRUNC(SYSDATE) + v_MRPFenceDayTo)) THEN --{ --Bugfix 10053830
3925: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --{ --Bugfix 10053830
3926: --
3927: IF (l_debug <> -1) THEN
3928: rlm_core_sv.dlog(C_DEBUG,
3929: 'request_date inside MRP forecast fence');

Line 3937: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830

3933: SetOperation(g_ManageDemand_tab(i), k_UPDATE);
3934: --
3935: ELSIF (g_ManageDemand_tab(i).request_date >=
3936: --(TRUNC(SYSDATE) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830
3937: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830
3938: --
3939: IF (l_debug <> -1) THEN
3940: rlm_core_sv.dlog(C_DEBUG,
3941: 'request_date outside MRP forecast fence');

Line 3991: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayFrom - 1) AND

3987: IF (g_ManageDemand_tab(i).request_date BETWEEN
3988: --Bugfix 10053830 Start
3989: /*(TRUNC(SYSDATE) + v_MRPFenceDayFrom - 1) AND
3990: (TRUNC(SYSDATE) + v_MRPFenceDayTo - 1)) THEN --{*/
3991: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayFrom - 1) AND
3992: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo - 1)) THEN --{
3993: --Bugfix 10053830 End
3994: --
3995: IF (l_debug <> -1) THEN

Line 3992: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo - 1)) THEN --{

3988: --Bugfix 10053830 Start
3989: /*(TRUNC(SYSDATE) + v_MRPFenceDayFrom - 1) AND
3990: (TRUNC(SYSDATE) + v_MRPFenceDayTo - 1)) THEN --{*/
3991: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayFrom - 1) AND
3992: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo - 1)) THEN --{
3993: --Bugfix 10053830 End
3994: --
3995: IF (l_debug <> -1) THEN
3996: rlm_core_sv.dlog(C_DEBUG,

Line 4005: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830

4001: SetOperation(g_ManageDemand_tab(i), k_UPDATE);
4002: --
4003: ELSIF (g_ManageDemand_tab(i).request_date >=
4004: --(TRUNC(SYSDATE) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830
4005: (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_MRPFenceDayTo)) THEN --}{ --Bugfix 10053830
4006: --
4007: IF (l_debug <> -1) THEN
4008: rlm_core_sv.dlog(C_DEBUG,
4009: 'request_date outside MRP forecast fence');

Line 4032: AND g_ManageDemand_tab(i).request_date < (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FrozenFenceDays) --Bugfix 10053830

4028: END IF; /* Firm Fence is NULL */ --}
4029: --
4030: IF v_FrozenFenceDays IS NOT NULL
4031: --AND g_ManageDemand_tab(i).request_date < (TRUNC(SYSDATE) + v_FrozenFenceDays) --Bugfix 10053830
4032: AND g_ManageDemand_tab(i).request_date < (TRUNC(rlm_dp_sv.g_dsp_start_time) + v_FrozenFenceDays) --Bugfix 10053830
4033: AND g_ManageDemand_tab(i).item_detail_type <> k_FORECAST_DEMAND
4034: AND g_ManageDemand_tab(i).item_detail_type <> k_MRP_FORECAST
4035: AND nvl(v_FirmFenceDays,-99) <> 0 --bug 3562125
4036: THEN --{

Line 4959: PROCEDURE MatchDemand(x_Group_rec IN rlm_dp_sv.t_Group_rec,

4955: PROCEDURE NAME: MatchDemand
4956:
4957: ===========================================================================*/
4958:
4959: PROCEDURE MatchDemand(x_Group_rec IN rlm_dp_sv.t_Group_rec,
4960: x_Index IN NUMBER,
4961: x_AggregateDemand_tab IN OUT NOCOPY t_MD_tab,
4962: x_Delete_tab IN OUT NOCOPY t_Number_tab,
4963: x_ExcpTab IN OUT NOCOPY t_Match_Tab)

Line 5496: PROCEDURE AggregateDemand(x_Group_rec IN rlm_dp_sv.t_Group_rec)

5492: PROCEDURE NAME: AggregateDemand
5493:
5494: ===========================================================================*/
5495:
5496: PROCEDURE AggregateDemand(x_Group_rec IN rlm_dp_sv.t_Group_rec)
5497: IS
5498:
5499: i NUMBER;
5500: v_Delete_tab t_Number_tab;

Line 5827: x_Group_rec IN rlm_dp_sv.t_Group_rec)

5823:
5824: ===========================================================================*/
5825:
5826: PROCEDURE RoundStandardPack(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
5827: x_Group_rec IN rlm_dp_sv.t_Group_rec)
5828: IS
5829:
5830: v_RoundPack VARCHAR(1);
5831: v_StdPackQty NUMBER;

Line 6090: x_Group_rec IN rlm_dp_sv.t_Group_rec)

6086:
6087: ===========================================================================*/
6088: PROCEDURE InitializeMdGroup(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6089: x_Group_ref IN OUT NOCOPY rlm_manage_demand_sv.t_Cursor_ref,
6090: x_Group_rec IN rlm_dp_sv.t_Group_rec)
6091: IS
6092:
6093: BEGIN
6094:

Line 6163: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

6159: FUNCTION FetchGroup
6160:
6161: ===========================================================================*/
6162: FUNCTION FetchGroup(x_Group_ref IN OUT NOCOPY t_Cursor_ref,
6163: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
6164: RETURN BOOLEAN
6165: IS
6166: BEGIN
6167:

Line 6218: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

6214: PROCEDURE CallSetups
6215:
6216: ===========================================================================*/
6217: PROCEDURE CallSetups(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6218: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
6219: IS
6220:
6221: v_SetupTerms_rec rlm_setup_terms_sv.setup_terms_rec_typ;
6222: v_TermsLevel VARCHAR2(30) := NULL;

Line 6450: x_GroupRec IN rlm_dp_sv.t_Group_rec)

6446:
6447: ===========================================================================*/
6448:
6449: FUNCTION LockLines (x_headerId IN NUMBER,
6450: x_GroupRec IN rlm_dp_sv.t_Group_rec)
6451: RETURN BOOLEAN
6452: IS
6453: --
6454: x_progress VARCHAR2(3) := '010';

Line 6596: x_GroupRec IN rlm_dp_sv.t_Group_rec,

6592: ===========================================================================*/
6593:
6594: PROCEDURE UpdateGroupStatus (x_HeaderId IN NUMBER,
6595: x_ScheduleHeaderId IN NUMBER,
6596: x_GroupRec IN rlm_dp_sv.t_Group_rec,
6597: x_ProcessStatus IN NUMBER,
6598: x_UpdateLevel IN VARCHAR2)
6599: IS
6600: --

Line 6771: x_group_rec IN rlm_dp_sv.t_Group_rec,

6767: FUNCTION NAME: GetTPContext
6768:
6769: ===========================================================================*/
6770: PROCEDURE GetTPContext( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6771: x_group_rec IN rlm_dp_sv.t_Group_rec,
6772: x_customer_number OUT NOCOPY VARCHAR2,
6773: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
6774: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
6775: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 6881: x_Group_rec IN rlm_dp_sv.t_Group_rec)

6877: /*any changes to this package may be incorporated in the function rlm_managedemand_sv.GetAllIntransitQty and rlm_rd_sv.SynchronizeShipments and vice versa */
6878:
6879:
6880: FUNCTION CalculateIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6881: x_Group_rec IN rlm_dp_sv.t_Group_rec)
6882: RETURN NUMBER
6883: IS
6884: --
6885: v_InTransitQty NUMBER := 0;

Line 6904: v_Group_rec rlm_dp_sv.t_Group_rec; --Bugfix 6265953

6900: v_match_within_rule RLM_CORE_SV.t_Match_rec;
6901: v_match_across_rule RLM_CORE_SV.t_Match_rec;
6902: v_min_horizon_date VARCHAR2(30); --Bugfix 6265953
6903: v_match_rec_shipline RLM_RD_SV.t_generic_rec;--Bugfix 6265953
6904: v_Group_rec rlm_dp_sv.t_Group_rec; --Bugfix 6265953
6905: --
6906:
6907: BEGIN
6908:

Line 7095: x_Group_rec IN rlm_dp_sv.t_Group_rec,

7091: END CalculateIntransitQty;
7092:
7093:
7094: FUNCTION GetAllIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7095: x_Group_rec IN rlm_dp_sv.t_Group_rec,
7096: x_Source_Tab IN RLM_MANAGE_DEMAND_SV.t_Source_Tab)
7097: RETURN NUMBER
7098: IS
7099:

Line 8071: x_Group_rec IN rlm_dp_sv.t_Group_rec,

8067: -- Bug 2788014: Calculate intransit quantities across orgs and orders
8068: -- if CUM org level is xxx/All Ship Froms
8069: --
8070: FUNCTION GetIntransitAcrossOrgs(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
8071: x_Group_rec IN rlm_dp_sv.t_Group_rec,
8072: x_cum_key_id IN NUMBER)
8073: RETURN NUMBER IS
8074: -- The shipper ID is stored in the item_detail_ref_value_1 field
8075: -- when the item detail type = 4 and the sub type = 'RECEIPT', 'SHIPMENT'

Line 8167: v_Group_rec rlm_dp_sv.t_Group_rec; --Bugfix 6265953

8163: v_intransit_calc_basis VARCHAR2(15);
8164: v_deliveryID VARCHAR2(35);
8165: v_min_horizon_date VARCHAR2(30); --Bugfix 6265953
8166: v_match_rec_shipline RLM_RD_SV.t_generic_rec;--Bugfix 6265953
8167: v_Group_rec rlm_dp_sv.t_Group_rec; --Bugfix 6265953
8168: --
8169: CURSOR c_Orders IS
8170: SELECT header_id
8171: FROM oe_order_lines