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_LINES

Line 46: rlm_interface_lines_all ril

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
50: GROUP BY schedule_item_num;

Line 68: rlm_interface_lines_all ril

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
72: GROUP BY cust_ship_from_org_ext, cust_ship_to_ext,

Line 87: rlm_interface_lines_all ril

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
91: GROUP BY customer_item_id,

Line 888: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,

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

Line 1010: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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;
1014: e_OrderIDMismatch EXCEPTION;

Line 1327: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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);
1331: v_Primary_UOM_Class VARCHAR(10);

Line 1502: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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';
1506: e_DateRangeInv EXCEPTION;

Line 1628: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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';
1632: e_DateTypeInv EXCEPTION;

Line 1697: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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';
1701: e_QtyInvalid EXCEPTION;

Line 1780: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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';
1784: e_NoCum EXCEPTION;

Line 1917: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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';
1921: e_DetailSubTypeInv EXCEPTION;

Line 2009: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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';
2013: e_ItemDetailTypeInvalid EXCEPTION;

Line 2081: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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';
2085: x_critical_key_rec rlm_core_sv.t_match_rec;

Line 2573: v_lines_rec RLM_INTERFACE_LINES%ROWTYPE;

2569: ===========================================================================*/
2570: PROCEDURE PopulateLinesTab(v_Group_rec IN t_Group_rec)
2571: IS
2572: --
2573: v_lines_rec RLM_INTERFACE_LINES%ROWTYPE;
2574: v_Progress VARCHAR2(30) := '010';
2575: v_temp VARCHAR2(30);
2576: v_Count NUMBER := 1;
2577: TYPE c_lines_typ IS REF CURSOR;

Line 2601: FROM RLM_INTERFACE_LINES_ALL --bug 4907839

2597: IF v_Group_rec.group_type = 'N' THEN
2598: --
2599: OPEN c_lines FOR
2600: SELECT *
2601: FROM RLM_INTERFACE_LINES_ALL --bug 4907839
2602: WHERE schedule_item_num = v_Group_rec.schedule_item_num
2603: AND header_id = g_header_rec.header_id
2604: AND process_status = rlm_core_sv.k_PS_AVAILABLE
2605: --ORDER BY item_detail_type desc

Line 2616: FROM RLM_INTERFACE_LINES_ALL --Bug 4907839

2612: IF (v_Group_rec.cust_ship_from_org_ext IS NOT NULL AND v_Group_rec.cust_ship_to_ext IS NOT NULL) THEN
2613: --
2614: OPEN c_lines FOR
2615: SELECT *
2616: FROM RLM_INTERFACE_LINES_ALL --Bug 4907839
2617: WHERE header_id = g_header_rec.header_id
2618: AND cust_ship_from_org_ext =
2619: v_Group_rec.cust_ship_from_org_ext
2620: AND cust_ship_to_ext =

Line 2631: FROM RLM_INTERFACE_LINES_ALL --bug 4907839

2627: ELSE
2628: --
2629: OPEN c_lines FOR
2630: SELECT *
2631: FROM RLM_INTERFACE_LINES_ALL --bug 4907839
2632: WHERE header_id = g_header_rec.header_id
2633: AND nvl(cust_ship_from_org_ext,k_VNULL) =
2634: nvl(v_Group_rec.cust_ship_from_org_ext,k_VNULL)
2635: AND nvl(cust_ship_to_ext,k_VNULL) =

Line 2648: FROM RLM_INTERFACE_LINES

2644: ELSE
2645: --
2646: OPEN c_lines FOR
2647: SELECT *
2648: FROM RLM_INTERFACE_LINES
2649: WHERE header_id = g_header_rec.header_id
2650: AND customer_item_id = v_Group_rec.customer_item_id
2651: AND ship_from_org_id = v_Group_rec.ship_from_org_id
2652: AND ship_to_address_id = v_Group_rec.ship_to_address_id

Line 2863: FROM rlm_interface_lines

2859: IF p_date_criteria = 'START' THEN
2860: --
2861: SELECT MIN(start_date_time)
2862: INTO v_start_date
2863: FROM rlm_interface_lines
2864: WHERE header_id = g_header_rec.header_id;
2865: --
2866: IF (l_debug <> -1) THEN
2867: rlm_core_sv.dlog(C_DEBUG,'v_Start_Date',v_Start_Date);

