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_INTERFACE_HEADERS

Line 17: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

13: PROCEDURE NAME: RecDemand
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: --

Line 169: PROCEDURE RecGroupDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

165: PROCEDURE NAME: RecGroupDemand
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';

Line 443: PROCEDURE CallSetups(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

439:
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;

Line 714: PROCEDURE ExecOperations(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

710:
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: --

Line 810: PROCEDURE CancelPreHorizonNATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

806:
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

Line 1131: PROCEDURE DeleteRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1127:
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)

Line 1541: PROCEDURE InsertRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1537:
1538: PROCEDURE InsertRequirement
1539:
1540: ===========================================================================*/
1541: PROCEDURE InsertRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1542: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
1543: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
1544: x_Reconcile IN BOOLEAN,
1545: x_Quantity IN OUT NOCOPY NUMBER)

Line 1974: PROCEDURE UpdateRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1970:
1971: PROCEDURE UpdateRequirement
1972:
1973: ===========================================================================*/
1974: PROCEDURE UpdateRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1975: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
1976: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
1977: x_Quantity IN NUMBER)
1978: IS

Line 2438: PROCEDURE InitializeDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

2434:
2435: PROCEDURE InitializeDemand
2436:
2437: ===========================================================================*/
2438: PROCEDURE InitializeDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
2439: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
2440: x_Key_rec IN RLM_RD_SV.t_Key_rec,
2441: x_Demand_ref IN OUT NOCOPY t_Cursor_ref,
2442: x_DemandType IN VARCHAR2)

