68:
69: -- Function Complete_Record
70:
71: FUNCTION Complete_Record
72: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
73: , p_old_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
74: , p_ForceCopy IN BOOLEAN := NULL
75: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
76:
69: -- Function Complete_Record
70:
71: FUNCTION Complete_Record
72: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
73: , p_old_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
74: , p_ForceCopy IN BOOLEAN := NULL
75: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
76:
77: -- Function Convert_Miss_To_Null
71: FUNCTION Complete_Record
72: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
73: , p_old_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
74: , p_ForceCopy IN BOOLEAN := NULL
75: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
76:
77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null
76:
77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null
80: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
81: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
82:
83: -- Procedure Update_Row
84:
77: -- Function Convert_Miss_To_Null
78:
79: FUNCTION Convert_Miss_To_Null
80: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
81: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
82:
83: -- Procedure Update_Row
84:
85: PROCEDURE Update_Row
82:
83: -- Procedure Update_Row
84:
85: PROCEDURE Update_Row
86: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
87: );
88:
89: -- Procedure Insert_Row
90:
88:
89: -- Procedure Insert_Row
90:
91: PROCEDURE Insert_Row
92: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
93: );
94:
95: -- Procedure Delete_Row
96:
101: -- Function Query_Row
102:
103: FUNCTION Query_Row
104: ( p_repetitive_schedule_id IN NUMBER
105: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
106:
107: FUNCTION Query_Row
108: ( p_wip_entity_id IN NUMBER
109: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
105: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
106:
107: FUNCTION Query_Row
108: ( p_wip_entity_id IN NUMBER
109: ) RETURN WIP_Work_Order_PUB.Repschedule_Rec_Type;
110:
111: -- Function Query_Rows
112:
113: --
116: ( p_repetitive_schedule_id IN NUMBER :=
117: NULL
118: , p_wip_entity_id IN NUMBER :=
119: NULL
120: ) RETURN WIP_Work_Order_PUB.Repschedule_Tbl_Type;
121:
122: -- Procedure lock_Row
123: --
124:
123: --
124:
125: PROCEDURE Lock_Row
126: ( x_return_status OUT NOCOPY VARCHAR2
127: , p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
128: , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
129: );
130:
131: FUNCTION Compare
124:
125: PROCEDURE Lock_Row
126: ( x_return_status OUT NOCOPY VARCHAR2
127: , p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
128: , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
129: );
130:
131: FUNCTION Compare
132: ( p_RepSchedule_rec1 IN WIP_Work_Order_PUB.Repschedule_Rec_Type
128: , x_RepSchedule_rec OUT NOCOPY WIP_Work_Order_PUB.Repschedule_Rec_Type
129: );
130:
131: FUNCTION Compare
132: ( p_RepSchedule_rec1 IN WIP_Work_Order_PUB.Repschedule_Rec_Type
133: , p_RepSchedule_rec2 IN WIP_Work_Order_PUB.Repschedule_Rec_Type
134: ) RETURN Boolean;
135:
136: PROCEDURE dprintf
129: );
130:
131: FUNCTION Compare
132: ( p_RepSchedule_rec1 IN WIP_Work_Order_PUB.Repschedule_Rec_Type
133: , p_RepSchedule_rec2 IN WIP_Work_Order_PUB.Repschedule_Rec_Type
134: ) RETURN Boolean;
135:
136: PROCEDURE dprintf
137: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
133: , p_RepSchedule_rec2 IN WIP_Work_Order_PUB.Repschedule_Rec_Type
134: ) RETURN Boolean;
135:
136: PROCEDURE dprintf
137: ( p_RepSchedule_rec IN WIP_Work_Order_PUB.Repschedule_Rec_Type
138: );
139:
140: END WIP_Repschedule_Util;