Line 2877: FROM rlm_interface_lines

2873: ELSIF p_date_criteria = 'END' THEN
2874: --{
2875: SELECT MAX(end_date_time)
2876: INTO v_end_date_f
2877: FROM rlm_interface_lines
2878: WHERE header_id = g_header_rec.header_id
2879: AND item_detail_type IN (0,1,2,6) --Bug 5478817
2880: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_FLEXIBLE;
2881: --

Line 2888: FROM rlm_interface_lines

2884: END IF;
2885: --
2886: SELECT MAX(start_date_time)
2887: INTO v_End_Date_d
2888: FROM rlm_interface_lines
2889: WHERE header_id = g_header_rec.header_id
2890: AND item_detail_type IN (0,1,2,6) --Bug 5478817
2891: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_DAY;
2892: --

Line 2899: FROM rlm_interface_lines

2895: END IF;
2896: --
2897: SELECT MAX(start_date_time)
2898: INTO v_End_Date_w
2899: FROM rlm_interface_lines
2900: WHERE header_id = g_header_rec.header_id
2901: AND item_detail_type IN (0,1,2,6) --Bug 5478817
2902: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_WEEK;
2903: --

Line 2910: FROM rlm_interface_lines

2906: END IF;
2907: --
2908: SELECT MAX(start_date_time)
2909: INTO v_End_Date_m
2910: FROM rlm_interface_lines
2911: WHERE header_id = g_header_rec.header_id
2912: AND item_detail_type IN (0,1,2,6) --Bug 5478817
2913: AND item_detail_subtype = rlm_ship_delivery_pattern_sv.g_MONTH;
2914: --

Line 3060: FROM rlm_interface_lines

3056: END IF;
3057: --
3058: SELECT count(*)
3059: INTO v_Count
3060: FROM rlm_interface_lines
3061: where header_id = x_header_rec.header_id;
3062: --
3063: IF (l_debug <> -1) THEN
3064: rlm_core_sv.dlog(C_DEBUG,'ValidNumberLines ', v_Count);

Line 4245: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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

Line 4287: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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';
4291: v_bill_to_customer_id NUMBER default NULL;

Line 4338: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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';
4342: v_CustomerId NUMBER;

Line 4856: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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

Line 5003: x_lines_rec IN OUT NOCOPY rlm_interface_lines%ROWTYPE)

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

Line 5500: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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

Line 5822: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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

Line 6017: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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
6021: SELECT ACCT_SITE.CUST_ACCT_SITE_ID,

Line 6330: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,

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: --
6334: CURSOR c_BillToID_ext IS --Added cursor as part of Bugfix 8672453

Line 6801: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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
6805: SELECT hz.cust_acct_site_id, hz.status, cust_account_id,

Line 7287: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

