DBA Data[Home] [Help]

APPS.RLM_VALIDATEDEMAND_SV dependencies on RLM_INTERFACE_HEADERS

Line 345: g_header_rec RLM_INTERFACE_HEADERS%ROWTYPE;

341: C_DEBUG NUMBER :=rlm_core_sv.C_LEVEL6;
342: k_VNULL CONSTANT VARCHAR2(30) := 'THIS_IS_NULL_VALUE';
343: k_NULL CONSTANT NUMBER := -10000;
344:
345: g_header_rec RLM_INTERFACE_HEADERS%ROWTYPE;
346: g_schedule_PS NUMBER;
347: g_line_PS NUMBER;
348: k_PLANNING CONSTANT VARCHAR2(30) := 'PLANNING_RELEASE';
349: k_SHIPPING CONSTANT VARCHAR2(30) := 'SHIPPING';

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

419:
420: CHANGE HISTORY: mnandell 07/01 created
421: ===========================================================================*/
422:
423: PROCEDURE GroupValidateDemand(x_Header_Id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE,
424: x_Procedure_Status OUT NOCOPY NUMBER);
425:
426: /*===========================================================================
427: PROCEDURE NAME: InitializeGroup

Line 517: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

513: CHANGE HISTORY: mnandell 07/01 created
514: ===========================================================================*/
515: PROCEDURE CheckCUMKeyPO(
516: x_group_rec IN RLM_VALIDATEDEMAND_SV.t_group_rec,
517: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
518: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
519: --
520:
521: /*===========================================================================

Line 542: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

538: CHANGE HISTORY: mnandell 07/01 created
539: ===========================================================================*/
540: PROCEDURE ValidPlanningProdSeqNum(
541: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
542: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
543: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
544: --
545:
546: /*===========================================================================

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

560: CLOSED ISSUES:
561:
562: CHANGE HISTORY: mnandell 07/01 created
563: ===========================================================================*/
564: PROCEDURE ValidLineScheduleType(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
565: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
566: --
567:
568: /*===========================================================================

Line 589: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

585: CHANGE HISTORY: mnandell 07/01 created
586: ===========================================================================*/
587: PROCEDURE ValidateLineDetails(
588: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
589: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
590: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
591: x_line_source IN VARCHAR2);
592: --
593: /*===========================================================================

Line 613: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

609: CHANGE HISTORY: mnandell 07/01 created
610: ===========================================================================*/
611: PROCEDURE ValidOrderHeaderId(
612: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
613: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
614: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
615: --
616:
617: /*===========================================================================

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

631: CLOSED ISSUES:
632:
633: CHANGE HISTORY: mnandell 07/01 created
634: ===========================================================================*/
635: PROCEDURE ValidateUOM(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
636: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
637: --
638:
639: /*===========================================================================

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

653: CLOSED ISSUES:
654:
655: CHANGE HISTORY: mnandell 07/01 created
656: ===========================================================================*/
657: PROCEDURE ValidDateRange(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
658: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
659: --
660:
661: /*===========================================================================

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

675: CLOSED ISSUES:
676:
677: CHANGE HISTORY: mnandell 07/01 created
678: ===========================================================================*/
679: PROCEDURE ValidDateTypeCode(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
680: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
681: --
682:
683: /*===========================================================================

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

697: CLOSED ISSUES:
698:
699: CHANGE HISTORY: mnandell 07/01 created
700: ===========================================================================*/
701: PROCEDURE ValidItemDetailQty(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
702: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
703: --
704:
705: /*===========================================================================

Line 725: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

721: CHANGE HISTORY: mnandell 07/01 created
722: ===========================================================================*/
723: PROCEDURE ValidQtyTypeCode(
724: x_setup_terms_rec IN rlm_setup_terms_sv.setup_terms_rec_typ,
725: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
726: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
727: --
728:
729: /*===========================================================================

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

743: CLOSED ISSUES:
744:
745: CHANGE HISTORY: mnandell 07/01 created
746: ===========================================================================*/
747: PROCEDURE ValidItemDetailSubtype(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
748: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
749: --
750:
751: /*===========================================================================

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

765: CLOSED ISSUES:
766:
767: CHANGE HISTORY: mnandell 07/01 created
768: ===========================================================================*/
769: PROCEDURE ValidItemDetailType(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
770: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
771: --
772:
773: --PROCEDURE valid_sfst_terms(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

Line 773: --PROCEDURE valid_sfst_terms(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

769: PROCEDURE ValidItemDetailType(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
770: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
771: --
772:
773: --PROCEDURE valid_sfst_terms(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
774: -- x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE) ;
775:
776: /*===========================================================================
777: PROCEDURE NAME: BuildHeaderRec

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

790: CLOSED ISSUES:
791:
792: CHANGE HISTORY: mnandell 07/01 created
793: ===========================================================================*/
794: FUNCTION BuildHeaderRec(x_header_id IN rlm_interface_headers.header_id%TYPE)
795: RETURN BOOLEAN ;
796:
797: /*===========================================================================
798: PROCEDURE NAME: ApplyHeaderDefaults

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

811: CLOSED ISSUES:
812:
813: CHANGE HISTORY: mnandell 07/01 created
814: ===========================================================================*/
815: PROCEDURE ApplyHeaderDefaults(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
816:
817: /*===========================================================================
818: PROCEDURE NAME: GetDateFromTable
819:

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

852: CLOSED ISSUES:
853:
854: CHANGE HISTORY: mnandell 07/01 created
855: ===========================================================================*/
856: PROCEDURE ValidScheduleHeader(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
857: --
858:
859: /*===========================================================================
860: PROCEDURE NAME: ValidNumberLines

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

873: CLOSED ISSUES:
874:
875: CHANGE HISTORY: mnandell 07/01 created
876: ===========================================================================*/
877: PROCEDURE ValidNumberLines(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
878: --
879:
880: /*===========================================================================
881: PROCEDURE NAME: ValidScheduleSource

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

895:
896: CHANGE HISTORY: mnandell 07/01 created
897: ===========================================================================*/
898:
899: PROCEDURE ValidScheduleSource(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
900: --
901:
902: /*===========================================================================
903: PROCEDURE NAME: ValidHorizonDates

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

916: CLOSED ISSUES:
917:
918: CHANGE HISTORY: mnandell 07/01 created
919: ===========================================================================*/
920: PROCEDURE ValidHorizonDates(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
921: --
922:
923: /*===========================================================================
924: PROCEDURE NAME: ValidScheduleReferenceNum

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

937: CLOSED ISSUES:
938:
939: CHANGE HISTORY: mnandell 07/01 created
940: ===========================================================================*/
941: PROCEDURE ValidScheduleReferenceNum(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
942: --
943:
944: /*===========================================================================
945: PROCEDURE NAME: ValidScheduleType

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

958: CLOSED ISSUES:
959:
960: CHANGE HISTORY: mnandell 07/01 created
961: ===========================================================================*/
962: PROCEDURE ValidScheduleType(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
963: --
964:
965: /*===========================================================================
966: PROCEDURE NAME: ValidLookup

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

1004: CLOSED ISSUES:
1005:
1006: CHANGE HISTORY: mnandell 07/01 created
1007: ===========================================================================*/
1008: PROCEDURE ValidSchedulePurpose(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
1009: --
1010:
1011: /*===========================================================================
1012: PROCEDURE NAME: CallSetups

Line 1031: x_header_rec IN rlm_interface_headers%ROWTYPE,

1027: CHANGE HISTORY: mnandell 07/01 created
1028: ===========================================================================*/
1029: FUNCTION CallSetups(
1030: x_Group_rec IN OUT NOCOPY t_Group_rec,
1031: x_header_rec IN rlm_interface_headers%ROWTYPE,
1032: x_lines_rec IN rlm_interface_lines%ROWTYPE)
1033: RETURN BOOLEAN;
1034:
1035: /*===========================================================================

Line 1055: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,

1051:
1052: CHANGE HISTORY: mnandell 07/01 created
1053: ===========================================================================*/
1054: PROCEDURE DeriveIDs(
1055: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1056: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1057:
1058: /*===========================================================================
1059: PROCEDURE NAME: DeriveOrgDependentIDs

Line 1078: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1074: CHANGE HISTORY: mnandell 07/01 created
1075: ===========================================================================*/
1076: PROCEDURE DeriveOrgDependentIDs(
1077: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
1078: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1079: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1080:
1081: /*===========================================================================
1082: PROCEDURE NAME: DeriveInventoryItemId

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

1095: CLOSED ISSUES:
1096:
1097: CHANGE HISTORY: mnandell 07/01 created
1098: ===========================================================================*/
1099: PROCEDURE DeriveInventoryItemId(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1100: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1101:
1102: --
1103:

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

1118: CLOSED ISSUES:
1119:
1120: CHANGE HISTORY: mnandell 07/01 created
1121: ===========================================================================*/
1122: PROCEDURE ValidateCustomerItem(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1123: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1124: --
1125:
1126: /*===========================================================================

Line 1146: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1142: CHANGE HISTORY: mnandell 07/01 created
1143: ===========================================================================*/
1144: PROCEDURE DerivePurchaseOrder(
1145: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
1146: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1147: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1148:
1149: /*===========================================================================
1150: PROCEDURE NAME: DeriveCustomerID

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

1163: CLOSED ISSUES:
1164:
1165: CHANGE HISTORY: mnandell 07/01 created
1166: ===========================================================================*/
1167: PROCEDURE DeriveCustomerID(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1168: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1169:
1170: /*===========================================================================
1171: PROCEDURE NAME: DeriveShipFromOrg

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

1184: CLOSED ISSUES:
1185:
1186: CHANGE HISTORY: mnandell 07/01 created
1187: ===========================================================================*/
1188: PROCEDURE DeriveShipFromOrg(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1189: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1190:
1191: /*===========================================================================
1192: PROCEDURE NAME: DeriveIntrmdShipToID

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

1205: CLOSED ISSUES:
1206:
1207: CHANGE HISTORY: mnandell 07/01 created
1208: ===========================================================================*/
1209: PROCEDURE DeriveIntrmdShipToID(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1210: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1211:
1212: /*===========================================================================
1213: PROCEDURE NAME: DeriveBillToID

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

1226: CLOSED ISSUES:
1227:
1228: CHANGE HISTORY: mnandell 07/01 created
1229: ===========================================================================*/
1230: PROCEDURE DeriveBillToID(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1231: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
1232: x_cum_org_level_code IN rlm_cust_shipto_terms.cum_org_level_code%TYPE);
1233:
1234: /*===========================================================================

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

1248: CLOSED ISSUES:
1249:
1250: CHANGE HISTORY: mnandell 07/01 created
1251: ===========================================================================*/
1252: PROCEDURE DeriveShipToID(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1253: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1254:
1255: /*===========================================================================
1256: PROCEDURE NAME: UpdateInterfaceHeaders

Line 1291: PROCEDURE UpdateInterfaceLines(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE);

1287: CLOSED ISSUES:
1288:
1289: CHANGE HISTORY: mnandell 07/01 created
1290: ===========================================================================*/
1291: PROCEDURE UpdateInterfaceLines(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE);
1292: --
1293: /*===========================================================================
1294: PROCEDURE NAME: PostValidation
1295:

Line 1356: PROCEDURE GetTPContext(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,

1352: CLOSED ISSUES:
1353:
1354: CHANGE HISTORY: mnandell 10/10/99 created
1355: ===========================================================================*/
1356: PROCEDURE GetTPContext(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,
1357: x_lines_rec IN RLM_INTERFACE_LINES%ROWTYPE DEFAULT NULL,
1358: x_customer_number OUT NOCOPY VARCHAR2,
1359: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
1360: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 1391: PROCEDURE GetHdrTPContext(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,

1387: CLOSED ISSUES:
1388:
1389: CHANGE HISTORY: jautomo 10/25/00 created
1390: ===========================================================================*/
1391: PROCEDURE GetHdrTPContext(x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE DEFAULT NULL,
1392: x_customer_number OUT NOCOPY VARCHAR2,
1393: x_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,
1394: x_bill_to_ece_locn_code OUT NOCOPY VARCHAR2,
1395: x_inter_ship_to_ece_locn_code OUT NOCOPY VARCHAR2,

Line 1407: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1403: DESCRIPTION: This procedure will validate the critical key attributes
1404: to ensure that they are not null values.
1405:
1406: PARAMETERS: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ
1407: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1408: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
1409:
1410:
1411: DESIGN REFERENCES: RLADPHLD.rtf

Line 1426: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1422: CHANGE HISTORY: created mnnaraya 11/22/99
1423: ===========================================================================*/
1424: PROCEDURE ValidateCriticalKeys(
1425: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
1426: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1427: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE);
1428:
1429: /*=============================================================================
1430: PROCEDURE NAME: ValidForecastDesig

Line 1435: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1431:
1432: DESCRIPTION: This procedure checks if forecast designator exits
1433:
1434: PARAMETERS: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ
1435: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1436: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
1437: x_ForecastDesignator IN OUT NOCOPY VARCHAR2
1438:
1439:

Line 1449: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,

1445:
1446: ==============================================================================*/
1447: PROCEDURE ValidForecastDesig(
1448: x_setup_terms_rec IN RLM_SETUP_TERMS_SV.setup_terms_rec_typ,
1449: x_header_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
1450: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
1451: x_ForecastDesignator IN OUT NOCOPY VARCHAR2);
1452:
1453: /*=============================================================================

Line 1460: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,

1456: DESCRIPTION: This procedure sets TP Attribute Category with TP Group
1457: Code
1458: ==============================================================================*/
1459: PROCEDURE SetTPAttCategory (
1460: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1461: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
1462: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec);
1463: --
1464:

Line 1471: PARAMETERS: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE

1467:
1468: DESCRIPTION: This procedure sets TP Attribute Category with TP Group
1469: Code
1470:
1471: PARAMETERS: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
1472:
1473: ==============================================================================*/
1474: PROCEDURE SetHdrTPAttCategory (
1475: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);

Line 1475: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);

1471: PARAMETERS: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
1472:
1473: ==============================================================================*/
1474: PROCEDURE SetHdrTPAttCategory (
1475: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE);
1476:
1477: --
1478:
1479: /*=============================================================================

Line 1485: PARAMETERS: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE

1481:
1482: DESCRIPTION: This procedure sets TP Attribute Category with TP Group
1483: Code
1484:
1485: PARAMETERS: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE
1486: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE
1487: x_group_rec IN OUT NOCOPY t_Group_rec
1488:
1489: ==============================================================================*/

Line 1491: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,

1487: x_group_rec IN OUT NOCOPY t_Group_rec
1488:
1489: ==============================================================================*/
1490: PROCEDURE SetLineTPAttCategory (
1491: x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1492: x_lines_rec IN OUT NOCOPY RLM_INTERFACE_LINES%ROWTYPE,
1493: x_group_rec IN OUT NOCOPY RLM_VALIDATEDEMAND_SV.t_Group_rec);
1494: --
1495:

Line 1544: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE

1540: rules.
1541:
1542: PARAMETERS: x_cust_po_num IN RLM_INTERFACE_LINES.cust_po_number%TYPE
1543: x_Group_rec IN t_group_rec
1544: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE
1545:
1546: CHANGE HISTORY: created rlanka 10/10/02
1547: ===========================================================================*/
1548: PROCEDURE DeriveBlanketPO(x_cust_po_num IN RLM_INTERFACE_LINES.cust_po_number%TYPE,

Line 1550: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE);

1546: CHANGE HISTORY: created rlanka 10/10/02
1547: ===========================================================================*/
1548: PROCEDURE DeriveBlanketPO(x_cust_po_num IN RLM_INTERFACE_LINES.cust_po_number%TYPE,
1549: x_Group_rec IN t_Group_rec,
1550: x_header_id IN RLM_INTERFACE_HEADERS.HEADER_ID%TYPE);
1551:
1552:
1553: /*===========================================================================
1554: FUNCTION NAME: ValidateBlanket

Line 1561: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE

1557: times on the schedule do not fall between the effective
1558: start and end dates of the blanket header
1559:
1560: PARAMETERS: x_Group_rec IN t_group_rec
1561: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE
1562:
1563: CHANGE HISTORY: created rlanka 10/10/02
1564: modified rlanka 03/31/03
1565: - Removed x_line_rec as a parameter.

Line 1568: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE)

1564: modified rlanka 03/31/03
1565: - Removed x_line_rec as a parameter.
1566: ===========================================================================*/
1567: FUNCTION ValidateBlanket(x_Group_rec IN t_Group_rec,
1568: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE)
1569: RETURN BOOLEAN;
1570:
1571:
1572: /*===========================================================================

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

1582: CHANGE HISTORY: created jautomo 03/07/02
1583: ===========================================================================*/
1584: FUNCTION GetOrderNumber(x_order_header_id IN NUMBER) RETURN NUMBER;
1585:
1586: PROCEDURE CheckHeaderECETpLocCode(x_header_rec IN OUT NOCOPY RLM_INTERFACE_HEADERS%ROWTYPE,
1587: x_ReturnStatus OUT NOCOPY NUMBER);
1588:
1589: END RLM_VALIDATEDEMAND_SV;