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

Line 6307: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,

6303: PROCEDURE NAME: DeriveBillToID
6304:
6305: ===========================================================================*/
6306: PROCEDURE DeriveBillToID(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
6307: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
6308: x_cum_org_level_code IN rlm_cust_shipto_terms.cum_org_level_code%TYPE)
6309: IS
6310: --
6311: v_progress VARCHAR2(3) := '010';

Line 6769: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

6765: PROCEDURE NAME: DeriveShipToID
6766:
6767: ===========================================================================*/
6768: PROCEDURE DeriveShipToID(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
6769: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
6770: IS
6771: --
6772: v_progress VARCHAR2(3) := '010';
6773: v_addStatus VARCHAR2(1);

Line 7213: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

7209: ====================================================================*/
7210: PROCEDURE validateWithCumRec(
7211: x_cum_key_record IN rlm_cum_sv.cum_key_attrib_rec_type,
7212: x_group_rec IN t_group_rec,
7213: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
7214: IS
7215:
7216: e_CumRecYearMissing EXCEPTION;
7217: e_CumKeyPOMissing EXCEPTION;

Line 7339: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

7335:
7336: PROCEDURE validateWithoutCumRec(
7337: x_customer_id IN NUMBER,
7338: x_group_rec IN t_group_rec,
7339: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
7340:
7341: IS
7342:
7343: v_cum_record RLM_CUM_SV.cum_rec_type;

Line 7469: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

7465:
7466: PROCEDURE CheckCUMKeyPO(
7467: x_group_rec IN RLM_VALIDATEDEMAND_SV.t_group_rec,
7468: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7469: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
7470: IS
7471: --
7472: v_Progress VARCHAR2(3) := '010';
7473: x_Success NUMBER := 0;

Line 7489: FROM rlm_interface_lines

7485: nvl(bill_to_address_id, x_lines_rec.bill_to_address_id),
7486: cust_po_number ,
7487: start_date_time,
7488: industry_attribute1 -- cust_record_year
7489: FROM rlm_interface_lines
7490: WHERE header_id = x_header_rec.header_id
7491: AND schedule_item_num = x_group_rec.schedule_item_num
7492: AND item_detail_type = '4'
7493: AND item_detail_subtype = 'CUM';

Line 7690: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

7686: ===========================================================================*/
7687: PROCEDURE ValidPlanningProdSeqNum(
7688: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
7689: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7690: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
7691: IS
7692: v_Progress VARCHAR(3) := '010';
7693: e_ProdSeqMissing EXCEPTION;
7694: e_MatchProdSeq EXCEPTION;

Line 7786: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)

7782: PROCEDURE NAME: ValidLineScheduleType
7783:
7784: ===========================================================================*/
7785: PROCEDURE ValidLineScheduleType(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
7786: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE)
7787: IS
7788: v_Progress VARCHAR(3) := '010';
7789: e_SchedTypeInv EXCEPTION;
7790:

Line 8426: UPDATE rlm_interface_lines

8422:
8423: /* oracle 9i compatible bulk update
8424: FORALL i in 1..g_lines_tab.COUNT
8425:
8426: UPDATE rlm_interface_lines
8427: SET ROW = g_lines_tab(i)
8428: WHERE header_id = header_id_tab(i)
8429: AND line_id = line_id_tab(i);
8430:

Line 8435: UPDATE rlm_interface_lines

8431: */
8432:
8433: --bulk update
8434: FORALL i in 1..g_lines_tab.COUNT
8435: UPDATE rlm_interface_lines
8436: SET
8437: AGREEMENT_ID = AGREEMENT_ID_TAB(i),
8438: ATO_DATA_TYPE = ATO_DATA_TYPE_TAB(i),
8439: BILL_TO_ADDRESS_1_EXT = BILL_TO_ADDRESS_1_EXT_TAB(i),

Line 8944: x_lines_rec IN rlm_interface_lines%ROWTYPE)

8940:
8941: ===========================================================================*/
8942: FUNCTION CallSetups( x_Group_rec IN OUT NOCOPY t_Group_rec,
8943: x_header_rec IN rlm_interface_headers%ROWTYPE,
8944: x_lines_rec IN rlm_interface_lines%ROWTYPE)
8945: RETURN BOOLEAN
8946: IS
8947:
8948: v_SetupTerms_rec rlm_setup_terms_sv.setup_terms_rec_typ;

Line 9097: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,

9093: ==============================================================================*/
9094: PROCEDURE ValidForecastDesig(
9095: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
9096: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
9097: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
9098: x_ForecastDesignator IN OUT NOCOPY VARCHAR2)
9099: IS
9100: --
9101: v_progress VARCHAR2(3) := '010';

Line 9147: FROM rlm_interface_lines

9143: -- type 6 since the forecast designator needs to be validated even in that instance
9144: --
9145: SELECT COUNT(*)
9146: INTO v_mrp_cnt
9147: FROM rlm_interface_lines
9148: WHERE item_detail_type = '6'
9149: AND header_id = x_header_rec.header_id
9150: AND line_id = x_lines_rec.line_id;
9151: --

Line 9300: x_lines_rec IN RLM_INTERFACE_LINES%ROWTYPE,

9296: FUNCTION NAME: GetTPContext
9297:
9298: ===========================================================================*/
9299: PROCEDURE GetTPContext(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
9300: x_lines_rec IN RLM_INTERFACE_LINES%ROWTYPE,
9301: x_customer_number OUT NOCOPY VARCHAR2,
9302: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
9303: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
9304: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 9459: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,

9455: PROCEDURE NAME: SetTPAttCategory
9456: ==============================================================================*/
9457: PROCEDURE SetTPAttCategory (
9458: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
9459: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
9460: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec) IS
9461: BEGIN
9462: --
9463: IF (l_debug <> -1) THEN

Line 9514: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,

9510: PROCEDURE NAME: SetLineTPAttCategory
9511: ==============================================================================*/
9512: PROCEDURE SetLineTPAttCategory (
9513: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
9514: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
9515: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec) IS
9516: BEGIN
9517: --
9518: IF (l_debug <> -1) THEN

Line 9671: x_line IN RLM_INTERFACE_LINES%ROWTYPE)

9667: PROCEDURE NAME: ValidateDateTypeATP
9668:
9669: ===========================================================================*/
9670: PROCEDURE ValidateDateTypeATP(
9671: x_line IN RLM_INTERFACE_LINES%ROWTYPE)
9672: IS
9673: --global_atp
9674: v_order_date_type_code VARCHAR2(30);
9675: v_order_number NUMBER;

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

9763:
9764: PROCEDURE DeriveBlanketPO
9765:
9766: ========================================================================================*/
9767: PROCEDURE DeriveBlanketPO(x_cust_po_num IN RLM_INTERFACE_LINES.cust_po_number%TYPE,
9768: x_Group_rec IN t_Group_rec,
9769: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE)
9770: IS
9771: --

Line 9890: FROM rlm_interface_lines

9886: END IF;
9887: --
9888: SELECT MIN(start_date_time), MAX(start_date_time)
9889: INTO l_reqdate, h_reqdate
9890: FROM rlm_interface_lines
9891: WHERE header_id = x_Sched_rec.header_id AND
9892: schedule_item_num = x_Group_rec.schedule_item_num AND
9893: item_detail_type IN (k_FIRM, k_FORECAST, k_PAST_DUE_FIRM);
9894: --

Line 9908: FROM rlm_interface_lines

9904: END IF;
9905: --
9906: SELECT MIN(start_date_time), MAX(start_date_time)
9907: INTO l_reqdate, h_reqdate
9908: FROM rlm_interface_lines
9909: WHERE header_id = x_Sched_rec.header_id AND
9910: cust_ship_from_org_ext = x_Group_rec.cust_ship_from_org_ext AND
9911: cust_ship_to_ext = x_Group_rec.cust_ship_to_ext AND
9912: customer_item_ext = x_Group_rec.customer_item_ext AND

Line 9926: FROM rlm_interface_lines

9922: END IF;
9923: --
9924: SELECT MIN(start_date_time), MAX(start_date_time)
9925: INTO l_reqdate, h_reqdate
9926: FROM rlm_interface_lines
9927: WHERE header_id = x_Sched_rec.header_id AND
9928: ship_from_org_id = x_Group_rec.ship_from_org_id AND
9929: ship_to_address_id = x_Group_rec.ship_to_address_id AND
9930: customer_item_id = x_Group_rec.customer_item_id AND