7283: ====================================================================*/
7284: PROCEDURE validateWithCumRec(
7285: x_cum_key_record IN rlm_cum_sv.cum_key_attrib_rec_type,
7286: x_group_rec IN t_group_rec,
7287: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
7288: IS
7289:
7290: e_CumRecYearMissing EXCEPTION;
7291: e_CumKeyPOMissing EXCEPTION;

Line 7413: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

7409:
7410: PROCEDURE validateWithoutCumRec(
7411: x_customer_id IN NUMBER,
7412: x_group_rec IN t_group_rec,
7413: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
7414:
7415: IS
7416:
7417: v_cum_record RLM_CUM_SV.cum_rec_type;

Line 7543: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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';
7547: x_Success NUMBER := 0;

Line 7563: FROM rlm_interface_lines

7559: nvl(bill_to_address_id, x_lines_rec.bill_to_address_id),
7560: cust_po_number ,
7561: start_date_time,
7562: industry_attribute1 -- cust_record_year
7563: FROM rlm_interface_lines
7564: WHERE header_id = x_header_rec.header_id
7565: AND schedule_item_num = x_group_rec.schedule_item_num
7566: AND item_detail_type = '4'
7567: AND item_detail_subtype = 'CUM';

Line 7764: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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;
7768: e_MatchProdSeq EXCEPTION;

Line 7860: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

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

Line 8500: UPDATE rlm_interface_lines

8496:
8497: /* oracle 9i compatible bulk update
8498: FORALL i in 1..g_lines_tab.COUNT
8499:
8500: UPDATE rlm_interface_lines
8501: SET ROW = g_lines_tab(i)
8502: WHERE header_id = header_id_tab(i)
8503: AND line_id = line_id_tab(i);
8504:

Line 8509: UPDATE rlm_interface_lines

8505: */
8506:
8507: --bulk update
8508: FORALL i in 1..g_lines_tab.COUNT
8509: UPDATE rlm_interface_lines
8510: SET
8511: AGREEMENT_ID = AGREEMENT_ID_TAB(i),
8512: ATO_DATA_TYPE = ATO_DATA_TYPE_TAB(i),
8513: BILL_TO_ADDRESS_1_EXT = BILL_TO_ADDRESS_1_EXT_TAB(i),

Line 9018: x_lines_rec IN rlm_interface_lines%ROWTYPE)

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:
9022: v_SetupTerms_rec rlm_setup_terms_sv.setup_terms_rec_typ;

Line 9173: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,

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

Line 9223: FROM rlm_interface_lines

9219: -- type 6 since the forecast designator needs to be validated even in that instance
9220: --
9221: SELECT COUNT(*)
9222: INTO v_mrp_cnt
9223: FROM rlm_interface_lines
9224: WHERE item_detail_type = '6'
9225: AND header_id = x_header_rec.header_id
9226: AND line_id = x_lines_rec.line_id;
9227: --

Line 9376: x_lines_rec IN RLM_INTERFACE_LINES%ROWTYPE,

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,
9380: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 9535: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,

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: --
9539: IF (l_debug <> -1) THEN

Line 9590: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,

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: --
9594: IF (l_debug <> -1) THEN

Line 9747: x_line IN RLM_INTERFACE_LINES%ROWTYPE)

9743: PROCEDURE NAME: ValidateDateTypeATP
9744:
9745: ===========================================================================*/
9746: PROCEDURE ValidateDateTypeATP(
9747: x_line IN RLM_INTERFACE_LINES%ROWTYPE)
9748: IS
9749: --global_atp
9750: v_order_date_type_code VARCHAR2(30);
9751: v_order_number NUMBER;

Line 9843: PROCEDURE DeriveBlanketPO(x_cust_po_num IN RLM_INTERFACE_LINES.cust_po_number%TYPE,

9839:
9840: PROCEDURE DeriveBlanketPO
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: --

Line 9966: FROM rlm_interface_lines

9962: END IF;
9963: --
9964: SELECT MIN(start_date_time), MAX(start_date_time)
9965: INTO l_reqdate, h_reqdate
9966: FROM rlm_interface_lines
9967: WHERE header_id = x_Sched_rec.header_id AND
9968: schedule_item_num = x_Group_rec.schedule_item_num AND
9969: item_detail_type IN (k_FIRM, k_FORECAST, k_PAST_DUE_FIRM);
9970: --

Line 9984: FROM rlm_interface_lines

9980: END IF;
9981: --
9982: SELECT MIN(start_date_time), MAX(start_date_time)
9983: INTO l_reqdate, h_reqdate
9984: FROM rlm_interface_lines
9985: WHERE header_id = x_Sched_rec.header_id AND
9986: cust_ship_from_org_ext = x_Group_rec.cust_ship_from_org_ext AND
9987: cust_ship_to_ext = x_Group_rec.cust_ship_to_ext AND
9988: customer_item_ext = x_Group_rec.customer_item_ext AND

Line 10002: FROM rlm_interface_lines

9998: END IF;
9999: --
10000: SELECT MIN(start_date_time), MAX(start_date_time)
10001: INTO l_reqdate, h_reqdate
10002: FROM rlm_interface_lines
10003: WHERE header_id = x_Sched_rec.header_id AND
10004: ship_from_org_id = x_Group_rec.ship_from_org_id AND
10005: ship_to_address_id = x_Group_rec.ship_to_address_id AND
10006: customer_item_id = x_Group_rec.customer_item_id AND