DBA Data[Home] [Help]

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 1545: PROCEDURE InsertRequirement(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

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

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

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

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

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

3526:
3527: PROCEDURE InitializeSoGroup
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';

Line 3555: FROM rlm_interface_headers rih,

3551: ril.intmed_ship_to_org_id --Bugfix 5911991
3552: --ril.order_header_id,
3553: --ril.blanket_number
3554: --ril.cust_production_seq_num
3555: FROM rlm_interface_headers rih,
3556: rlm_interface_lines_all ril
3557: WHERE rih.header_id = x_Sched_rec.header_id
3558: AND rih.org_id = ril.org_id
3559: AND ril.header_id = rih.header_id

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

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

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

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

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

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

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

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

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

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

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

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

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

7357: PROCEDURE ProcessOld
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

Line 8900: x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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
8904: v_cannot_replace NUMBER;

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

8960:
8961: END SchedulePrecedence;
8962:
8963:
8964: PROCEDURE CountMatchedDemand(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
8965: x_key_rec IN RLM_RD_SV.t_Key_rec,
8966: x_rlm_line_id IN NUMBER,
8967: x_oe_line_id IN NUMBER,
8968: x_DemandCount IN OUT NOCOPY NUMBER,

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

9048:
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,

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

9169: v_NewDemand => x_Sql2
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,

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

10193: (1) New code with performance changes (dynamic sql)
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;

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

10667: (1) New version with dynamic sql for performance changes
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;

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

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

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

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

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

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

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

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

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

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

Line 12177: FROM rlm_interface_headers

12173: x_progress VARCHAR2(3) := '010';
12174:
12175: CURSOR c IS
12176: SELECT *
12177: FROM rlm_interface_headers
12178: WHERE header_id = x_header_id
12179: AND process_status IN (rlm_core_sv.k_PS_AVAILABLE,rlm_core_sv.k_PS_PARTIAL_PROCESSED)
12180: FOR UPDATE NOWAIT;
12181:

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

12182: BEGIN
12183: --
12184: IF (l_debug <> -1) THEN
12185: rlm_core_sv.dpush(k_SDEBUG,'LockHeaders');
12186: rlm_core_sv.dlog(k_DEBUG,'Locking RLM_INTERFACE_HEADERS');
12187: END IF;
12188: --
12189: OPEN c;
12190: --

Line 12242: UPDATE rlm_interface_headers

12238: rlm_core_sv.dpush(k_SDEBUG,'UpdateHeaderStatus');
12239: rlm_core_sv.dlog(k_DEBUG,'UpdateHeaderStatus to ', x_status);
12240: END IF;
12241: --
12242: UPDATE rlm_interface_headers
12243: SET process_status = x_Status
12244: WHERE header_id = x_HeaderId;
12245:
12246: UPDATE rlm_schedule_headers

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

12339: PROCEDURE NAME: CheckTolerance
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)

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

12588:
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,

Line 12697: FROM rlm_interface_headers

12693: END IF;
12694: --
12695: SELECT ECE_TP_LOCATION_CODE_EXT, ECE_TP_TRANSLATOR_CODE
12696: INTO v_ece_tp_location_code_ext,v_ece_tp_translator_code
12697: FROM rlm_interface_headers
12698: WHERE header_id = x_key_rec.req_rec.header_id;
12699: --
12700: IF v_ECE_TP_LOCATION_CODE_EXT is NOT NULL THEN
12701: --

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

12816: --
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';

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

13447: FUNCTION NAME: MRPOnly
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

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

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

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

13933:
13934: PROCEDURE InitializeBlktGroup
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: --

Line 13963: FROM rlm_interface_headers rih,

13959: ril.blanket_number,
13960: rso.effective_start_date,
13961: ril.intrmd_ship_to_id, --Bugfix 5911991
13962: ril.intmed_ship_to_org_id --Bugfix 5911991
13963: FROM rlm_interface_headers rih,
13964: rlm_interface_lines_all ril,
13965: rlm_blanket_rso rso
13966: WHERE rih.header_id = x_Sched_rec.header_id
13967: AND rih.org_id = ril.org_id

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

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

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

14342: END SourceCUMIntransitQty;
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

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

14629: PROCEDURE NAME: FrozenFenceWarning
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;

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

14898: Added this new procedure to get the matching attributes code value pair to display
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

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

15184: variable x_Processed to Y, so we do not call
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;

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

15340: PROCEDURE NAME: PopulateReconcileCumRec
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