Line 3365: PROCEDURE InitializeSoGroup(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

3361:
3362: PROCEDURE InitializeSoGroup
3363:
3364: ===========================================================================*/
3365: PROCEDURE InitializeSoGroup(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3366: x_Group_ref IN OUT NOCOPY rlm_rd_sv.t_Cursor_ref,
3367: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
3368: IS
3369: x_progress VARCHAR2(3) := '010';

Line 3390: FROM rlm_interface_headers rih,

3386: ril.intmed_ship_to_org_id --Bugfix 5911991
3387: --ril.order_header_id,
3388: --ril.blanket_number
3389: --ril.cust_production_seq_num
3390: FROM rlm_interface_headers rih,
3391: rlm_interface_lines_all ril
3392: WHERE rih.header_id = x_Sched_rec.header_id
3393: AND rih.org_id = ril.org_id
3394: AND ril.header_id = rih.header_id

Line 3439: PROCEDURE InitializeReq(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

3435:
3436: PROCEDURE InitializeReq
3437:
3438: ===========================================================================*/
3439: PROCEDURE InitializeReq(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3440: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
3441: x_Req_ref IN OUT NOCOPY t_Cursor_ref,
3442: x_ReqType IN VARCHAR2)
3443: IS

Line 3689: PROCEDURE CancelRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

3685:
3686: PROCEDURE CancelRequirement
3687:
3688: ===========================================================================*/
3689: PROCEDURE CancelRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3690: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
3691: x_Key_rec IN RLM_RD_SV.t_Key_rec,
3692: x_CancelQty IN NUMBER)
3693: IS

Line 3727: PROCEDURE SynchronizeShipments(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

3723:
3724: PROCEDURE SynchronizeShipments
3725:
3726: ===========================================================================*/
3727: PROCEDURE SynchronizeShipments(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3728: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
3729: IS
3730: --
3731: v_InTransitQty NUMBER;

Line 4167: PROCEDURE StoreShipments(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

4163:
4164: PROCEDURE StoreShipments
4165:
4166: ===========================================================================*/
4167: PROCEDURE StoreShipments(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
4168: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
4169: x_Key_rec IN RLM_RD_SV.t_Key_rec,
4170: x_Quantity IN NUMBER)
4171: IS

Line 6663: PROCEDURE StoreReconcile(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

6659:
6660: PROCEDURE StoreReconcile
6661:
6662: ===========================================================================*/
6663: PROCEDURE StoreReconcile(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6664: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
6665: x_Key_rec IN RLM_RD_SV.t_Key_rec,
6666: x_Quantity IN NUMBER)
6667: IS

Line 7063: PROCEDURE ProcessPreHorizonATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

7059:
7060: PROCEDURE ProcessPreHorizonATS
7061:
7062: ===========================================================================*/
7063: PROCEDURE ProcessPreHorizonATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7064: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
7065: IS
7066:
7067: CURSOR c_PreHorizonDisp (x_OffsetDays NUMBER) IS

Line 7196: PROCEDURE ProcessOld(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

7192: PROCEDURE ProcessOld
7193: -- NOTE JH: open issue with bucket requirements overlapping end horizon date
7194:
7195: ===========================================================================*/
7196: PROCEDURE ProcessOld(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7197: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
7198: IS
7199: --
7200: -- Bug 3733520 : Modified cursor to select attributes that are

Line 8726: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

8722: FUNCTION SchedulePrecedence
8723:
8724: ===========================================================================*/
8725: FUNCTION SchedulePrecedence(x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
8726: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
8727: x_ScheduleType IN VARCHAR2)
8728: RETURN BOOLEAN
8729: IS
8730: v_cannot_replace NUMBER;

Line 8790: PROCEDURE CountMatchedDemand(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

8786:
8787: END SchedulePrecedence;
8788:
8789:
8790: PROCEDURE CountMatchedDemand(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
8791: x_key_rec IN RLM_RD_SV.t_Key_rec,
8792: x_rlm_line_id IN NUMBER,
8793: x_oe_line_id IN NUMBER,
8794: x_DemandCount IN OUT NOCOPY NUMBER,

Line 8878: PROCEDURE ReconcileAction(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

8874:
8875: END CountMatchedDemand;
8876:
8877:
8878: PROCEDURE ReconcileAction(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
8879: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
8880: x_key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
8881: x_line_id_tab IN RLM_RD_SV.t_matching_line,
8882: x_DemandCount IN NUMBER,

Line 8999: PROCEDURE BuildMatchQuery(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

8995: v_NewDemand => x_Sql2
8996:
8997: =============================================================================================== */
8998:
8999: PROCEDURE BuildMatchQuery(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
9000: x_Group_Rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
9001: x_Demand_Type IN VARCHAR2,
9002: x_Sql OUT NOCOPY VARCHAR2,
9003: x_Sql1 OUT NOCOPY VARCHAR2,

Line 10023: PROCEDURE ProcessATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

10019: (1) New code with performance changes (dynamic sql)
10020:
10021: ===========================================================================*/
10022:
10023: PROCEDURE ProcessATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
10024: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
10025: IS
10026:
10027: v_Key_rec t_Key_rec;

Line 10497: PROCEDURE ProcessNATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

10493: (1) New version with dynamic sql for performance changes
10494:
10495: ===========================================================================*/
10496:
10497: PROCEDURE ProcessNATS(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
10498: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
10499: IS
10500:
10501: v_Key_rec t_Key_rec;

Line 10801: PROCEDURE UpdateDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

10797:
10798: PROCEDURE UpdateDemand
10799:
10800: ===========================================================================*/
10801: PROCEDURE UpdateDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
10802: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
10803: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
10804: x_SumOrderedQty IN NUMBER,
10805: x_DemandType IN VARCHAR2)

Line 10903: PROCEDURE DeleteDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

10899:
10900: PROCEDURE DeleteDemand
10901:
10902: ===========================================================================*/
10903: PROCEDURE DeleteDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
10904: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
10905: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
10906: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref)
10907: IS

Line 10964: PROCEDURE IncreaseDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

10960:
10961: PROCEDURE IncreaseDemand
10962:
10963: ===========================================================================*/
10964: PROCEDURE IncreaseDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
10965: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
10966: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
10967: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
10968: x_SumOrderedQty IN NUMBER)

Line 11152: PROCEDURE DecreaseDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

11148:
11149: PROCEDURE DecreaseDemand
11150:
11151: ===========================================================================*/
11152: PROCEDURE DecreaseDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
11153: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
11154: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
11155: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref,
11156: x_SumOrderedQty IN NUMBER)

Line 11354: PROCEDURE OtherDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

11350:
11351: PROCEDURE OtherDemand
11352:
11353: ===========================================================================*/
11354: PROCEDURE OtherDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
11355: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
11356: x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
11357: x_Demand_ref IN OUT NOCOPY RLM_RD_SV.t_Cursor_ref)
11358: IS

Line 11983: FROM rlm_interface_headers

11979: x_progress VARCHAR2(3) := '010';
11980:
11981: CURSOR c IS
11982: SELECT *
11983: FROM rlm_interface_headers
11984: WHERE header_id = x_header_id
11985: AND process_status IN (rlm_core_sv.k_PS_AVAILABLE,rlm_core_sv.k_PS_PARTIAL_PROCESSED)
11986: FOR UPDATE NOWAIT;
11987:

Line 11992: rlm_core_sv.dlog(k_DEBUG,'Locking RLM_INTERFACE_HEADERS');

11988: BEGIN
11989: --
11990: IF (l_debug <> -1) THEN
11991: rlm_core_sv.dpush(k_SDEBUG,'LockHeaders');
11992: rlm_core_sv.dlog(k_DEBUG,'Locking RLM_INTERFACE_HEADERS');
11993: END IF;
11994: --
11995: OPEN c;
11996: --

Line 12048: UPDATE rlm_interface_headers

12044: rlm_core_sv.dpush(k_SDEBUG,'UpdateHeaderStatus');
12045: rlm_core_sv.dlog(k_DEBUG,'UpdateHeaderStatus to ', x_status);
12046: END IF;
12047: --
12048: UPDATE rlm_interface_headers
12049: SET process_status = x_Status
12050: WHERE header_id = x_HeaderId;
12051:
12052: UPDATE rlm_schedule_headers

Line 12149: PROCEDURE CheckTolerance(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

12145: PROCEDURE NAME: CheckTolerance
12146:
12147: ===========================================================================*/
12148:
12149: PROCEDURE CheckTolerance(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
12150: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
12151: x_Key_rec IN RLM_RD_SV.t_Key_rec,
12152: x_OldQty IN NUMBER,
12153: x_NewQty IN NUMBER)

Line 12398: PROCEDURE GetTPContext( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

12394:
12395: FUNCTION NAME: GetTPContext
12396:
12397: ===========================================================================*/
12398: PROCEDURE GetTPContext( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
12399: x_group_rec IN rlm_dp_sv.t_Group_rec,
12400: x_req_rec IN rlm_rd_sv.t_generic_rec,
12401: x_customer_number OUT NOCOPY VARCHAR2,
12402: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 12503: FROM rlm_interface_headers

12499: END IF;
12500: --
12501: SELECT ECE_TP_LOCATION_CODE_EXT, ECE_TP_TRANSLATOR_CODE
12502: INTO v_ece_tp_location_code_ext,v_ece_tp_translator_code
12503: FROM rlm_interface_headers
12504: WHERE header_id = x_key_rec.req_rec.header_id;
12505: --
12506: IF v_ECE_TP_LOCATION_CODE_EXT is NOT NULL THEN
12507: --

Line 12626: PROCEDURE InitializeMatchRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

12622: --
12623: END GetTPContext;
12624:
12625:
12626: PROCEDURE InitializeMatchRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
12627: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
12628: x_match_ref IN OUT NOCOPY t_Cursor_ref) IS
12629: --
12630: x_progress VARCHAR2(3) := '010';

Line 13257: FUNCTION MRPOnly(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

13253: FUNCTION NAME: MRPOnly
13254:
13255: ===========================================================================*/
13256:
13257: FUNCTION MRPOnly(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
13258: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
13259: RETURN BOOLEAN
13260:
13261: IS

Line 13452: PROCEDURE InitializeIntransitParam(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

13448: --
13449: -- Common to reconcile and manage demand
13450: -- Set up parameters to pass to shipping API
13451: --
13452: PROCEDURE InitializeIntransitParam(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
13453: x_Group_rec IN rlm_dp_sv.t_Group_rec,
13454: x_intransit_calc_basis IN VARCHAR2,
13455: x_Shipper_rec IN OUT NOCOPY WSH_RLM_INTERFACE.t_shipper_rec,
13456: x_Shipment_date IN OUT NOCOPY DATE)

Line 13743: PROCEDURE InitializeBlktGrp(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

13739:
13740: PROCEDURE InitializeBlktGroup
13741:
13742: ===========================================================================*/
13743: PROCEDURE InitializeBlktGrp(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
13744: x_Group_ref IN OUT NOCOPY rlm_rd_sv.t_Cursor_ref,
13745: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
13746: IS
13747: --

Line 13769: FROM rlm_interface_headers rih,

13765: ril.blanket_number,
13766: rso.effective_start_date,
13767: ril.intrmd_ship_to_id, --Bugfix 5911991
13768: ril.intmed_ship_to_org_id --Bugfix 5911991
13769: FROM rlm_interface_headers rih,
13770: rlm_interface_lines_all ril,
13771: rlm_blanket_rso rso
13772: WHERE rih.header_id = x_Sched_rec.header_id
13773: AND rih.org_id = ril.org_id

Line 14045: PROCEDURE SourceCUMIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

14041:
14042: PROCEDURE NAME: SourceCUMIntransitQty
14043:
14044: ==============================================================================*/
14045: PROCEDURE SourceCUMIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
14046: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
14047: x_Cum_rec IN RLM_RD_SV.t_Ship_rec) --Bugfix 7007638
14048: IS
14049: --

Line 14152: PROCEDURE CalculateCUMIntransit(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

14148: END SourceCUMIntransitQty;
14149:
14150:
14151:
14152: PROCEDURE CalculateCUMIntransit(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
14153: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
14154: x_Line_id IN NUMBER, --Bugfix 7007638
14155: x_Intransit OUT NOCOPY NUMBER)
14156: IS

Line 14439: PROCEDURE FrozenFenceWarning(x_sched_rec IN rlm_interface_headers%ROWTYPE,

14435: PROCEDURE NAME: FrozenFenceWarning
14436: Added this new procedure to give the overall frozen period warning for bug4223359
14437: ==============================================================================*/
14438:
14439: PROCEDURE FrozenFenceWarning(x_sched_rec IN rlm_interface_headers%ROWTYPE,
14440: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec) IS
14441: --
14442: i NUMBER DEFAULT 0;
14443: v_index NUMBER DEFAULT 0;

Line 14708: PROCEDURE GetMatchAttributes(x_sched_rec IN rlm_interface_headers%ROWTYPE,

14704: Added this new procedure to get the matching attributes code value pair to display
14705: in the overall frozen fence message for bug 4223359.
14706: ==============================================================================*/
14707:
14708: PROCEDURE GetMatchAttributes(x_sched_rec IN rlm_interface_headers%ROWTYPE,
14709: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
14710: x_frozenTabRec IN t_generic_rec,
14711: x_MatAttrCodeValue OUT NOCOPY VARCHAR2)
14712: IS

Line 14994: PROCEDURE ProcessReleases(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

14990: variable x_Processed to Y, so we do not call
14991: RecGroupDemand() again in procedure RecDemand().
14992:
14993: =======================================================================*/
14994: PROCEDURE ProcessReleases(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
14995: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
14996: x_Processed IN OUT NOCOPY VARCHAR2) IS
14997: --
14998: v_BlkGroup_ref t_Cursor_ref;

Line 15150: PROCEDURE PopulateReconcileCumRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

15146: PROCEDURE NAME: PopulateReconcileCumRec
15147:
15148: ===========================================================================*/
15149: --Bugfix 7007638 Start
15150: PROCEDURE PopulateReconcileCumRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
15151: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
15152: IS
15153:
15154: CURSOR c_CUMRec IS