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 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 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 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 1542: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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)
1546: IS

Line 1975: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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

Line 2229: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

2225: PROCEDURE GetDemand
2226:
2227: ===========================================================================*/
2228: PROCEDURE GetDemand(x_Key_rec IN OUT NOCOPY RLM_RD_SV.t_Key_rec,
2229: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)
2230: IS
2231: x_progress VARCHAR2(3) := '010';
2232: v_sql VARCHAR2(32000);
2233: c_Demand t_Cursor_ref;

Line 2439: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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)
2443: IS

Line 3367: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

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';
3370:
3371: BEGIN

Line 3440: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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
3444: x_progress VARCHAR2(3) := '010';

Line 3690: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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
3694: x_progress VARCHAR2(3) := '010';

Line 3728: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

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

Line 4168: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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

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

4271:
4272: PROCEDURE ReconcileShipments
4273:
4274: ===========================================================================*/
4275: PROCEDURE ReconcileShipments(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
4276: x_Key_rec IN RLM_RD_SV.t_Key_rec,
4277: x_Quantity IN OUT NOCOPY NUMBER)
4278: IS
4279:

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

4350:
4351: FUNCTION MatchShipments
4352:
4353: ===========================================================================*/
4354: FUNCTION MatchShipments(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
4355: x_Current_rec IN RLM_RD_SV.t_Generic_rec,
4356: x_Index OUT NOCOPY NUMBER)
4357: RETURN BOOLEAN
4358: IS

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

4443: this is required to find duplicate records in the g_reconcile_tab to
4444: print the aggregate frozenQty message
4445:
4446: ===========================================================================*/
4447: FUNCTION MatchFrozen(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
4448: x_Index2 IN NUMBER,
4449: x_Current_rec IN t_Generic_rec,
4450: x_Index OUT NOCOPY NUMBER)
4451: RETURN BOOLEAN

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

5522:
5523: FUNCTION MatchReconcile
5524:
5525: ===========================================================================*/
5526: FUNCTION MatchReconcile(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
5527: x_Current_rec IN t_Generic_rec,
5528: x_Index OUT NOCOPY NUMBER)
5529: RETURN BOOLEAN
5530: IS

Line 6664: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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

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

6730:
6731: PROCEDURE Reconcile
6732:
6733: ===========================================================================*/
6734: PROCEDURE Reconcile(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
6735: x_Key_rec IN RLM_RD_SV.t_Key_rec,
6736: x_Quantity IN OUT NOCOPY NUMBER)
6737: IS
6738:

Line 7064: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

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
7068: SELECT line_id, rla_schedule_type_code

Line 7197: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

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
7201: -- selected in procedure GetDemand(). All calls to GetDemand()

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

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

Line 8879: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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,
8883: x_SumOrderedQty IN NUMBER,

Line 9000: x_Group_Rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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,
9004: x_Sql2 OUT NOCOPY VARCHAR2,

Line 10024: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

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;
10028: v_ScheduleType VARCHAR2(30);

Line 10498: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

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;
10502: v_ScheduleType VARCHAR2(30);

Line 10802: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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)
10806: IS

Line 10904: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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

Line 10965: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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)
10969: IS

Line 11153: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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)
11157: IS

Line 11355: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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

Line 11798: x_Group_rec IN rlm_dp_sv.t_Group_rec,

11794:
11795: ===========================================================================*/
11796: PROCEDURE UpdateGroupStatus( x_header_id IN NUMBER,
11797: x_ScheduleHeaderId IN NUMBER,
11798: x_Group_rec IN rlm_dp_sv.t_Group_rec,
11799: x_status IN NUMBER,
11800: x_UpdateLevel IN VARCHAR2)
11801: IS
11802: x_progress VARCHAR2(3) := '010';

Line 11904: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

11900: FUNCTION IsFrozen
11901:
11902: ===========================================================================*/
11903: FUNCTION IsFrozen(x_horizon_start_date IN DATE,
11904: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
11905: x_ShipDate IN DATE)
11906: RETURN BOOLEAN
11907: IS
11908:

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

12077:
12078: FUNCTION LockLines
12079:
12080: ===========================================================================*/
12081: FUNCTION LockLines (x_Group_rec IN rlm_dp_sv.t_Group_rec,
12082: x_header_id IN NUMBER)
12083: RETURN BOOLEAN
12084: IS
12085: x_progress VARCHAR2(3) := '010';

Line 12150: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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)
12154: IS

Line 12399: x_group_rec IN rlm_dp_sv.t_Group_rec,

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,
12403: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 12627: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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';
12631: x_Query VARCHAR2(32767);

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

12838: --
12839: END PrintMatchRec;
12840:
12841:
12842: FUNCTION AlreadyMatched(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
12843: x_match_rec IN WSH_RLM_INTERFACE.t_optional_match_rec, x_Index OUT NOCOPY NUMBER)
12844: RETURN BOOLEAN
12845: IS
12846: --

Line 13258: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec)

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

Line 13453: x_Group_rec IN rlm_dp_sv.t_Group_rec,

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)
13457: IS

Line 13745: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

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: --
13748: x_progress VARCHAR2(3) := '010';
13749: --

Line 13826: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

13822: FUNCTION FetchBlktGroup
13823:
13824: ===========================================================================*/
13825: FUNCTION FetchBlktGrp(x_Group_ref IN OUT NOCOPY t_Cursor_ref,
13826: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
13827: RETURN BOOLEAN
13828: IS
13829: --
13830: x_progress VARCHAR2(3) := '010';

Line 14046: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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: --
14050: i NUMBER;

Line 14153: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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

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

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;
14444: v_Count NUMBER DEFAULT 0;

Line 14709: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,

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

Line 14995: x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,

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;
14999: v_BlkGroup_rec rlm_dp_sv.t_Group_rec;

Line 14999: v_BlkGroup_rec rlm_dp_sv.t_Group_rec;

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;
14999: v_BlkGroup_rec rlm_dp_sv.t_Group_rec;
15000: e_lines_locked EXCEPTION;
15001: v_sf_org_id NUMBER;
15002: v_rso_start_date DATE;
15003: --

Line 15151: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)

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
15155: SELECT x_group_rec.customer_id,

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

15252:
15253: FUNCTION Match_PO_RY_Reconcile
15254:
15255: ===========================================================================*/
15256: FUNCTION Match_PO_RY_Reconcile(x_Group_rec IN OUT NOCOPY RLM_DP_SV.t_Group_rec,
15257: x_Current_rec IN t_Generic_rec,
15258: x_Index OUT NOCOPY NUMBER)
15259: RETURN BOOLEAN
15260: IS