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

393: PROCEDURE NAME: PopulateLastReceiptRec
394:
395: ===========================================================================*/
396:
397: PROCEDURE PopulateLastReceiptRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
398: x_Group_rec IN rlm_dp_sv.t_Group_rec)
399: IS
400: --
401: CURSOR c_LastReceipt IS

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

478: PROCEDURE NAME: PopulateCUMRec
479:
480: ===========================================================================*/
481:
482: PROCEDURE PopulateCUMRec(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
483: x_Group_rec IN rlm_dp_sv.t_Group_rec)
484: IS
485: --Created cursor for Bugfix 7007638
486: CURSOR c_CUMRec IS

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

627: PROCEDURE NAME: PopulateMD
628:
629: ===========================================================================*/
630:
631: PROCEDURE PopulateMD(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
632: x_Group_rec IN rlm_dp_sv.t_Group_rec,
633: x_IncludeCUM IN VARCHAR2)
634: IS
635: --

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

780: PROCEDURE NAME: CUMDiscrepancyCheck
781:
782: ===========================================================================*/
783:
784: PROCEDURE CUMDiscrepancyCheck( x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
785: x_Group_rec IN rlm_dp_sv.t_Group_rec)
786: IS
787: --
788: v_ReturnStatus VARCHAR2(30) := 'SUCCESS';

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

1417: PROCEDURE NAME: CUMToDiscrete
1418:
1419: ===========================================================================*/
1420:
1421: PROCEDURE CUMToDiscrete(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1422: x_Group_rec IN rlm_dp_sv.t_Group_rec)
1423: IS
1424: --
1425: v_current_rec NUMBER;

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

1937:
1938: PROCEDURE NAME: ApplySourceRules
1939:
1940: ===========================================================================*/
1941: PROCEDURE ApplySourceRules(x_Sched_rec IN rlm_interface_headers%ROWTYPE,
1942: x_Group_rec IN rlm_dp_sv.t_Group_rec,
1943: x_SourcedDemand_tab OUT NOCOPY rlm_manage_demand_sv.t_MD_Tab,
1944: x_Source_Tab OUT NOCOPY rlm_manage_demand_sv.t_Source_Tab)
1945: IS

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

2873: PROCEDURE NAME: CalculateShipDate
2874:
2875: ===========================================================================*/
2876:
2877: PROCEDURE CalculateShipDate(x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
2878: x_Group_rec IN rlm_dp_sv.t_Group_rec)
2879: IS
2880:
2881: i NUMBER;

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

3212: PROCEDURE NAME: ApplyFFFFences
3213:
3214: ===========================================================================*/
3215:
3216: PROCEDURE ApplyFFFFences(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
3217: x_Group_rec IN rlm_dp_sv.t_Group_rec,
3218: IsLineProcessed IN OUT NOCOPY BOOLEAN)
3219: IS
3220:

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

5731: PROCEDURE NAME: RoundStandardPack
5732:
5733: ===========================================================================*/
5734:
5735: PROCEDURE RoundStandardPack(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
5736: x_Group_rec IN rlm_dp_sv.t_Group_rec)
5737: IS
5738:
5739: v_RoundPack VARCHAR(1);

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

5993:
5994: PROCEDURE InitializeMdGroup
5995:
5996: ===========================================================================*/
5997: PROCEDURE InitializeMdGroup(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
5998: x_Group_ref IN OUT NOCOPY rlm_manage_demand_sv.t_Cursor_ref,
5999: x_Group_rec IN rlm_dp_sv.t_Group_rec)
6000: IS
6001:

Line 6022: FROM rlm_interface_headers rih,

6018: -- CR changes
6019: ril.ship_to_customer_id
6020: -- Perf change
6021: -- ril.cust_production_seq_num
6022: FROM rlm_interface_headers rih,
6023: rlm_interface_lines_all ril
6024: WHERE rih.header_id = x_Sched_rec.header_id
6025: AND rih.org_id = ril.org_id
6026: AND ril.header_id = rih.header_id

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

6122:
6123: PROCEDURE CallSetups
6124:
6125: ===========================================================================*/
6126: PROCEDURE CallSetups(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6127: x_Group_rec IN OUT NOCOPY rlm_dp_sv.t_Group_rec)
6128: IS
6129:
6130: v_SetupTerms_rec rlm_setup_terms_sv.setup_terms_rec_typ;

Line 6459: UPDATE rlm_interface_headers_all

6455: rlm_core_sv.dlog(C_DEBUG,'x_ScheduleHeaderId',x_ScheduleHeaderId);
6456: rlm_core_sv.dlog(C_DEBUG,'x_ProcessStatus',x_ProcessStatus);
6457: END IF;
6458: --
6459: UPDATE rlm_interface_headers_all
6460: SET process_status = x_ProcessStatus
6461: WHERE header_id = x_HeaderId;
6462: --
6463: IF (l_debug <> -1) THEN

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

6675:
6676: FUNCTION NAME: GetTPContext
6677:
6678: ===========================================================================*/
6679: PROCEDURE GetTPContext( x_sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6680: x_group_rec IN rlm_dp_sv.t_Group_rec,
6681: x_customer_number OUT NOCOPY VARCHAR2,
6682: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
6683: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,

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

6785:
6786: /*any changes to this package may be incorporated in the function rlm_managedemand_sv.GetAllIntransitQty and rlm_rd_sv.SynchronizeShipments and vice versa */
6787:
6788:
6789: FUNCTION CalculateIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6790: x_Group_rec IN rlm_dp_sv.t_Group_rec)
6791: RETURN NUMBER
6792: IS
6793: --

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

7000:
7001: END CalculateIntransitQty;
7002:
7003:
7004: FUNCTION GetAllIntransitQty(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7005: x_Group_rec IN rlm_dp_sv.t_Group_rec,
7006: x_Source_Tab IN RLM_MANAGE_DEMAND_SV.t_Source_Tab)
7007: RETURN NUMBER
7008: IS

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

7976: --
7977: -- Bug 2788014: Calculate intransit quantities across orgs and orders
7978: -- if CUM org level is xxx/All Ship Froms
7979: --
7980: FUNCTION GetIntransitAcrossOrgs(x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7981: x_Group_rec IN rlm_dp_sv.t_Group_rec,
7982: x_cum_key_id IN NUMBER)
7983: RETURN NUMBER IS
7984: -- The shipper ID is stored in the item_detail_ref_value_1 field