DBA Data[Home] [Help]

APPS.RLM_MANAGE_DEMAND_SV dependencies on RLM_INTERFACE_HEADERS

Line 17: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 244: PROCEDURE ManageGroupDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

240: PROCEDURE NAME: ManageGroupDemand
241:
242: ===========================================================================*/
243:
244: PROCEDURE ManageGroupDemand(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
245: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec,
246: x_ReturnStatus OUT NOCOPY NUMBER)
247: IS
248: --

Line 403: PROCEDURE PopulateLastReceiptRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 488: PROCEDURE PopulateCUMRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 637: PROCEDURE PopulateMD(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 790: PROCEDURE CUMDiscrepancyCheck( x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 1427: PROCEDURE CUMToDiscrete(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 1947: PROCEDURE ApplySourceRules(x_Sched_rec IN rlm_interface_headers%ROWTYPE,

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

Line 2931: PROCEDURE CalculateShipDate(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 3270: PROCEDURE ApplyFFFFences(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 5826: PROCEDURE RoundStandardPack(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 6088: PROCEDURE InitializeMdGroup(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 6113: FROM rlm_interface_headers rih,

6109: -- CR changes
6110: ril.ship_to_customer_id
6111: -- Perf change
6112: -- ril.cust_production_seq_num
6113: FROM rlm_interface_headers rih,
6114: rlm_interface_lines_all ril
6115: WHERE rih.header_id = x_Sched_rec.header_id
6116: AND rih.org_id = ril.org_id
6117: AND ril.header_id = rih.header_id

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

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

Line 6550: UPDATE rlm_interface_headers_all

6546: rlm_core_sv.dlog(C_DEBUG,'x_ScheduleHeaderId',x_ScheduleHeaderId);
6547: rlm_core_sv.dlog(C_DEBUG,'x_ProcessStatus',x_ProcessStatus);
6548: END IF;
6549: --
6550: UPDATE rlm_interface_headers_all
6551: SET process_status = x_ProcessStatus
6552: WHERE header_id = x_HeaderId;
6553: --
6554: IF (l_debug <> -1) THEN

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

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

Line 6880: FUNCTION CalculateIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 7094: FUNCTION GetAllIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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

Line 8070: FUNCTION GetIntransitAcrossOrgs(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

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