39: PROCEDURE NAME: CompareReplaceSched
40:
41: DESCRIPTION: This is the top level procedure for sweeper program
42:
43: PARAMETERS: x_sched_rec IN rlm_interface_headers%ROWTYPE
44: x_warn_dropped_items IN VARCHAR2
45: x_return_status OUT NOCOPY BOOLEAN
46:
47: ============================================================================*/
46:
47: ============================================================================*/
48: PROCEDURE CompareReplaceSched
49: (
50: x_sched_rec IN rlm_interface_headers%ROWTYPE,
51: x_warn_dropped_items IN VARCHAR2,
52: x_return_status OUT NOCOPY BOOLEAN
53: );
54:
57:
58: DESCRIPTION: This function returns FALSE if the current schedule
59: does not meet the criteria for running sweeper program.
60:
61: PARAMETERS: x_sched_rec IN rlm_interface_headers%ROWTYPE
62: x_warn_dropped_items IN VARCHAR2
63:
64: ============================================================================*/
65:
64: ============================================================================*/
65:
66: FUNCTION IsWarningNeeded
67: (
68: x_sched_rec IN rlm_interface_headers%ROWTYPE,
69: x_warn_dropped_items IN VARCHAR2
70: ) RETURN BOOLEAN;
71:
72: /*=============================================================================
76: before the current schedule based on tp translator code,
77: tp location code, schedule type, test flag, schedule
78: source.
79:
80: PARAMETERS: x_sched_rec IN rlm_interface_headers%ROWTYPE
81: x_prev_header_id OUT NOCOPY NUMBER
82: x_return_status OUT NOCOPY BOOLEAN
83:
84: ============================================================================*/
83:
84: ============================================================================*/
85: PROCEDURE FindEligibleSched
86: (
87: x_sched_rec IN rlm_interface_headers%ROWTYPE,
88: x_prev_header_id OUT NOCOPY NUMBER,
89: x_return_status OUT NOCOPY BOOLEAN
90: );
91: