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_RD_SV dependencies on RLM_DP_SV

Line 18: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

14:
15: ==============================================================================*/
16: PROCEDURE RecDemand(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_ReGroup_ref t_Cursor_ref;

Line 23: v_ReGroup_rec rlm_dp_sv.t_Group_rec;

19: x_ReturnStatus OUT NOCOPY NUMBER)
20: IS
21: --
22: v_ReGroup_ref t_Cursor_ref;
23: v_ReGroup_rec rlm_dp_sv.t_Group_rec;
24: x_progress VARCHAR2(3) := '010';
25: e_lines_locked EXCEPTION;
26: v_sf_org_id NUMBER;
27: v_rso_start_date DATE;

Line 170: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

166:
167: ============================================================================*/
168:
169: PROCEDURE RecGroupDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
170: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
171: IS
172: --
173: x_progress VARCHAR2(3) := '010';
174: --

Line 264: TRUNC(rlm_dp_sv.g_dsp_start_time) - nvl(x_Group_rec.Cutoff_days,0)), --Bugfix 10053830

260: DECODE(authorized_to_ship_flag,k_ATS,
261: DECODE(x_group_rec.disposition_code,
262: k_REMAIN_ON_FILE,x_Sched_rec.sched_horizon_start_date,
263: k_REMAIN_ON_FILE_RECONCILE, to_date(industry_attribute2,'RRRR/MM/DD HH24:MI:SS'),
264: TRUNC(rlm_dp_sv.g_dsp_start_time) - nvl(x_Group_rec.Cutoff_days,0)), --Bugfix 10053830
265: TRUNC(rlm_dp_sv.g_dsp_start_time)) --Bugfix 10053830
266: AND TRUNC(x_Sched_rec.sched_horizon_end_date)+0.99999
267: AND DECODE(rla_schedule_type_code,
268: x_Group_rec.schedule_type_one, 1,

Line 265: TRUNC(rlm_dp_sv.g_dsp_start_time)) --Bugfix 10053830

261: DECODE(x_group_rec.disposition_code,
262: k_REMAIN_ON_FILE,x_Sched_rec.sched_horizon_start_date,
263: k_REMAIN_ON_FILE_RECONCILE, to_date(industry_attribute2,'RRRR/MM/DD HH24:MI:SS'),
264: TRUNC(rlm_dp_sv.g_dsp_start_time) - nvl(x_Group_rec.Cutoff_days,0)), --Bugfix 10053830
265: TRUNC(rlm_dp_sv.g_dsp_start_time)) --Bugfix 10053830
266: AND TRUNC(x_Sched_rec.sched_horizon_end_date)+0.99999
267: AND DECODE(rla_schedule_type_code,
268: x_Group_rec.schedule_type_one, 1,
269: x_Group_rec.schedule_type_two, 2,

Line 444: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

440: PROCEDURE CallSetups
441:
442: ===========================================================================*/
443: PROCEDURE CallSetups(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
444: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
445: IS
446: --
447: v_SetupTerms_rec rlm_setup_terms_sv.setup_terms_rec_typ;
448: v_TermsLevel VARCHAR2(30) := NULL;

Line 715: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

711: PROCEDURE ExecOperations
712:
713: ===========================================================================*/
714: PROCEDURE ExecOperations(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
715: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
716: IS
717:
718: --
719: x_progress VARCHAR2(3) := '010';

Line 811: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

807: PROCEDURE CancelPreHorizonNATS
808:
809: ===========================================================================*/
810: PROCEDURE CancelPreHorizonNATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
811: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
812: IS
813:
814: CURSOR c_PreHorizonNATS IS
815: SELECT line_id

Line 835: < TRUNC(rlm_dp_sv.g_dsp_start_time) --Bugfix 10053830

831: NVL(x_Group_rec.cust_production_seq_num, k_NNULL)*/
832: --
833: --AND request_date < x_Sched_rec.sched_horizon_start_date --chg
834: AND to_date(industry_attribute2,'RRRR/MM/DD HH24:MI:SS')
835: < TRUNC(rlm_dp_sv.g_dsp_start_time) --Bugfix 10053830
836: --pdue
837: -- < x_Sched_rec.sched_horizon_start_date
838: AND authorized_to_ship_flag = k_NATS
839: AND nvl(ordered_quantity,0 ) - nvl(shipped_quantity,0) > 0;

Line 1010: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

1006: FUNCTION FetchGroup
1007:
1008: ===========================================================================*/
1009: FUNCTION FetchGroup(x_Group_ref IN OUT NOCOPY t_Cursor_ref,
1010: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
1011: RETURN BOOLEAN
1012: IS
1013:
1014: x_progress VARCHAR2(3) := '010';

Line 1071: FUNCTION RemainOnFile(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

1067: FUNCTION NAME: RemainOnFile
1068:
1069: ===========================================================================*/
1070:
1071: FUNCTION RemainOnFile(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
1072: x_Key_rec IN RLM_RD_SV.t_Key_rec)
1073: RETURN BOOLEAN
1074: IS
1075: v_Progress VARCHAR2(3) := '010';

Line 1082: IF (TO_DATE(x_key_rec.dem_rec.industry_attribute2,'RRRR/MM/DD HH24:MI:SS') < TRUNC(rlm_dp_sv.g_dsp_start_time)) AND x_key_rec.dem_rec.authorized_to_ship_flag = 'Y' THEN --Bugfix 10053830

1078: IF (l_debug <> -1) THEN
1079: rlm_core_sv.dpush(k_SDEBUG,'RemainOnFile');
1080: END IF;
1081: --
1082: IF (TO_DATE(x_key_rec.dem_rec.industry_attribute2,'RRRR/MM/DD HH24:MI:SS') < TRUNC(rlm_dp_sv.g_dsp_start_time)) AND x_key_rec.dem_rec.authorized_to_ship_flag = 'Y' THEN --Bugfix 10053830
1083: --
1084: IF x_group_rec.disposition_code = k_REMAIN_ON_FILE THEN
1085: --
1086: IF (l_debug <> -1) THEN

Line 1094: IF TO_DATE(x_key_rec.dem_rec.industry_attribute2,'RRRR/MM/DD HH24:MI:SS') >= (TRUNC(rlm_dp_sv.g_dsp_start_time) - NVL(x_group_rec.cutoff_days,0)) THEN --Bugfix 10053830

1090: RETURN TRUE;
1091: --
1092: ELSIF x_group_rec.disposition_code = k_CANCEL_AFTER_N_DAYS THEN
1093: --
1094: IF TO_DATE(x_key_rec.dem_rec.industry_attribute2,'RRRR/MM/DD HH24:MI:SS') >= (TRUNC(rlm_dp_sv.g_dsp_start_time) - NVL(x_group_rec.cutoff_days,0)) THEN --Bugfix 10053830
1095: --
1096: IF (l_debug <> -1) THEN
1097: rlm_core_sv.dlog(k_DEBUG,'Between cutoff and sysdate');
1098: rlm_core_sv.dpop(k_SDEBUG, 'TRUE');

Line 1132: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

1128: PROCEDURE DeleteRequirement
1129:
1130: ===========================================================================*/
1131: PROCEDURE DeleteRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1132: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
1133: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
1134: x_Reconcile IN BOOLEAN,
1135: x_DeleteQty OUT NOCOPY NUMBER)
1136: IS

Line 1172: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),

1168: IF x_Sched_rec.schedule_source <> 'MANUAL' AND
1169: --Bugfix 10053830
1170: /* IsFrozen(TRUNC(SYSDATE),
1171: x_Group_rec, x_key_rec.dem_rec.request_date) THEN*/
1172: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),
1173: x_Group_rec, x_key_rec.dem_rec.request_date) THEN
1174: --Bugfix 10053830
1175: --
1176: IF (l_debug <> -1) THEN

Line 1546: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

1542: PROCEDURE InsertRequirement
1543:
1544: ===========================================================================*/
1545: PROCEDURE InsertRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1546: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
1547: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
1548: x_Reconcile IN BOOLEAN,
1549: x_Quantity IN OUT NOCOPY NUMBER)
1550: IS

Line 1690: IF IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.request_date) OR

1686: --
1687: --Bugfix 10053830 Start
1688: /*IF IsFrozen(TRUNC(SYSDATE),x_Group_rec,x_key_rec.req_rec.request_date) OR
1689: IsFrozen(TRUNC(SYSDATE),x_Group_rec,x_key_rec.req_rec.schedule_date) THEN*/
1690: IF IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.request_date) OR
1691: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.schedule_date) THEN
1692: --Bugfix 10053830 End
1693: --
1694: IF (l_debug <> -1) THEN

Line 1691: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.schedule_date) THEN

1687: --Bugfix 10053830 Start
1688: /*IF IsFrozen(TRUNC(SYSDATE),x_Group_rec,x_key_rec.req_rec.request_date) OR
1689: IsFrozen(TRUNC(SYSDATE),x_Group_rec,x_key_rec.req_rec.schedule_date) THEN*/
1690: IF IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.request_date) OR
1691: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.schedule_date) THEN
1692: --Bugfix 10053830 End
1693: --
1694: IF (l_debug <> -1) THEN
1695: rlm_core_sv.dlog(k_DEBUG,'The line is within frozen fence',

Line 1732: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.request_date) AND

1728: IF v_RF_Enabled = 'Y' AND
1729: --Bugfix 10053830 Start
1730: /*IsFrozen(TRUNC(SYSDATE),x_Group_rec,x_key_rec.req_rec.request_date) AND
1731: x_Sched_rec.schedule_source <> 'MANUAL' THEN */
1732: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.request_date) AND
1733: x_Sched_rec.schedule_source <> 'MANUAL' THEN
1734: --Bugfix 10053830 End
1735: --
1736: IF (l_debug <> -1) THEN

Line 1762: x_value4 => TRUNC(rlm_dp_sv.g_dsp_start_time)+nvl(x_Group_rec.frozen_days,0), --Bugfix 10053830

1758: x_value2 => x_key_rec.req_rec.request_date,
1759: x_Token3 => 'REC_LINE_QTY',
1760: x_value3 => x_Quantity,
1761: x_Token4 => 'NEW_REQ_DATE',
1762: x_value4 => TRUNC(rlm_dp_sv.g_dsp_start_time)+nvl(x_Group_rec.frozen_days,0), --Bugfix 10053830
1763: x_Token5 => 'SEQ_INFO',
1764: x_value5 => nvl(x_Key_rec.req_rec.cust_production_seq_num,'NULL')||'-'||
1765: nvl(x_Key_rec.req_rec.cust_model_serial_number,'NULL')||'-'||
1766: nvl(x_Key_rec.req_rec.customer_job,'NULL'),

Line 1796: x_value4 => TRUNC(rlm_dp_sv.g_dsp_start_time)+nvl(x_Group_rec.frozen_days,0), --Bugfix 10053830

1792: x_value2 => x_key_rec.req_rec.request_date,
1793: x_Token3 => 'REC_LINE_QTY',
1794: x_value3 => x_Quantity,
1795: x_Token4 => 'NEW_REQ_DATE',
1796: x_value4 => TRUNC(rlm_dp_sv.g_dsp_start_time)+nvl(x_Group_rec.frozen_days,0), --Bugfix 10053830
1797: x_Token5 => 'SCHEDULE_LINE',
1798: x_value5 => rlm_core_sv.get_schedule_line_number(x_key_rec.req_rec.schedule_line_id),
1799: x_Token6 => 'MATCH_ATTR',
1800: x_value6 => v_MatchAttrTxt);

Line 1812: x_key_rec.req_rec.request_date := TRUNC(rlm_dp_sv.g_dsp_start_time) --Bugfix 10053830

1808: END IF;
1809: -- Bugfix 8279132 End
1810: --
1811: --x_key_rec.req_rec.request_date := TRUNC(SYSDATE) --Bugfix 10053830
1812: x_key_rec.req_rec.request_date := TRUNC(rlm_dp_sv.g_dsp_start_time) --Bugfix 10053830
1813: + nvl(x_Group_rec.frozen_days,0);
1814: --
1815: IF (l_debug <> -1) THEN
1816: rlm_core_sv.dlog(k_DEBUG,'request_date',x_key_rec.req_rec.request_date);

Line 1825: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.schedule_date) AND

1821: IF v_RF_Enabled = 'Y' AND
1822: --Bugfix 10053830 Start
1823: /*IsFrozen(TRUNC(SYSDATE),x_Group_rec,x_key_rec.req_rec.schedule_date) AND
1824: x_Sched_rec.schedule_source <> 'MANUAL' THEN */
1825: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.schedule_date) AND
1826: x_Sched_rec.schedule_source <> 'MANUAL' THEN
1827: --Bugfix 10053830 End
1828: --
1829: IF (l_debug <> -1) THEN

Line 1834: x_key_rec.req_rec.schedule_date := TRUNC(rlm_dp_sv.g_dsp_start_time) --Bugfix 10053830

1830: rlm_core_sv.dlog(k_DEBUG,'x_Group_rec.frozen_days',x_Group_rec.frozen_days);
1831: END IF;
1832: --pdue
1833: --x_key_rec.req_rec.schedule_date := TRUNC(SYSDATE) --Bugfix 10053830
1834: x_key_rec.req_rec.schedule_date := TRUNC(rlm_dp_sv.g_dsp_start_time) --Bugfix 10053830
1835: + nvl(x_Group_rec.frozen_days,0);
1836: --
1837: IF (l_debug <> -1) THEN
1838: rlm_core_sv.dlog(k_DEBUG,'schedule_date',x_key_rec.req_rec.schedule_date);

Line 2064: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

2060: PROCEDURE UpdateRequirement
2061:
2062: ===========================================================================*/
2063: PROCEDURE UpdateRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
2064: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
2065: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
2066: x_Quantity IN NUMBER)
2067: IS
2068:

Line 2095: (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_Key_rec.req_rec.schedule_date) OR

2091: IF x_Sched_rec.schedule_source <> 'MANUAL' AND
2092: --Bugfix 10053830 Start
2093: /*(IsFrozen(TRUNC(SYSDATE),x_Group_rec,x_Key_rec.req_rec.schedule_date) OR
2094: IsFrozen(TRUNC(SYSDATE),x_Group_rec,x_key_rec.req_rec.request_date)) THEN*/
2095: (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_Key_rec.req_rec.schedule_date) OR
2096: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.request_date)) THEN
2097: --Bugfix 10053830 End
2098: --{
2099: IF nvl(v_RF_Enabled, 'N') = 'N' THEN

Line 2096: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.request_date)) THEN

2092: --Bugfix 10053830 Start
2093: /*(IsFrozen(TRUNC(SYSDATE),x_Group_rec,x_Key_rec.req_rec.schedule_date) OR
2094: IsFrozen(TRUNC(SYSDATE),x_Group_rec,x_key_rec.req_rec.request_date)) THEN*/
2095: (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_Key_rec.req_rec.schedule_date) OR
2096: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time),x_Group_rec,x_key_rec.req_rec.request_date)) THEN
2097: --Bugfix 10053830 End
2098: --{
2099: IF nvl(v_RF_Enabled, 'N') = 'N' THEN
2100: --{

Line 2212: x_value4 => TRUNC(rlm_dp_sv.g_dsp_start_time)+nvl(x_Group_rec.frozen_days,0), --Bugfix 10053830

2208: x_value2 => x_key_rec.req_rec.request_date,
2209: x_Token3 => 'REC_LINE_QTY',
2210: x_value3 => x_Quantity,
2211: x_Token4 => 'NEW_REQ_DATE',
2212: x_value4 => TRUNC(rlm_dp_sv.g_dsp_start_time)+nvl(x_Group_rec.frozen_days,0), --Bugfix 10053830
2213: x_Token5 => 'SEQ_INFO',
2214: x_value5 => nvl(x_Key_rec.req_rec.cust_production_seq_num,'NULL')||'-'||
2215: nvl(x_Key_rec.req_rec.cust_model_serial_number,'NULL')||'-'||
2216: nvl(x_Key_rec.req_rec.customer_job,'NULL'),

Line 2246: x_value4 => TRUNC(rlm_dp_sv.g_dsp_start_time)+nvl(x_Group_rec.frozen_days,0), --Bugfix 10053830

2242: x_value2 => x_key_rec.req_rec.request_date,
2243: x_Token3 => 'REC_LINE_QTY',
2244: x_value3 => x_Quantity,
2245: x_Token4 => 'NEW_REQ_DATE',
2246: x_value4 => TRUNC(rlm_dp_sv.g_dsp_start_time)+nvl(x_Group_rec.frozen_days,0), --Bugfix 10053830
2247: x_Token5 => 'SCHEDULE_LINE',
2248: x_value5 => rlm_core_sv.get_schedule_line_number(x_key_rec.req_rec.schedule_line_id),
2249: x_Token6 => 'MATCH_ATTR',
2250: x_value6 => v_MatchAttrTxt);

Line 2261: x_key_rec.req_rec.request_date := TRUNC(rlm_dp_sv.g_dsp_start_time) + --Bugfix 10053830

2257: END IF;
2258: END IF;
2259: -- Bugfix 8279132 End
2260: --x_key_rec.req_rec.request_date := TRUNC(SYSDATE) + --Bugfix 10053830
2261: x_key_rec.req_rec.request_date := TRUNC(rlm_dp_sv.g_dsp_start_time) + --Bugfix 10053830
2262: nvl(x_Group_rec.frozen_days,0);
2263: --x_key_rec.req_rec.schedule_Date := TRUNC(SYSDATE) + -Bugfix 10053830
2264: x_key_rec.req_rec.schedule_Date := TRUNC(rlm_dp_sv.g_dsp_start_time) + --Bugfix 10053830
2265: nvl(x_Group_rec.frozen_days,0);

Line 2264: x_key_rec.req_rec.schedule_Date := TRUNC(rlm_dp_sv.g_dsp_start_time) + --Bugfix 10053830

2260: --x_key_rec.req_rec.request_date := TRUNC(SYSDATE) + --Bugfix 10053830
2261: x_key_rec.req_rec.request_date := TRUNC(rlm_dp_sv.g_dsp_start_time) + --Bugfix 10053830
2262: nvl(x_Group_rec.frozen_days,0);
2263: --x_key_rec.req_rec.schedule_Date := TRUNC(SYSDATE) + -Bugfix 10053830
2264: x_key_rec.req_rec.schedule_Date := TRUNC(rlm_dp_sv.g_dsp_start_time) + --Bugfix 10053830
2265: nvl(x_Group_rec.frozen_days,0);
2266: --
2267: IF (x_key_rec.dem_rec.ordered_quantity < x_Quantity ) THEN
2268: --

Line 2394: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

2390: PROCEDURE GetDemand
2391:
2392: ===========================================================================*/
2393: PROCEDURE GetDemand(x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
2394: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
2395: IS
2396: x_progress VARCHAR2(3) := '010';
2397: v_sql VARCHAR2(32000);
2398: c_Demand t_Cursor_ref;

Line 2604: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

2600: PROCEDURE InitializeDemand
2601:
2602: ===========================================================================*/
2603: PROCEDURE InitializeDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
2604: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
2605: x_Key_rec IN RLM_RD_SV.t_Key_rec,
2606: x_Demand_ref IN OUT NOCOPY t_Cursor_ref,
2607: x_DemandType IN VARCHAR2)
2608: IS

Line 2688: g_InitDemandTab(g_InitDemandTab.COUNT+1) := TO_CHAR(TRUNC(rlm_dp_sv.g_dsp_start_time), 'RRRR/MM/DD HH24:MI:SS'); --Bugfix 10053830

2684: --
2685: IF x_Group_rec.disposition_code = k_CANCEL_ALL THEN
2686: --
2687: v_where_clause := v_where_clause || ' AND TO_DATE(industry_attribute2,''RRRR/MM/DD HH24:MI:SS'') BETWEEN TO_DATE(:sched_start_date,''RRRR/MM/DD HH24:MI:SS'') AND TO_DATE(:sched_end_date,''RRRR/MM/DD HH24:MI:SS'') ';
2688: g_InitDemandTab(g_InitDemandTab.COUNT+1) := TO_CHAR(TRUNC(rlm_dp_sv.g_dsp_start_time), 'RRRR/MM/DD HH24:MI:SS'); --Bugfix 10053830
2689: g_InitDemandTab(g_InitDemandTab.COUNT+1) := TO_CHAR(TRUNC(x_Sched_rec.sched_horizon_end_date)+0.99999, 'RRRR/MM/DD HH24:MI:SS');
2690: --
2691: ELSIF x_Group_rec.disposition_code = k_CANCEL_AFTER_N_DAYS THEN
2692: --

Line 2694: g_InitDemandTab(g_InitDemandTab.COUNT+1) := TO_CHAR(TRUNC(rlm_dp_sv.g_dsp_start_time) - NVL(x_group_rec.cutoff_days,0), 'RRRR/MM/DD HH24:MI:SS'); --Bugfix 10053830

2690: --
2691: ELSIF x_Group_rec.disposition_code = k_CANCEL_AFTER_N_DAYS THEN
2692: --
2693: v_where_clause := v_where_clause || ' AND TO_DATE(industry_attribute2,''RRRR/MM/DD HH24:MI:SS'') BETWEEN TO_DATE(:sched_start_date,''RRRR/MM/DD HH24:MI:SS'') AND TO_DATE(:sched_end_date,''RRRR/MM/DD HH24:MI:SS'') ';
2694: g_InitDemandTab(g_InitDemandTab.COUNT+1) := TO_CHAR(TRUNC(rlm_dp_sv.g_dsp_start_time) - NVL(x_group_rec.cutoff_days,0), 'RRRR/MM/DD HH24:MI:SS'); --Bugfix 10053830
2695: g_InitDemandTab(g_InitDemandTab.COUNT+1) := TO_CHAR(TRUNC(x_Sched_rec.sched_horizon_end_date)+0.99999, 'RRRR/MM/DD HH24:MI:SS');
2696: --
2697: ELSIF x_Group_rec.disposition_code = k_REMAIN_ON_FILE_RECONCILE THEN
2698: --

Line 3532: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

3528:
3529: ===========================================================================*/
3530: PROCEDURE InitializeSoGroup(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3531: x_Group_ref IN OUT NOCOPY rlm_rd_sv.t_Cursor_ref,
3532: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
3533: IS
3534: x_progress VARCHAR2(3) := '010';
3535:
3536: BEGIN

Line 3605: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

3601: PROCEDURE InitializeReq
3602:
3603: ===========================================================================*/
3604: PROCEDURE InitializeReq(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3605: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
3606: x_Req_ref IN OUT NOCOPY t_Cursor_ref,
3607: x_ReqType IN VARCHAR2)
3608: IS
3609: x_progress VARCHAR2(3) := '010';

Line 3855: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

3851: PROCEDURE CancelRequirement
3852:
3853: ===========================================================================*/
3854: PROCEDURE CancelRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3855: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
3856: x_Key_rec IN RLM_RD_SV.t_Key_rec,
3857: x_CancelQty IN NUMBER)
3858: IS
3859: x_progress VARCHAR2(3) := '010';

Line 3893: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

3889: PROCEDURE SynchronizeShipments
3890:
3891: ===========================================================================*/
3892: PROCEDURE SynchronizeShipments(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3893: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
3894: IS
3895: --
3896: v_InTransitQty NUMBER;
3897: --

Line 4333: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

4329: PROCEDURE StoreShipments
4330:
4331: ===========================================================================*/
4332: PROCEDURE StoreShipments(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
4333: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
4334: x_Key_rec IN RLM_RD_SV.t_Key_rec,
4335: x_Quantity IN NUMBER)
4336: IS
4337:

Line 4440: PROCEDURE ReconcileShipments(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

4436:
4437: PROCEDURE ReconcileShipments
4438:
4439: ===========================================================================*/
4440: PROCEDURE ReconcileShipments(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
4441: x_Key_rec IN RLM_RD_SV.t_Key_rec,
4442: x_Quantity IN OUT NOCOPY NUMBER)
4443: IS
4444:

Line 4519: FUNCTION MatchShipments(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

4515:
4516: FUNCTION MatchShipments
4517:
4518: ===========================================================================*/
4519: FUNCTION MatchShipments(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
4520: x_Current_rec IN RLM_RD_SV.t_Generic_rec,
4521: x_Index OUT NOCOPY NUMBER)
4522: RETURN BOOLEAN
4523: IS

Line 4612: FUNCTION MatchFrozen(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

4608: this is required to find duplicate records in the g_reconcile_tab to
4609: print the aggregate frozenQty message
4610:
4611: ===========================================================================*/
4612: FUNCTION MatchFrozen(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
4613: x_Index2 IN NUMBER,
4614: x_Current_rec IN t_Generic_rec,
4615: x_Index OUT NOCOPY NUMBER)
4616: RETURN BOOLEAN

Line 5691: FUNCTION MatchReconcile(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

5687:
5688: FUNCTION MatchReconcile
5689:
5690: ===========================================================================*/
5691: FUNCTION MatchReconcile(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
5692: x_Current_rec IN t_Generic_rec,
5693: x_Index OUT NOCOPY NUMBER)
5694: RETURN BOOLEAN
5695: IS

Line 6829: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

6825: PROCEDURE StoreReconcile
6826:
6827: ===========================================================================*/
6828: PROCEDURE StoreReconcile(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6829: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
6830: x_Key_rec IN RLM_RD_SV.t_Key_rec,
6831: x_Quantity IN NUMBER)
6832: IS
6833: --

Line 6899: PROCEDURE Reconcile(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

6895:
6896: PROCEDURE Reconcile
6897:
6898: ===========================================================================*/
6899: PROCEDURE Reconcile(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
6900: x_Key_rec IN RLM_RD_SV.t_Key_rec,
6901: x_Quantity IN OUT NOCOPY NUMBER)
6902: IS
6903:

Line 7229: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

7225: PROCEDURE ProcessPreHorizonATS
7226:
7227: ===========================================================================*/
7228: PROCEDURE ProcessPreHorizonATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7229: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
7230: IS
7231:
7232: CURSOR c_PreHorizonDisp (x_OffsetDays NUMBER) IS
7233: SELECT line_id, rla_schedule_type_code

Line 7249: < (TRUNC(rlm_dp_sv.g_dsp_start_time) - x_OffsetDays) --Bugfix 10053830

7245: DECODE(g_ATP, k_ATP, NVL(industry_attribute15, k_VNULL),
7246: NVL(x_Group_rec.industry_attribute15, k_VNULL))
7247: --bug 2181228
7248: AND to_date(industry_attribute2,'RRRR/MM/DD HH24:MI:SS')
7249: < (TRUNC(rlm_dp_sv.g_dsp_start_time) - x_OffsetDays) --Bugfix 10053830
7250: AND (NVL(ordered_quantity,0) -
7251: NVL(shipped_quantity,0) > 0)
7252: AND authorized_to_ship_flag = k_ATS
7253: ORDER BY request_date DESC;

Line 7362: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

7358: -- NOTE JH: open issue with bucket requirements overlapping end horizon date
7359:
7360: ===========================================================================*/
7361: PROCEDURE ProcessOld(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7362: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
7363: IS
7364: --
7365: -- Bug 3733520 : Modified cursor to select attributes that are
7366: -- selected in procedure GetDemand(). All calls to GetDemand()

Line 7465: TRUNC(rlm_dp_sv.g_dsp_start_time) - nvl(x_Group_rec.Cutoff_days,0)), TRUNC(rlm_dp_sv.g_dsp_start_time)) --Bugfix 10053830

7461: DECODE(authorized_to_ship_flag,k_ATS,
7462: DECODE(x_group_rec.disposition_code,
7463: k_REMAIN_ON_FILE, x_Sched_rec.sched_horizon_start_date,
7464: k_REMAIN_ON_FILE_RECONCILE, to_date(industry_attribute2,'RRRR/MM/DD HH24:MI:SS'),
7465: TRUNC(rlm_dp_sv.g_dsp_start_time) - nvl(x_Group_rec.Cutoff_days,0)), TRUNC(rlm_dp_sv.g_dsp_start_time)) --Bugfix 10053830
7466: AND TRUNC(x_Sched_rec.sched_horizon_end_date)+0.99999
7467: --bug 2022158 (issue with sched_horizon_end_date timestamp)
7468: AND DECODE(x_Sched_rec.schedule_purpose,
7469: k_ADD, DECODE(rla_schedule_type_code,

Line 7535: IF (TRUNC(rlm_dp_sv.g_dsp_start_time) > x_Sched_rec.sched_horizon_start_date) --Bugfix 10053830

7531: v_consume_line_tab.DELETE;
7532: --
7533: --
7534: -- FP Bug 3933822 jckwok
7535: IF (TRUNC(rlm_dp_sv.g_dsp_start_time) > x_Sched_rec.sched_horizon_start_date) --Bugfix 10053830
7536: THEN
7537: IF (x_group_rec.disposition_code = k_REMAIN_ON_FILE)
7538: THEN
7539: v_ATS_start_date := x_Sched_rec.sched_horizon_start_date;

Line 7542: v_ATS_start_date := TRUNC(rlm_dp_sv.g_dsp_start_time) - nvl(x_Group_rec.Cutoff_days,0); --Bugfix 10053830

7538: THEN
7539: v_ATS_start_date := x_Sched_rec.sched_horizon_start_date;
7540: ELSIF (x_group_rec.disposition_code = k_CANCEL_AFTER_N_DAYS)
7541: THEN
7542: v_ATS_start_date := TRUNC(rlm_dp_sv.g_dsp_start_time) - nvl(x_Group_rec.Cutoff_days,0); --Bugfix 10053830
7543: ELSE
7544: v_ATS_start_date := TRUNC(rlm_dp_sv.g_dsp_start_time); --Bugfix 10053830
7545: END IF;
7546:

Line 7544: v_ATS_start_date := TRUNC(rlm_dp_sv.g_dsp_start_time); --Bugfix 10053830

7540: ELSIF (x_group_rec.disposition_code = k_CANCEL_AFTER_N_DAYS)
7541: THEN
7542: v_ATS_start_date := TRUNC(rlm_dp_sv.g_dsp_start_time) - nvl(x_Group_rec.Cutoff_days,0); --Bugfix 10053830
7543: ELSE
7544: v_ATS_start_date := TRUNC(rlm_dp_sv.g_dsp_start_time); --Bugfix 10053830
7545: END IF;
7546:
7547: v_NATS_start_date := TRUNC(rlm_dp_sv.g_dsp_start_time); --Bugfix 10053830
7548: ELSE

Line 7547: v_NATS_start_date := TRUNC(rlm_dp_sv.g_dsp_start_time); --Bugfix 10053830

7543: ELSE
7544: v_ATS_start_date := TRUNC(rlm_dp_sv.g_dsp_start_time); --Bugfix 10053830
7545: END IF;
7546:
7547: v_NATS_start_date := TRUNC(rlm_dp_sv.g_dsp_start_time); --Bugfix 10053830
7548: ELSE
7549: v_ATS_start_date := x_Sched_rec.sched_horizon_start_date;
7550: v_NATS_start_date := x_Sched_rec.sched_horizon_start_date;
7551: END IF;

Line 7908: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, c_OldDemand_rec.request_date)

7904: --pdue
7905: IF x_Sched_rec.schedule_source <> 'MANUAL' AND
7906: --Bugfix 10053830 Start
7907: /*IsFrozen(TRUNC(SYSDATE), x_Group_rec, c_OldDemand_rec.request_date)*/
7908: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, c_OldDemand_rec.request_date)
7909: --Bugfix 10053830 End
7910: AND x_Sched_rec.schedule_purpose <> k_ADD THEN
7911: --
7912: IF (l_debug <> -1) THEN

Line 8503: IF (NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec,

8499: --Bugfix 10053830 Start
8500: /*IF (NOT (IsFrozen(TRUNC(SYSDATE), x_Group_rec,
8501: v_Key_rec.dem_rec.request_date) OR
8502: IsFrozen(TRUNC(SYSDATE), x_Group_rec, v_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL') --Bugfix 8221799*/
8503: IF (NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec,
8504: v_Key_rec.dem_rec.request_date) OR
8505: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, v_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL') --Bugfix 8221799
8506: --Bugfix 10053830 End
8507: AND NOT ProcessConstraint(v_Key_rec,v_Qty_rec,k_UPDATE,v_Quantity) THEN

Line 8505: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, v_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL') --Bugfix 8221799

8501: v_Key_rec.dem_rec.request_date) OR
8502: IsFrozen(TRUNC(SYSDATE), x_Group_rec, v_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL') --Bugfix 8221799*/
8503: IF (NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec,
8504: v_Key_rec.dem_rec.request_date) OR
8505: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, v_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL') --Bugfix 8221799
8506: --Bugfix 10053830 End
8507: AND NOT ProcessConstraint(v_Key_rec,v_Qty_rec,k_UPDATE,v_Quantity) THEN
8508: --
8509: IF (l_debug <> -1) THEN

Line 8899: FUNCTION SchedulePrecedence(x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

8895:
8896: FUNCTION SchedulePrecedence
8897:
8898: ===========================================================================*/
8899: FUNCTION SchedulePrecedence(x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
8900: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
8901: x_ScheduleType IN VARCHAR2)
8902: RETURN BOOLEAN
8903: IS

Line 9053: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

9049: END CountMatchedDemand;
9050:
9051:
9052: PROCEDURE ReconcileAction(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
9053: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
9054: x_key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
9055: x_line_id_tab IN RLM_RD_SV.t_matching_line,
9056: x_DemandCount IN NUMBER,
9057: x_SumOrderedQty IN NUMBER,

Line 9174: x_Group_Rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

9170:
9171: =============================================================================================== */
9172:
9173: PROCEDURE BuildMatchQuery(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
9174: x_Group_Rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
9175: x_Demand_Type IN VARCHAR2,
9176: x_Sql OUT NOCOPY VARCHAR2,
9177: x_Sql1 OUT NOCOPY VARCHAR2,
9178: x_Sql2 OUT NOCOPY VARCHAR2,

Line 10044: g_WhereTab1(g_WhereTab1.COUNT+1):= TO_CHAR(TRUNC(rlm_dp_sv.g_dsp_start_time),'RRRR/MM/DD HH24:MI:SS'); --Bugfix 10053830

10040: IF x_Group_rec.disposition_code = k_CANCEL_ALL THEN
10041: --
10042: v_ATSWhere := ' TO_DATE(o.industry_attribute2,''RRRR/MM/DD HH24:MI:SS'') BETWEEN TO_DATE(:sched_horizon_start_date,''RRRR/MM/DD HH24:MI:SS'') AND TO_DATE(:sched_horizon_end_date,''RRRR/MM/DD HH24:MI:SS'') ';
10043: --
10044: g_WhereTab1(g_WhereTab1.COUNT+1):= TO_CHAR(TRUNC(rlm_dp_sv.g_dsp_start_time),'RRRR/MM/DD HH24:MI:SS'); --Bugfix 10053830
10045: g_WhereTab1(g_WhereTab1.COUNT+1):= TO_CHAR((TRUNC(x_Sched_rec.sched_horizon_end_date)+0.99999),'RRRR/MM/DD HH24:MI:SS');
10046: --
10047: ELSIF x_Group_rec.disposition_code = k_CANCEL_AFTER_N_DAYS THEN
10048: --

Line 10049: v_Date := rlm_dp_sv.g_dsp_start_time - nvl(x_Group_rec.cutoff_days, 0); --Bugfix 10053830

10045: g_WhereTab1(g_WhereTab1.COUNT+1):= TO_CHAR((TRUNC(x_Sched_rec.sched_horizon_end_date)+0.99999),'RRRR/MM/DD HH24:MI:SS');
10046: --
10047: ELSIF x_Group_rec.disposition_code = k_CANCEL_AFTER_N_DAYS THEN
10048: --
10049: v_Date := rlm_dp_sv.g_dsp_start_time - nvl(x_Group_rec.cutoff_days, 0); --Bugfix 10053830
10050: rlm_core_sv.dlog(k_DEBUG, 'x_Group_rec.cutoff_days', x_Group_rec.cutoff_days);
10051: rlm_core_sv.dlog(k_DEBUG, 'v_Date', v_Date);
10052: --
10053: v_ATSWhere := ' TO_DATE(o.industry_attribute2,''RRRR/MM/DD HH24:MI:SS'') BETWEEN TO_DATE(:sched_horizon_start_date,''RRRR/MM/DD HH24:MI:SS'') AND TO_DATE(:sched_horizon_end_date,''RRRR/MM/DD HH24:MI:SS'') ';

Line 10102: g_WhereTab1(g_WhereTab1.COUNT+1):= TO_CHAR(TRUNC(rlm_dp_sv.g_dsp_start_time),'RRRR/MM/DD HH24:MI:SS'); --Bugfix 10053830

10098: -- Begin ArvinMeritor Change
10099: --
10100: v_NATSWhere := ' TO_DATE(o.industry_attribute2,''RRRR/MM/DD HH24:MI:SS'') BETWEEN TO_DATE(:sched_horizon_start_date,''RRRR/MM/DD HH24:MI:SS'') AND TO_DATE(:sched_horizon_end_date,''RRRR/MM/DD HH24:MI:SS'') ';
10101: --
10102: g_WhereTab1(g_WhereTab1.COUNT+1):= TO_CHAR(TRUNC(rlm_dp_sv.g_dsp_start_time),'RRRR/MM/DD HH24:MI:SS'); --Bugfix 10053830
10103: g_WhereTab1(g_WhereTab1.COUNT+1):= TO_CHAR((TRUNC(x_Sched_rec.sched_horizon_end_date)+0.99999),'RRRR/MM/DD HH24:MI:SS');
10104: --
10105: v_where_clause1 := v_where_clause1 || ' AND ' || v_NATSWhere;
10106: --

Line 10198: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

10194:
10195: ===========================================================================*/
10196:
10197: PROCEDURE ProcessATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
10198: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
10199: IS
10200:
10201: v_Key_rec t_Key_rec;
10202: v_ScheduleType VARCHAR2(30);

Line 10672: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

10668:
10669: ===========================================================================*/
10670:
10671: PROCEDURE ProcessNATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
10672: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
10673: IS
10674:
10675: v_Key_rec t_Key_rec;
10676: v_ScheduleType VARCHAR2(30);

Line 10976: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

10972: PROCEDURE UpdateDemand
10973:
10974: ===========================================================================*/
10975: PROCEDURE UpdateDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
10976: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
10977: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
10978: x_SumOrderedQty IN NUMBER,
10979: x_DemandType IN VARCHAR2)
10980: IS

Line 11078: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

11074: PROCEDURE DeleteDemand
11075:
11076: ===========================================================================*/
11077: PROCEDURE DeleteDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
11078: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
11079: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
11080: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref)
11081: IS
11082:

Line 11139: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

11135: PROCEDURE IncreaseDemand
11136:
11137: ===========================================================================*/
11138: PROCEDURE IncreaseDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
11139: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
11140: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
11141: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
11142: x_SumOrderedQty IN NUMBER)
11143: IS

Line 11186: IF NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.dem_rec.request_date) OR

11182:
11183: --Bugfix 10053830 Start
11184: /*IF NOT (IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11185: IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799*/
11186: IF NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11187: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799
11188: --Bugfix 10053830 End
11189: --
11190: UpdateRequirement(x_Sched_rec, x_Group_rec,

Line 11187: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799

11183: --Bugfix 10053830 Start
11184: /*IF NOT (IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11185: IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799*/
11186: IF NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11187: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799
11188: --Bugfix 10053830 End
11189: --
11190: UpdateRequirement(x_Sched_rec, x_Group_rec,
11191: x_Key_rec, x_Key_rec.dem_rec.ordered_quantity + v_QtyDelta);

Line 11331: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

11327: PROCEDURE DecreaseDemand
11328:
11329: ===========================================================================*/
11330: PROCEDURE DecreaseDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
11331: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
11332: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
11333: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
11334: x_SumOrderedQty IN NUMBER)
11335: IS

Line 11376: (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec,

11372: /*(IsFrozen(TRUNC(SYSDATE), x_Group_rec,
11373: x_Key_rec.dem_rec.request_date) OR
11374: IsFrozen(TRUNC(SYSDATE), x_Group_rec,
11375: x_Key_rec.dem_rec.schedule_date)) OR x_Sched_rec.schedule_source = 'MANUAL') THEN --Bugfix 8221799*/
11376: (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec,
11377: x_Key_rec.dem_rec.request_date) OR
11378: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec,
11379: x_Key_rec.dem_rec.schedule_date)) OR x_Sched_rec.schedule_source = 'MANUAL') THEN --Bugfix 8221799
11380: --Bugfix 10053830 End

Line 11378: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec,

11374: IsFrozen(TRUNC(SYSDATE), x_Group_rec,
11375: x_Key_rec.dem_rec.schedule_date)) OR x_Sched_rec.schedule_source = 'MANUAL') THEN --Bugfix 8221799*/
11376: (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec,
11377: x_Key_rec.dem_rec.request_date) OR
11378: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec,
11379: x_Key_rec.dem_rec.schedule_date)) OR x_Sched_rec.schedule_source = 'MANUAL') THEN --Bugfix 8221799
11380: --Bugfix 10053830 End
11381: --
11382: DeleteRequirement(x_Sched_rec, x_Group_rec,

Line 11397: IF NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.dem_rec.request_date) OR

11393: IF NOT ProcessConstraint(x_Key_rec, v_Qty_rec, k_UPDATE, x_Key_rec.dem_rec.ordered_quantity - v_QtyDelta) THEN
11394: --Bugfix 10053830 Start
11395: /*IF NOT (IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11396: IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799*/
11397: IF NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11398: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799
11399: --Bugfix 10053830 End
11400: UpdateRequirement(x_Sched_rec, x_Group_rec, x_Key_rec, x_Key_rec.dem_rec.ordered_quantity - v_QtyDelta);
11401: --

Line 11398: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799

11394: --Bugfix 10053830 Start
11395: /*IF NOT (IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11396: IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799*/
11397: IF NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11398: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799
11399: --Bugfix 10053830 End
11400: UpdateRequirement(x_Sched_rec, x_Group_rec, x_Key_rec, x_Key_rec.dem_rec.ordered_quantity - v_QtyDelta);
11401: --
11402: v_QtyDelta := 0;

Line 11541: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

11537: PROCEDURE OtherDemand
11538:
11539: ===========================================================================*/
11540: PROCEDURE OtherDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
11541: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
11542: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
11543: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref)
11544: IS
11545:

Line 11587: IF NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.dem_rec.request_date) OR

11583: -- Bug 4297984 Start
11584: --Bugfix 10053830 Start
11585: /*IF NOT (IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11586: IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799*/
11587: IF NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11588: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799
11589: --Bugfix 10053830 End
11590: --
11591: IF NOT ProcessConstraint(x_Key_rec, v_Qty_rec, k_UPDATE_ATTR,

Line 11588: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799

11584: --Bugfix 10053830 Start
11585: /*IF NOT (IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11586: IsFrozen(TRUNC(SYSDATE), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799*/
11587: IF NOT (IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.dem_rec.request_date) OR
11588: IsFrozen(TRUNC(rlm_dp_sv.g_dsp_start_time), x_Group_rec, x_Key_rec.req_rec.request_date)) OR x_Sched_rec.schedule_source = 'MANUAL' THEN --Bugfix 8221799
11589: --Bugfix 10053830 End
11590: --
11591: IF NOT ProcessConstraint(x_Key_rec, v_Qty_rec, k_UPDATE_ATTR,
11592: x_Key_rec.dem_rec.ordered_quantity) THEN

Line 11992: x_Group_rec IN rlm_dp_sv.t_Group_rec,

11988:
11989: ===========================================================================*/
11990: PROCEDURE UpdateGroupStatus( x_header_id IN NUMBER,
11991: x_ScheduleHeaderId IN NUMBER,
11992: x_Group_rec IN rlm_dp_sv.t_Group_rec,
11993: x_status IN NUMBER,
11994: x_UpdateLevel IN VARCHAR2)
11995: IS
11996: x_progress VARCHAR2(3) := '010';

Line 12098: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

12094: FUNCTION IsFrozen
12095:
12096: ===========================================================================*/
12097: FUNCTION IsFrozen(x_horizon_start_date IN DATE,
12098: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
12099: x_ShipDate IN DATE)
12100: RETURN BOOLEAN
12101: IS
12102:

Line 12275: FUNCTION LockLines (x_Group_rec IN rlm_dp_sv.t_Group_rec,

12271:
12272: FUNCTION LockLines
12273:
12274: ===========================================================================*/
12275: FUNCTION LockLines (x_Group_rec IN rlm_dp_sv.t_Group_rec,
12276: x_header_id IN NUMBER)
12277: RETURN BOOLEAN
12278: IS
12279: x_progress VARCHAR2(3) := '010';

Line 12344: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

12340:
12341: ===========================================================================*/
12342:
12343: PROCEDURE CheckTolerance(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
12344: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
12345: x_Key_rec IN RLM_RD_SV.t_Key_rec,
12346: x_OldQty IN NUMBER,
12347: x_NewQty IN NUMBER)
12348: IS

Line 12593: x_group_rec IN rlm_dp_sv.t_Group_rec,

12589: FUNCTION NAME: GetTPContext
12590:
12591: ===========================================================================*/
12592: PROCEDURE GetTPContext( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
12593: x_group_rec IN rlm_dp_sv.t_Group_rec,
12594: x_req_rec IN rlm_rd_sv.t_generic_rec,
12595: x_customer_number OUT NOCOPY VARCHAR2,
12596: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
12597: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 12821: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

12817: END GetTPContext;
12818:
12819:
12820: PROCEDURE InitializeMatchRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
12821: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
12822: x_match_ref IN OUT NOCOPY t_Cursor_ref) IS
12823: --
12824: x_progress VARCHAR2(3) := '010';
12825: x_Query VARCHAR2(32767);

Line 13036: FUNCTION AlreadyMatched(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

13032: --
13033: END PrintMatchRec;
13034:
13035:
13036: FUNCTION AlreadyMatched(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
13037: x_match_rec IN WSH_RLM_INTERFACE.t_optional_match_rec, x_Index OUT NOCOPY NUMBER)
13038: RETURN BOOLEAN
13039: IS
13040: --

Line 13452: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

13448:
13449: ===========================================================================*/
13450:
13451: FUNCTION MRPOnly(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
13452: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
13453: RETURN BOOLEAN
13454:
13455: IS
13456: --

Line 13647: x_Group_rec IN rlm_dp_sv.t_Group_rec,

13643: -- Common to reconcile and manage demand
13644: -- Set up parameters to pass to shipping API
13645: --
13646: PROCEDURE InitializeIntransitParam(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
13647: x_Group_rec IN rlm_dp_sv.t_Group_rec,
13648: x_intransit_calc_basis IN VARCHAR2,
13649: x_Shipper_rec IN OUT NOCOPY WSH_RLM_INTERFACE.t_shipper_rec,
13650: x_Shipment_date IN OUT NOCOPY DATE)
13651: IS

Line 13939: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

13935:
13936: ===========================================================================*/
13937: PROCEDURE InitializeBlktGrp(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
13938: x_Group_ref IN OUT NOCOPY rlm_rd_sv.t_Cursor_ref,
13939: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
13940: IS
13941: --
13942: x_progress VARCHAR2(3) := '010';
13943: --

Line 14020: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

14016: FUNCTION FetchBlktGroup
14017:
14018: ===========================================================================*/
14019: FUNCTION FetchBlktGrp(x_Group_ref IN OUT NOCOPY t_Cursor_ref,
14020: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
14021: RETURN BOOLEAN
14022: IS
14023: --
14024: x_progress VARCHAR2(3) := '010';

Line 14240: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

14236: PROCEDURE NAME: SourceCUMIntransitQty
14237:
14238: ==============================================================================*/
14239: PROCEDURE SourceCUMIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
14240: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
14241: x_Cum_rec IN RLM_RD_SV.t_Ship_rec) --Bugfix 7007638
14242: IS
14243: --
14244: i NUMBER;

Line 14347: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

14343:
14344:
14345:
14346: PROCEDURE CalculateCUMIntransit(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
14347: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
14348: x_Line_id IN NUMBER, --Bugfix 7007638
14349: x_Intransit OUT NOCOPY NUMBER)
14350: IS
14351: --

Line 14634: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec) IS

14630: Added this new procedure to give the overall frozen period warning for bug4223359
14631: ==============================================================================*/
14632:
14633: PROCEDURE FrozenFenceWarning(x_sched_rec IN rlm_interface_headers%ROWTYPE,
14634: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec) IS
14635: --
14636: i NUMBER DEFAULT 0;
14637: v_index NUMBER DEFAULT 0;
14638: v_Count NUMBER DEFAULT 0;

Line 14758: x_Value1 => TRUNC(rlm_dp_sv.g_dsp_start_time) + v_frozenDays - 1, --Bugfix 10053830

14754: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14755: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,
14756: x_OrderLineId => NULL,
14757: x_Token1 => 'ENDDATE',
14758: x_Value1 => TRUNC(rlm_dp_sv.g_dsp_start_time) + v_frozenDays - 1, --Bugfix 10053830
14759: x_Token2 => 'SHIP_FROM',
14760: x_Value2 => rlm_core_sv.get_ship_from(x_group_rec.ship_from_org_id),
14761: x_Token3 => 'SHIP_TO',
14762: x_Value3 => rlm_core_sv.get_ship_to(x_group_rec.ship_to_address_id),

Line 14789: x_Value1 => TRUNC(rlm_dp_sv.g_dsp_start_time) + v_frozenDays - 1, --Bugfix 10053830

14785: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14786: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,
14787: x_OrderLineId => NULL,
14788: x_Token1 => 'ENDDATE',
14789: x_Value1 => TRUNC(rlm_dp_sv.g_dsp_start_time) + v_frozenDays - 1, --Bugfix 10053830
14790: x_Token2 => 'SHIP_FROM',
14791: x_Value2 => rlm_core_sv.get_ship_from(x_group_rec.ship_from_org_id),
14792: x_Token3 => 'SHIP_TO',
14793: x_Value3 => rlm_core_sv.get_ship_to(x_group_rec.ship_to_address_id),

Line 14822: x_Value1 => TRUNC(rlm_dp_sv.g_dsp_start_time) + v_frozenDays - 1, --Bugfix 10053830

14818: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14819: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,
14820: x_OrderLineId => NULL,
14821: x_Token1 => 'ENDDATE',
14822: x_Value1 => TRUNC(rlm_dp_sv.g_dsp_start_time) + v_frozenDays - 1, --Bugfix 10053830
14823: x_Token2 => 'SHIP_FROM',
14824: x_Value2 => rlm_core_sv.get_ship_from(x_group_rec.ship_from_org_id),
14825: x_Token3 => 'SHIP_TO',
14826: x_Value3 => rlm_core_sv.get_ship_to(x_group_rec.ship_to_address_id),

Line 14855: x_Value1 => TRUNC(rlm_dp_sv.g_dsp_start_time) + v_frozenDays - 1, --Bugfix 10053830

14851: x_ScheduleHeaderId => x_sched_rec.schedule_header_id,
14852: x_OrderHeaderId => x_group_rec.setup_terms_rec.header_id,
14853: x_OrderLineId => NULL,
14854: x_Token1 => 'ENDDATE',
14855: x_Value1 => TRUNC(rlm_dp_sv.g_dsp_start_time) + v_frozenDays - 1, --Bugfix 10053830
14856: x_Token2 => 'SHIP_FROM',
14857: x_Value2 => rlm_core_sv.get_ship_from(x_group_rec.ship_from_org_id),
14858: x_Token3 => 'SHIP_TO',
14859: x_Value3 => rlm_core_sv.get_ship_to(x_group_rec.ship_to_address_id),

Line 14903: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

14899: in the overall frozen fence message for bug 4223359.
14900: ==============================================================================*/
14901:
14902: PROCEDURE GetMatchAttributes(x_sched_rec IN rlm_interface_headers%ROWTYPE,
14903: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
14904: x_frozenTabRec IN t_generic_rec,
14905: x_MatAttrCodeValue OUT NOCOPY VARCHAR2)
14906: IS
14907: --

Line 15189: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

15185: RecGroupDemand() again in procedure RecDemand().
15186:
15187: =======================================================================*/
15188: PROCEDURE ProcessReleases(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
15189: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
15190: x_Processed IN OUT NOCOPY VARCHAR2) IS
15191: --
15192: v_BlkGroup_ref t_Cursor_ref;
15193: v_BlkGroup_rec rlm_dp_sv.t_Group_rec;

Line 15193: v_BlkGroup_rec rlm_dp_sv.t_Group_rec;

15189: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
15190: x_Processed IN OUT NOCOPY VARCHAR2) IS
15191: --
15192: v_BlkGroup_ref t_Cursor_ref;
15193: v_BlkGroup_rec rlm_dp_sv.t_Group_rec;
15194: e_lines_locked EXCEPTION;
15195: v_sf_org_id NUMBER;
15196: v_rso_start_date DATE;
15197: --

Line 15345: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

15341:
15342: ===========================================================================*/
15343: --Bugfix 7007638 Start
15344: PROCEDURE PopulateReconcileCumRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
15345: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
15346: IS
15347:
15348: CURSOR c_CUMRec IS
15349: SELECT x_group_rec.customer_id,

Line 15450: FUNCTION Match_PO_RY_Reconcile(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

15446:
15447: FUNCTION Match_PO_RY_Reconcile
15448:
15449: ===========================================================================*/
15450: FUNCTION Match_PO_RY_Reconcile(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
15451: x_Current_rec IN t_Generic_rec,
15452: x_Index OUT NOCOPY NUMBER)
15453: RETURN BOOLEAN
15454: IS