DBA Data[Home] [Help]

APPS.RLM_MANAGE_DEMAND_SV dependencies on RLM_INTERFACE_LINES

Line 31: TYPE t_MD_tab IS TABLE OF rlm_interface_lines%ROWTYPE INDEX BY BINARY_INTEGER;

27: operation_code NUMBER,
28: source_index NUMBER
29: );
30:
31: TYPE t_MD_tab IS TABLE OF rlm_interface_lines%ROWTYPE INDEX BY BINARY_INTEGER;
32:
33: TYPE t_Number_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
34:
35: TYPE t_Ship_rec IS RECORD (

Line 43: purchase_order_number rlm_interface_lines.cust_po_number%TYPE,

39: ship_from_org_id NUMBER,
40: intrmd_ship_to_address_id NUMBER,
41: ship_to_address_id NUMBER,
42: bill_to_address_id NUMBER,
43: purchase_order_number rlm_interface_lines.cust_po_number%TYPE,
44: primary_quantity NUMBER,
45: item_detail_quantity NUMBER, -- Added by JAUTOMO
46: start_date_time DATE,
47: cust_record_year rlm_interface_lines.industry_attribute1%TYPE,

Line 47: cust_record_year rlm_interface_lines.industry_attribute1%TYPE,

43: purchase_order_number rlm_interface_lines.cust_po_number%TYPE,
44: primary_quantity NUMBER,
45: item_detail_quantity NUMBER, -- Added by JAUTOMO
46: start_date_time DATE,
47: cust_record_year rlm_interface_lines.industry_attribute1%TYPE,
48: line_id NUMBER,
49: found NUMBER
50: );
51:

Line 375: PROCEDURE SetOperation(x_ManageDemand_rec IN OUT NOCOPY rlm_interface_lines%ROWTYPE,

371: CLOSED ISSUES:
372:
373: CHANGE HISTORY: jhaulund 8/6/98 created
374: ===========================================================================*/
375: PROCEDURE SetOperation(x_ManageDemand_rec IN OUT NOCOPY rlm_interface_lines%ROWTYPE,
376: x_Operation IN NUMBER);
377:
378: /*===========================================================================
379: PROCEDURE NAME ApplySourceRules:

Line 467: and inserts into the rlm_interface_lines.

463: PROCEDURE NAME: ProcessTable
464:
465: DESCRIPTION: Perform operations stored in x_ManageDemand_tab.
466: These operations consist of updates, deletes,
467: and inserts into the rlm_interface_lines.
468:
469: PARAMETERS: x_ManageDemand_tab IN t_MD_tab
470:
471: DESIGN REFERENCES: rlmdpmdd.rtf

Line 490: PARAMETERS: x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE

486: PROCEDURE NAME: DeleteReq
487:
488: DESCRIPTION: Deletes passed requirement.
489:
490: PARAMETERS: x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE
491:
492: DESIGN REFERENCES: rlmdpmdd.rtf
493:
494: ALGORITHM:

Line 504: PROCEDURE DeleteReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE);

500: CLOSED ISSUES:
501:
502: CHANGE HISTORY: jhaulund 8/6/98 created
503: ===========================================================================*/
504: PROCEDURE DeleteReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE);
505:
506: /*===========================================================================
507: PROCEDURE NAME: InsertReq
508:

Line 511: PARAMETERS: x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE

507: PROCEDURE NAME: InsertReq
508:
509: DESCRIPTION: Inserts passed requirement.
510:
511: PARAMETERS: x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE
512:
513: DESIGN REFERENCES: rlmdpmdd.rtf
514:
515: ALGORITHM:

Line 525: PROCEDURE InsertReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE);

521: CLOSED ISSUES:
522:
523: CHANGE HISTORY: jhaulund 8/6/98 created
524: ===========================================================================*/
525: PROCEDURE InsertReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE);
526:
527: /*===========================================================================
528: PROCEDURE NAME: UpdateReq
529:

Line 532: PARAMETERS: x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE

528: PROCEDURE NAME: UpdateReq
529:
530: DESCRIPTION: Updates passed requirement.
531:
532: PARAMETERS: x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE
533:
534: DESIGN REFERENCES: rlmdpmdd.rtf
535:
536: ALGORITHM:

Line 546: PROCEDURE UpdateReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE);

542: CLOSED ISSUES:
543:
544: CHANGE HISTORY: jhaulund 8/6/98 created
545: ===========================================================================*/
546: PROCEDURE UpdateReq(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE);
547:
548: /*===========================================================================
549: PROCEDURE NAME: UpdateSchedule
550:

Line 554: PARAMETERS: x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE

550:
551: DESCRIPTION: Update the schedule lines when they are
552: aggregated to a new line.
553:
554: PARAMETERS: x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE
555: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE
556:
557: DESIGN REFERENCES: rlmdpmdd.rtf
558:

Line 555: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE

551: DESCRIPTION: Update the schedule lines when they are
552: aggregated to a new line.
553:
554: PARAMETERS: x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE
555: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE
556:
557: DESIGN REFERENCES: rlmdpmdd.rtf
558:
559: ALGORITHM:

Line 569: PROCEDURE UpdateSchedule(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE,

565: CLOSED ISSUES:
566:
567: CHANGE HISTORY: jhaulund 8/6/98/28 created
568: ===========================================================================*/
569: PROCEDURE UpdateSchedule(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE,
570: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE);
571:
572: /*===========================================================================
573: PROCEDURE NAME: MatchDemand

Line 570: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE);

566:
567: CHANGE HISTORY: jhaulund 8/6/98/28 created
568: ===========================================================================*/
569: PROCEDURE UpdateSchedule(x_ManageDemand_rec IN rlm_interface_lines%ROWTYPE,
570: x_AggregateDemand_rec IN rlm_interface_lines%ROWTYPE);
571:
572: /*===========================================================================
573: PROCEDURE NAME: MatchDemand
574: