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_VALIDATEDEMAND_SV dependencies on RLM_INTERFACE_HEADERS

Line 45: FROM rlm_interface_headers rih,

41: null,
42: null,
43: null,
44: null
45: FROM rlm_interface_headers rih,
46: rlm_interface_lines_all ril
47: WHERE ril.header_id = rih.header_id
48: AND rih.header_id = x_header_id
49: AND rih.org_id = ril.org_id

Line 67: FROM rlm_interface_headers rih,

63: ril.customer_item_ext,
64: null,
65: null,
66: null
67: FROM rlm_interface_headers rih,
68: rlm_interface_lines_all ril
69: WHERE ril.header_id = rih.header_id
70: AND rih.header_id = x_header_id
71: AND rih.org_id = ril.org_id

Line 86: FROM rlm_interface_headers rih,

82: null,
83: ril.customer_item_id,
84: ril.ship_from_org_id,
85: ril.ship_to_address_id
86: FROM rlm_interface_headers rih,
87: rlm_interface_lines_all ril
88: WHERE ril.header_id = rih.header_id
89: AND rih.header_id = x_header_id
90: AND rih.org_id = ril.org_id

Line 180: PROCEDURE CheckHeaderECETpLocCode(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,

176: PROCEDURE NAME: CheckHeaderECETpLocCode
177:
178: ===========================================================================*/
179:
180: PROCEDURE CheckHeaderECETpLocCode(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
181: x_ReturnStatus OUT NOCOPY NUMBER)
182: IS
183: --
184: v_progress VARCHAR2(10) := '010';

Line 433: PROCEDURE GroupValidateDemand(x_Header_Id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE,

429: PROCEDURE NAME: GroupValidateDemand
430:
431: ===========================================================================*/
432:
433: PROCEDURE GroupValidateDemand(x_Header_Id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE,
434: x_Procedure_Status OUT NOCOPY NUMBER)
435: IS
436: --
437: v_progress VARCHAR2(10) := '010';

Line 887: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

883:
884: ===========================================================================*/
885: PROCEDURE ValidateLineDetails(
886: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
887: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
888: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
889: x_line_source IN VARCHAR2)
890: IS
891: --

Line 1009: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1005: ===========================================================================*/
1006:
1007: PROCEDURE ValidOrderHeaderId(
1008: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
1009: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1010: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
1011: IS
1012: e_NoOrderDefined EXCEPTION;
1013: e_OrderClosed EXCEPTION;

Line 1326: PROCEDURE ValidateUOM(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1322:
1323: PROCEDURE NAME: ValidateUOM
1324:
1325: ===========================================================================*/
1326: PROCEDURE ValidateUOM(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1327: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
1328: IS
1329: v_Progress VARCHAR(3) := '010';
1330: v_Primary_UOM_Code VARCHAR(3);

Line 1501: PROCEDURE ValidDateRange(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1497:
1498: PROCEDURE NAME: ValidDateRange
1499:
1500: ===========================================================================*/
1501: PROCEDURE ValidDateRange(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1502: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
1503: IS
1504: --
1505: v_progress VARCHAR2(3) := '010';

Line 1627: PROCEDURE ValidDateTypeCode(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1623:
1624: PROCEDURE NAME: ValidDateTypeCode
1625:
1626: ===========================================================================*/
1627: PROCEDURE ValidDateTypeCode(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1628: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
1629: IS
1630: --
1631: v_progress VARCHAR2(3) := '010';

Line 1696: PROCEDURE ValidItemDetailQty(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1692:
1693: PROCEDURE NAME: ValidItemDetailQty
1694:
1695: ===========================================================================*/
1696: PROCEDURE ValidItemDetailQty(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1697: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
1698: IS
1699: --
1700: v_progress VARCHAR2(3) := '010';

Line 1779: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1775:
1776: ===========================================================================*/
1777: PROCEDURE ValidQtyTypeCode(
1778: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
1779: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1780: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
1781: IS
1782: --
1783: v_progress VARCHAR2(3) := '010';

Line 1916: PROCEDURE ValidItemDetailSubtype(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1912:
1913: PROCEDURE NAME: ValidItemDetailSubtype
1914:
1915: ===========================================================================*/
1916: PROCEDURE ValidItemDetailSubtype(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1917: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
1918: IS
1919: --
1920: v_progress VARCHAR2(3) := '010';

Line 2008: PROCEDURE ValidItemDetailType(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

2004:
2005: PROCEDURE NAME: ValidItemDetailType
2006:
2007: ===========================================================================*/
2008: PROCEDURE ValidItemDetailType(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
2009: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
2010: IS
2011: --
2012: v_progress VARCHAR2(3) := '010';

Line 2080: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

2076:
2077: ===========================================================================*/
2078: PROCEDURE ValidateCriticalKeys(
2079: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
2080: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
2081: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
2082: IS
2083: --
2084: v_progress VARCHAR2(3) := '010';

Line 2708: FUNCTION BuildHeaderRec(x_header_id IN rlm_interface_headers.header_id%TYPE)

2704:
2705: PROCEDURE NAME: BuildHeaderRec
2706:
2707: ===========================================================================*/
2708: FUNCTION BuildHeaderRec(x_header_id IN rlm_interface_headers.header_id%TYPE)
2709: RETURN BOOLEAN
2710: IS
2711: --
2712: v_Progress VARCHAR2(30) := '010';

Line 2723: FROM rlm_interface_headers

2719: END IF;
2720: --
2721: SELECT *
2722: INTO g_header_rec
2723: FROM rlm_interface_headers
2724: WHERE header_id = x_header_id
2725: FOR UPDATE NOWAIT;
2726: --
2727: IF (l_debug <> -1) THEN

Line 2762: PROCEDURE ApplyHeaderDefaults(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)

2758:
2759: PROCEDURE NAME: ApplyHeaderDefaults
2760:
2761: ===========================================================================*/
2762: PROCEDURE ApplyHeaderDefaults(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)
2763: IS
2764: --
2765: v_progress VARCHAR2(3) := '010';
2766: --

Line 2997: PROCEDURE ValidScheduleHeader(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)

2993:
2994: PROCEDURE NAME: ValidScheduleHeader
2995:
2996: ===========================================================================*/
2997: PROCEDURE ValidScheduleHeader(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)
2998: IS
2999: --
3000: v_progress VARCHAR2(3) := '010';
3001: --

Line 3044: PROCEDURE ValidNumberLines(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)

3040:
3041: PROCEDURE NAME: ValidNumberLines
3042:
3043: ===========================================================================*/
3044: PROCEDURE ValidNumberLines(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)
3045: IS
3046: --
3047: v_progress VARCHAR2(3) := '010';
3048: e_no_lines EXCEPTION;

Line 3112: PROCEDURE ValidScheduleSource(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)

3108:
3109: ===========================================================================*/
3110:
3111:
3112: PROCEDURE ValidScheduleSource(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)
3113: IS
3114: --
3115: v_progress VARCHAR2(3) := '010';
3116: v_Chk_Date DATE;

Line 3263: FROM rlm_interface_headers

3259: OPEN c FOR
3260: SELECT DECODE(schedule_purpose, 'ADD', 1,
3261: 'CONFIRMATION', 2, 'ORIGINAL', 3,'REPLACE', 4,
3262: 'REPLACE_ALL', 5, 'CANCELLATION', 6,'CHANGE', 7, 'DELETE', 8)
3263: FROM rlm_interface_headers
3264: WHERE header_id = x_header_rec.header_id;
3265: FETCH c into v_new_purpose;
3266: CLOSE c;
3267: --

Line 3506: PROCEDURE ValidHorizonDates(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)

3502:
3503: PROCEDURE NAME: ValidHorizonDates
3504:
3505: ===========================================================================*/
3506: PROCEDURE ValidHorizonDates(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)
3507: IS
3508: --
3509: v_progress VARCHAR2(3) := '010';
3510: e_horizon_dates_invalid EXCEPTION;

Line 3582: PROCEDURE ValidScheduleReferenceNum(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)

3578:
3579: PROCEDURE NAME: ValidScheduleReferenceNum
3580:
3581: ===========================================================================*/
3582: PROCEDURE ValidScheduleReferenceNum(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)
3583: IS
3584: --
3585: v_progress VARCHAR2(3) := '010';
3586: e_SchRefInv EXCEPTION;

Line 3647: PROCEDURE ValidScheduleType(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)

3643:
3644: PROCEDURE NAME: ValidScheduleType
3645:
3646: ===========================================================================*/
3647: PROCEDURE ValidScheduleType(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)
3648: IS
3649: --
3650: v_progress VARCHAR2(3) := '010';
3651: e_SchTypeInv EXCEPTION;

Line 3792: PROCEDURE ValidSchedulePurpose(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)

3788:
3789: PROCEDURE NAME: ValidSchedulePurpose
3790:
3791: ===========================================================================*/
3792: PROCEDURE ValidSchedulePurpose(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE)
3793: IS
3794: --
3795: v_progress VARCHAR2(3) := '010';
3796: e_SchPurposeInv EXCEPTION;

Line 3829: FROM rlm_interface_headers

3825: schedule_purpose,
3826: DECODE(schedule_purpose, 'ADD', 1, 'CONFIRMATION', 2, 'ORIGINAL', 3, 'REPLACE', 4,
3827: 'REPLACE_ALL', 5, 'CANCELLATION', 6, 'CHANGE', 7, 'DELETE', 8),
3828: creation_date
3829: FROM rlm_interface_headers
3830: WHERE ece_tp_translator_code = x_header_rec.ece_tp_translator_code
3831: AND ece_tp_location_code_ext = x_header_rec.ece_tp_location_code_ext
3832: AND schedule_type = x_header_rec.schedule_type
3833: AND header_id <> x_header_rec.header_id

Line 3876: FROM rlm_interface_headers

3872: IF x_header_rec.schedule_purpose IN (k_CANCEL, k_CHANGE, k_DELETE)THEN
3873: --
3874: SELECT count(*)
3875: INTO v_sch_pur
3876: FROM rlm_interface_headers
3877: WHERE ece_tp_translator_code = x_header_rec.ece_tp_translator_code
3878: AND ece_tp_location_code_ext=x_header_rec.ece_tp_location_code_ext
3879: AND schedule_type=x_header_rec.schedule_type
3880: AND sched_generation_date = x_header_rec.sched_generation_date

Line 3925: /* Bug 4995267: First query rlm_interface_headers table for schedules, irrespective of their

3921: END IF;
3922: --
3923: ELSE -- When x_header_rec.edi_control_num_2 IS NOT NULL OR x_header_rec.edi_control_num_3 IS NOT NULL
3924: --{
3925: /* Bug 4995267: First query rlm_interface_headers table for schedules, irrespective of their
3926: process_status and start comparing each attribute (one-by-one) as indicated
3927: in the ORDER BY clause (RLMDPWPB). If at any point of attribute comparison,
3928: we find a schedule whose attributes are less than the one currently being
3929: processed, DSP should stop indicating that the processing is out of order. */

Line 4007: FROM rlm_interface_headers

4003: OPEN c FOR
4004: SELECT DECODE(schedule_purpose, 'ADD',1,
4005: 'CONFIRMATION', 2, 'ORIGINAL', 3,'REPLACE', 4,
4006: 'REPLACE_ALL', 5, 'CANCELLATION', 6,'CHANGE', 7, 'DELETE', 8)
4007: FROM rlm_interface_headers
4008: WHERE header_id = x_header_rec.header_id;
4009: FETCH c into v_new_purpose;
4010: CLOSE c;
4011: --

Line 4244: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

4240:
4241: ===========================================================================*/
4242: PROCEDURE DeriveOrgDependentIDs(
4243: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
4244: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
4245: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
4246: IS
4247: --
4248: v_progress VARCHAR2(3) := '010';

Line 4286: PROCEDURE DeriveIDs( x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,

4282:
4283: PROCEDURE NAME: DeriveIDs
4284:
4285: ===========================================================================*/
4286: PROCEDURE DeriveIDs( x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
4287: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
4288: IS
4289:
4290: v_progress VARCHAR2(3) := '010';

Line 4337: PROCEDURE DeriveInventoryItemId(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

4333:
4334: PROCEDURE NAME: DeriveInventoryItemId
4335:
4336: ===========================================================================*/
4337: PROCEDURE DeriveInventoryItemId(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
4338: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
4339: IS
4340: --
4341: v_progress VARCHAR2(3) := '010';

Line 4855: PROCEDURE ValidateCustomerItem(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

4851:
4852: PROCEDURE NAME: ValidateCustomerItem
4853:
4854: ===========================================================================*/
4855: PROCEDURE ValidateCustomerItem(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
4856: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
4857: IS
4858: --
4859: v_progress VARCHAR2(3) := '010';

Line 5002: x_header_rec IN rlm_interface_headers%ROWTYPE,

4998: ===========================================================================*/
4999:
5000: PROCEDURE DerivePurchaseOrder(
5001: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
5002: x_header_rec IN rlm_interface_headers%ROWTYPE,
5003: x_lines_rec IN OUT NOCOPY rlm_interface_lines%ROWTYPE)
5004: IS
5005: --
5006: l_org_code VARCHAR2(30);

Line 5499: PROCEDURE DeriveCustomerID(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,

5495:
5496: PROCEDURE NAME: DeriveCustomerID
5497:
5498: ===========================================================================*/
5499: PROCEDURE DeriveCustomerID(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
5500: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
5501: IS
5502:
5503: v_progress VARCHAR2(3) := '010';

Line 5821: PROCEDURE DeriveShipFromOrg(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

5817:
5818: PROCEDURE NAME: DeriveShipFromOrg
5819:
5820: ===========================================================================*/
5821: PROCEDURE DeriveShipFromOrg(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
5822: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
5823: IS
5824: --
5825: l_org_code VARCHAR2(30);

Line 6016: PROCEDURE DeriveIntrmdShipToID(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

6012:
6013: PROCEDURE NAME: derive_intmd_shipto_id
6014:
6015: ===========================================================================*/
6016: PROCEDURE DeriveIntrmdShipToID(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6017: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
6018: IS
6019: --
6020: CURSOR c_IntrmdShipToID_ext IS --Added cursor as part of Bugfix 8672453

Line 6329: PROCEDURE DeriveBillToID(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

6325:
6326: PROCEDURE NAME: DeriveBillToID
6327:
6328: ===========================================================================*/
6329: PROCEDURE DeriveBillToID(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6330: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
6331: x_cum_org_level_code IN rlm_cust_shipto_terms.cum_org_level_code%TYPE)
6332: IS
6333: --

Line 6800: PROCEDURE DeriveShipToID(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,

6796:
6797: PROCEDURE NAME: DeriveShipToID
6798:
6799: ===========================================================================*/
6800: PROCEDURE DeriveShipToID(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
6801: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
6802: IS
6803: --
6804: CURSOR c_ShipToID_line_ext IS --Added cursor as part of Bugfix 8672453

Line 7542: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

7538: ===========================================================================*/
7539:
7540: PROCEDURE CheckCUMKeyPO(
7541: x_group_rec IN RLM_VALIDATEDEMAND_SV.t_group_rec,
7542: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7543: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
7544: IS
7545: --
7546: v_Progress VARCHAR2(3) := '010';

Line 7763: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

7759:
7760: ===========================================================================*/
7761: PROCEDURE ValidPlanningProdSeqNum(
7762: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
7763: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7764: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
7765: IS
7766: v_Progress VARCHAR(3) := '010';
7767: e_ProdSeqMissing EXCEPTION;

Line 7859: PROCEDURE ValidLineScheduleType(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

7855:
7856: PROCEDURE NAME: ValidLineScheduleType
7857:
7858: ===========================================================================*/
7859: PROCEDURE ValidLineScheduleType(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7860: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
7861: IS
7862: v_Progress VARCHAR(3) := '010';
7863: e_SchedTypeInv EXCEPTION;

Line 7931: PROCEDURE UpdateInterfaceLines(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE)

7927:
7928: PROCEDURE NAME: UpdateInterfaceLines
7929:
7930: ===========================================================================*/
7931: PROCEDURE UpdateInterfaceLines(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE)
7932: IS
7933: --
7934: v_Progress VARCHAR(3) := '010';
7935: IsGroupError BOOLEAN := FALSE;

Line 8860: UPDATE rlm_interface_headers SET

8856: END IF;
8857: --
8858: END IF;
8859:
8860: UPDATE rlm_interface_headers SET
8861: CUST_ADDRESS_1_EXT = g_header_rec.CUST_ADDRESS_1_EXT ,
8862: CUST_ADDRESS_2_EXT = g_header_rec. CUST_ADDRESS_2_EXT ,
8863: CUST_ADDRESS_3_EXT = g_header_rec.CUST_ADDRESS_3_EXT ,
8864: CUST_ADDRESS_4_EXT = g_header_rec.CUST_ADDRESS_4_EXT ,

Line 9017: x_header_rec IN rlm_interface_headers%ROWTYPE,

9013: PROCEDURE CallSetups
9014:
9015: ===========================================================================*/
9016: FUNCTION CallSetups( x_Group_rec IN OUT NOCOPY t_Group_rec,
9017: x_header_rec IN rlm_interface_headers%ROWTYPE,
9018: x_lines_rec IN rlm_interface_lines%ROWTYPE)
9019: RETURN BOOLEAN
9020: IS
9021:

Line 9172: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

9168:
9169: ==============================================================================*/
9170: PROCEDURE ValidForecastDesig(
9171: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
9172: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
9173: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
9174: x_ForecastDesignator IN OUT NOCOPY VARCHAR2)
9175: IS
9176: --

Line 9375: PROCEDURE GetTPContext(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

9371:
9372: FUNCTION NAME: GetTPContext
9373:
9374: ===========================================================================*/
9375: PROCEDURE GetTPContext(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
9376: x_lines_rec IN RLM_INTERFACE_LINES%ROWTYPE,
9377: x_customer_number OUT NOCOPY VARCHAR2,
9378: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
9379: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 9458: PROCEDURE GetHdrTPContext(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

9454:
9455: FUNCTION NAME: GetHdrTPContext
9456:
9457: ===========================================================================*/
9458: PROCEDURE GetHdrTPContext(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
9459: x_customer_number OUT NOCOPY VARCHAR2,
9460: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
9461: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
9462: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 9534: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,

9530: /*=============================================================================
9531: PROCEDURE NAME: SetTPAttCategory
9532: ==============================================================================*/
9533: PROCEDURE SetTPAttCategory (
9534: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
9535: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
9536: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec) IS
9537: BEGIN
9538: --

Line 9563: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE) IS

9559: /*=============================================================================
9560: PROCEDURE NAME: SetHdrTPAttCategory
9561: ==============================================================================*/
9562: PROCEDURE SetHdrTPAttCategory (
9563: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE) IS
9564: BEGIN
9565: --
9566: IF (l_debug <> -1) THEN
9567: rlm_core_sv.dpush(C_SDEBUG,'SetHdrTPAttCategory');

Line 9589: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,

9585: /*=============================================================================
9586: PROCEDURE NAME: SetLineTPAttCategory
9587: ==============================================================================*/
9588: PROCEDURE SetLineTPAttCategory (
9589: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
9590: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
9591: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec) IS
9592: BEGIN
9593: --

Line 9845: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE)

9841:
9842: ========================================================================================*/
9843: PROCEDURE DeriveBlanketPO(x_cust_po_num IN RLM_INTERFACE_LINES.cust_po_number%TYPE,
9844: x_Group_rec IN t_Group_rec,
9845: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE)
9846: IS
9847: --
9848: v_blanket_po VARCHAR2(240);
9849: v_blanket_num NUMBER;

Line 9935: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE)

9931: FUNCTION ValidateBlanket
9932:
9933: ===========================================================================*/
9934: FUNCTION ValidateBlanket(x_Group_rec IN t_Group_rec,
9935: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE)
9936: RETURN BOOLEAN
9937: IS
9938: --
9939: l_reqdate DATE;