DBA Data[Home] [Help]

APPS.CSD_REPAIR_HISTORY_PVT dependencies on FND_API

Line 98: REPAIR_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,

94: REQUEST_ID NUMBER := NULL
95: );
96: TYPE REPH_Rec_Type IS RECORD
97: (
98: REPAIR_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
99: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
101: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
102: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 99: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,

95: );
96: TYPE REPH_Rec_Type IS RECORD
97: (
98: REPAIR_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
99: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
101: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
102: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
103: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 100: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

96: TYPE REPH_Rec_Type IS RECORD
97: (
98: REPAIR_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
99: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
101: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
102: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
103: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 101: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

97: (
98: REPAIR_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
99: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
101: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
102: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
103: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 102: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

98: REPAIR_HISTORY_ID NUMBER := FND_API.G_MISS_NUM,
99: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
101: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
102: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
103: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 103: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

99: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
100: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
101: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
102: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
103: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 104: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

100: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
101: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
102: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
103: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
108: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,

Line 105: CREATION_DATE DATE := FND_API.G_MISS_DATE,

101: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
102: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
103: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
108: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
109: EVENT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 106: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

102: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
103: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
108: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
109: EVENT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: EVENT_MEANING VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 107: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

103: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
108: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
109: EVENT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: EVENT_MEANING VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: EVENT_DATE DATE := FND_API.G_MISS_DATE,

Line 108: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,

104: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
108: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
109: EVENT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: EVENT_MEANING VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: EVENT_DATE DATE := FND_API.G_MISS_DATE,
112: QUANTITY NUMBER := FND_API.G_MISS_NUM,

Line 109: EVENT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
108: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
109: EVENT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: EVENT_MEANING VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: EVENT_DATE DATE := FND_API.G_MISS_DATE,
112: QUANTITY NUMBER := FND_API.G_MISS_NUM,
113: PARAMN1 NUMBER := FND_API.G_MISS_NUM,

Line 110: EVENT_MEANING VARCHAR2(30) := FND_API.G_MISS_CHAR,

106: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
108: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
109: EVENT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: EVENT_MEANING VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: EVENT_DATE DATE := FND_API.G_MISS_DATE,
112: QUANTITY NUMBER := FND_API.G_MISS_NUM,
113: PARAMN1 NUMBER := FND_API.G_MISS_NUM,
114: PARAMN2 NUMBER := FND_API.G_MISS_NUM,

Line 111: EVENT_DATE DATE := FND_API.G_MISS_DATE,

107: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
108: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
109: EVENT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: EVENT_MEANING VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: EVENT_DATE DATE := FND_API.G_MISS_DATE,
112: QUANTITY NUMBER := FND_API.G_MISS_NUM,
113: PARAMN1 NUMBER := FND_API.G_MISS_NUM,
114: PARAMN2 NUMBER := FND_API.G_MISS_NUM,
115: PARAMN3 NUMBER := FND_API.G_MISS_NUM,

Line 112: QUANTITY NUMBER := FND_API.G_MISS_NUM,

108: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
109: EVENT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: EVENT_MEANING VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: EVENT_DATE DATE := FND_API.G_MISS_DATE,
112: QUANTITY NUMBER := FND_API.G_MISS_NUM,
113: PARAMN1 NUMBER := FND_API.G_MISS_NUM,
114: PARAMN2 NUMBER := FND_API.G_MISS_NUM,
115: PARAMN3 NUMBER := FND_API.G_MISS_NUM,
116: PARAMN4 NUMBER := FND_API.G_MISS_NUM,

Line 113: PARAMN1 NUMBER := FND_API.G_MISS_NUM,

109: EVENT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: EVENT_MEANING VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: EVENT_DATE DATE := FND_API.G_MISS_DATE,
112: QUANTITY NUMBER := FND_API.G_MISS_NUM,
113: PARAMN1 NUMBER := FND_API.G_MISS_NUM,
114: PARAMN2 NUMBER := FND_API.G_MISS_NUM,
115: PARAMN3 NUMBER := FND_API.G_MISS_NUM,
116: PARAMN4 NUMBER := FND_API.G_MISS_NUM,
117: PARAMN5 NUMBER := FND_API.G_MISS_NUM,

Line 114: PARAMN2 NUMBER := FND_API.G_MISS_NUM,

110: EVENT_MEANING VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: EVENT_DATE DATE := FND_API.G_MISS_DATE,
112: QUANTITY NUMBER := FND_API.G_MISS_NUM,
113: PARAMN1 NUMBER := FND_API.G_MISS_NUM,
114: PARAMN2 NUMBER := FND_API.G_MISS_NUM,
115: PARAMN3 NUMBER := FND_API.G_MISS_NUM,
116: PARAMN4 NUMBER := FND_API.G_MISS_NUM,
117: PARAMN5 NUMBER := FND_API.G_MISS_NUM,
118: PARAMN6 NUMBER := FND_API.G_MISS_NUM,

Line 115: PARAMN3 NUMBER := FND_API.G_MISS_NUM,

111: EVENT_DATE DATE := FND_API.G_MISS_DATE,
112: QUANTITY NUMBER := FND_API.G_MISS_NUM,
113: PARAMN1 NUMBER := FND_API.G_MISS_NUM,
114: PARAMN2 NUMBER := FND_API.G_MISS_NUM,
115: PARAMN3 NUMBER := FND_API.G_MISS_NUM,
116: PARAMN4 NUMBER := FND_API.G_MISS_NUM,
117: PARAMN5 NUMBER := FND_API.G_MISS_NUM,
118: PARAMN6 NUMBER := FND_API.G_MISS_NUM,
119: PARAMN7 NUMBER := FND_API.G_MISS_NUM,

Line 116: PARAMN4 NUMBER := FND_API.G_MISS_NUM,

112: QUANTITY NUMBER := FND_API.G_MISS_NUM,
113: PARAMN1 NUMBER := FND_API.G_MISS_NUM,
114: PARAMN2 NUMBER := FND_API.G_MISS_NUM,
115: PARAMN3 NUMBER := FND_API.G_MISS_NUM,
116: PARAMN4 NUMBER := FND_API.G_MISS_NUM,
117: PARAMN5 NUMBER := FND_API.G_MISS_NUM,
118: PARAMN6 NUMBER := FND_API.G_MISS_NUM,
119: PARAMN7 NUMBER := FND_API.G_MISS_NUM,
120: PARAMN8 NUMBER := FND_API.G_MISS_NUM,

Line 117: PARAMN5 NUMBER := FND_API.G_MISS_NUM,

113: PARAMN1 NUMBER := FND_API.G_MISS_NUM,
114: PARAMN2 NUMBER := FND_API.G_MISS_NUM,
115: PARAMN3 NUMBER := FND_API.G_MISS_NUM,
116: PARAMN4 NUMBER := FND_API.G_MISS_NUM,
117: PARAMN5 NUMBER := FND_API.G_MISS_NUM,
118: PARAMN6 NUMBER := FND_API.G_MISS_NUM,
119: PARAMN7 NUMBER := FND_API.G_MISS_NUM,
120: PARAMN8 NUMBER := FND_API.G_MISS_NUM,
121: PARAMN9 NUMBER := FND_API.G_MISS_NUM,

Line 118: PARAMN6 NUMBER := FND_API.G_MISS_NUM,

114: PARAMN2 NUMBER := FND_API.G_MISS_NUM,
115: PARAMN3 NUMBER := FND_API.G_MISS_NUM,
116: PARAMN4 NUMBER := FND_API.G_MISS_NUM,
117: PARAMN5 NUMBER := FND_API.G_MISS_NUM,
118: PARAMN6 NUMBER := FND_API.G_MISS_NUM,
119: PARAMN7 NUMBER := FND_API.G_MISS_NUM,
120: PARAMN8 NUMBER := FND_API.G_MISS_NUM,
121: PARAMN9 NUMBER := FND_API.G_MISS_NUM,
122: PARAMN10 NUMBER := FND_API.G_MISS_NUM,

Line 119: PARAMN7 NUMBER := FND_API.G_MISS_NUM,

115: PARAMN3 NUMBER := FND_API.G_MISS_NUM,
116: PARAMN4 NUMBER := FND_API.G_MISS_NUM,
117: PARAMN5 NUMBER := FND_API.G_MISS_NUM,
118: PARAMN6 NUMBER := FND_API.G_MISS_NUM,
119: PARAMN7 NUMBER := FND_API.G_MISS_NUM,
120: PARAMN8 NUMBER := FND_API.G_MISS_NUM,
121: PARAMN9 NUMBER := FND_API.G_MISS_NUM,
122: PARAMN10 NUMBER := FND_API.G_MISS_NUM,
123: PARAMC1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 120: PARAMN8 NUMBER := FND_API.G_MISS_NUM,

116: PARAMN4 NUMBER := FND_API.G_MISS_NUM,
117: PARAMN5 NUMBER := FND_API.G_MISS_NUM,
118: PARAMN6 NUMBER := FND_API.G_MISS_NUM,
119: PARAMN7 NUMBER := FND_API.G_MISS_NUM,
120: PARAMN8 NUMBER := FND_API.G_MISS_NUM,
121: PARAMN9 NUMBER := FND_API.G_MISS_NUM,
122: PARAMN10 NUMBER := FND_API.G_MISS_NUM,
123: PARAMC1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: PARAMC2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 121: PARAMN9 NUMBER := FND_API.G_MISS_NUM,

117: PARAMN5 NUMBER := FND_API.G_MISS_NUM,
118: PARAMN6 NUMBER := FND_API.G_MISS_NUM,
119: PARAMN7 NUMBER := FND_API.G_MISS_NUM,
120: PARAMN8 NUMBER := FND_API.G_MISS_NUM,
121: PARAMN9 NUMBER := FND_API.G_MISS_NUM,
122: PARAMN10 NUMBER := FND_API.G_MISS_NUM,
123: PARAMC1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: PARAMC2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: PARAMC3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 122: PARAMN10 NUMBER := FND_API.G_MISS_NUM,

118: PARAMN6 NUMBER := FND_API.G_MISS_NUM,
119: PARAMN7 NUMBER := FND_API.G_MISS_NUM,
120: PARAMN8 NUMBER := FND_API.G_MISS_NUM,
121: PARAMN9 NUMBER := FND_API.G_MISS_NUM,
122: PARAMN10 NUMBER := FND_API.G_MISS_NUM,
123: PARAMC1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: PARAMC2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: PARAMC3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: PARAMC4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 123: PARAMC1 VARCHAR2(240) := FND_API.G_MISS_CHAR,

119: PARAMN7 NUMBER := FND_API.G_MISS_NUM,
120: PARAMN8 NUMBER := FND_API.G_MISS_NUM,
121: PARAMN9 NUMBER := FND_API.G_MISS_NUM,
122: PARAMN10 NUMBER := FND_API.G_MISS_NUM,
123: PARAMC1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: PARAMC2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: PARAMC3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: PARAMC4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: PARAMC5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 124: PARAMC2 VARCHAR2(240) := FND_API.G_MISS_CHAR,

120: PARAMN8 NUMBER := FND_API.G_MISS_NUM,
121: PARAMN9 NUMBER := FND_API.G_MISS_NUM,
122: PARAMN10 NUMBER := FND_API.G_MISS_NUM,
123: PARAMC1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: PARAMC2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: PARAMC3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: PARAMC4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: PARAMC5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: PARAMC6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 125: PARAMC3 VARCHAR2(240) := FND_API.G_MISS_CHAR,

121: PARAMN9 NUMBER := FND_API.G_MISS_NUM,
122: PARAMN10 NUMBER := FND_API.G_MISS_NUM,
123: PARAMC1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: PARAMC2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: PARAMC3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: PARAMC4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: PARAMC5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: PARAMC6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
129: PARAMC7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 126: PARAMC4 VARCHAR2(240) := FND_API.G_MISS_CHAR,

122: PARAMN10 NUMBER := FND_API.G_MISS_NUM,
123: PARAMC1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: PARAMC2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: PARAMC3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: PARAMC4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: PARAMC5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: PARAMC6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
129: PARAMC7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
130: PARAMC8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 127: PARAMC5 VARCHAR2(240) := FND_API.G_MISS_CHAR,

123: PARAMC1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
124: PARAMC2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: PARAMC3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: PARAMC4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: PARAMC5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: PARAMC6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
129: PARAMC7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
130: PARAMC8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
131: PARAMC9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 128: PARAMC6 VARCHAR2(240) := FND_API.G_MISS_CHAR,

124: PARAMC2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
125: PARAMC3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: PARAMC4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: PARAMC5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: PARAMC6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
129: PARAMC7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
130: PARAMC8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
131: PARAMC9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: PARAMC10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 129: PARAMC7 VARCHAR2(240) := FND_API.G_MISS_CHAR,

125: PARAMC3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
126: PARAMC4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: PARAMC5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: PARAMC6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
129: PARAMC7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
130: PARAMC8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
131: PARAMC9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: PARAMC10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
133: PARAMD1 DATE := FND_API.G_MISS_DATE,

Line 130: PARAMC8 VARCHAR2(240) := FND_API.G_MISS_CHAR,

126: PARAMC4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
127: PARAMC5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: PARAMC6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
129: PARAMC7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
130: PARAMC8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
131: PARAMC9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: PARAMC10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
133: PARAMD1 DATE := FND_API.G_MISS_DATE,
134: PARAMD2 DATE := FND_API.G_MISS_DATE,

Line 131: PARAMC9 VARCHAR2(240) := FND_API.G_MISS_CHAR,

127: PARAMC5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
128: PARAMC6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
129: PARAMC7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
130: PARAMC8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
131: PARAMC9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: PARAMC10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
133: PARAMD1 DATE := FND_API.G_MISS_DATE,
134: PARAMD2 DATE := FND_API.G_MISS_DATE,
135: PARAMD3 DATE := FND_API.G_MISS_DATE,

Line 132: PARAMC10 VARCHAR2(240) := FND_API.G_MISS_CHAR,

128: PARAMC6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
129: PARAMC7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
130: PARAMC8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
131: PARAMC9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: PARAMC10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
133: PARAMD1 DATE := FND_API.G_MISS_DATE,
134: PARAMD2 DATE := FND_API.G_MISS_DATE,
135: PARAMD3 DATE := FND_API.G_MISS_DATE,
136: PARAMD4 DATE := FND_API.G_MISS_DATE,

Line 133: PARAMD1 DATE := FND_API.G_MISS_DATE,

129: PARAMC7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
130: PARAMC8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
131: PARAMC9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: PARAMC10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
133: PARAMD1 DATE := FND_API.G_MISS_DATE,
134: PARAMD2 DATE := FND_API.G_MISS_DATE,
135: PARAMD3 DATE := FND_API.G_MISS_DATE,
136: PARAMD4 DATE := FND_API.G_MISS_DATE,
137: PARAMD5 DATE := FND_API.G_MISS_DATE,

Line 134: PARAMD2 DATE := FND_API.G_MISS_DATE,

130: PARAMC8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
131: PARAMC9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: PARAMC10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
133: PARAMD1 DATE := FND_API.G_MISS_DATE,
134: PARAMD2 DATE := FND_API.G_MISS_DATE,
135: PARAMD3 DATE := FND_API.G_MISS_DATE,
136: PARAMD4 DATE := FND_API.G_MISS_DATE,
137: PARAMD5 DATE := FND_API.G_MISS_DATE,
138: PARAMD6 DATE := FND_API.G_MISS_DATE,

Line 135: PARAMD3 DATE := FND_API.G_MISS_DATE,

131: PARAMC9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: PARAMC10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
133: PARAMD1 DATE := FND_API.G_MISS_DATE,
134: PARAMD2 DATE := FND_API.G_MISS_DATE,
135: PARAMD3 DATE := FND_API.G_MISS_DATE,
136: PARAMD4 DATE := FND_API.G_MISS_DATE,
137: PARAMD5 DATE := FND_API.G_MISS_DATE,
138: PARAMD6 DATE := FND_API.G_MISS_DATE,
139: PARAMD7 DATE := FND_API.G_MISS_DATE,

Line 136: PARAMD4 DATE := FND_API.G_MISS_DATE,

132: PARAMC10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
133: PARAMD1 DATE := FND_API.G_MISS_DATE,
134: PARAMD2 DATE := FND_API.G_MISS_DATE,
135: PARAMD3 DATE := FND_API.G_MISS_DATE,
136: PARAMD4 DATE := FND_API.G_MISS_DATE,
137: PARAMD5 DATE := FND_API.G_MISS_DATE,
138: PARAMD6 DATE := FND_API.G_MISS_DATE,
139: PARAMD7 DATE := FND_API.G_MISS_DATE,
140: PARAMD8 DATE := FND_API.G_MISS_DATE,

Line 137: PARAMD5 DATE := FND_API.G_MISS_DATE,

133: PARAMD1 DATE := FND_API.G_MISS_DATE,
134: PARAMD2 DATE := FND_API.G_MISS_DATE,
135: PARAMD3 DATE := FND_API.G_MISS_DATE,
136: PARAMD4 DATE := FND_API.G_MISS_DATE,
137: PARAMD5 DATE := FND_API.G_MISS_DATE,
138: PARAMD6 DATE := FND_API.G_MISS_DATE,
139: PARAMD7 DATE := FND_API.G_MISS_DATE,
140: PARAMD8 DATE := FND_API.G_MISS_DATE,
141: PARAMD9 DATE := FND_API.G_MISS_DATE,

Line 138: PARAMD6 DATE := FND_API.G_MISS_DATE,

134: PARAMD2 DATE := FND_API.G_MISS_DATE,
135: PARAMD3 DATE := FND_API.G_MISS_DATE,
136: PARAMD4 DATE := FND_API.G_MISS_DATE,
137: PARAMD5 DATE := FND_API.G_MISS_DATE,
138: PARAMD6 DATE := FND_API.G_MISS_DATE,
139: PARAMD7 DATE := FND_API.G_MISS_DATE,
140: PARAMD8 DATE := FND_API.G_MISS_DATE,
141: PARAMD9 DATE := FND_API.G_MISS_DATE,
142: PARAMD10 DATE := FND_API.G_MISS_DATE,

Line 139: PARAMD7 DATE := FND_API.G_MISS_DATE,

135: PARAMD3 DATE := FND_API.G_MISS_DATE,
136: PARAMD4 DATE := FND_API.G_MISS_DATE,
137: PARAMD5 DATE := FND_API.G_MISS_DATE,
138: PARAMD6 DATE := FND_API.G_MISS_DATE,
139: PARAMD7 DATE := FND_API.G_MISS_DATE,
140: PARAMD8 DATE := FND_API.G_MISS_DATE,
141: PARAMD9 DATE := FND_API.G_MISS_DATE,
142: PARAMD10 DATE := FND_API.G_MISS_DATE,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 140: PARAMD8 DATE := FND_API.G_MISS_DATE,

136: PARAMD4 DATE := FND_API.G_MISS_DATE,
137: PARAMD5 DATE := FND_API.G_MISS_DATE,
138: PARAMD6 DATE := FND_API.G_MISS_DATE,
139: PARAMD7 DATE := FND_API.G_MISS_DATE,
140: PARAMD8 DATE := FND_API.G_MISS_DATE,
141: PARAMD9 DATE := FND_API.G_MISS_DATE,
142: PARAMD10 DATE := FND_API.G_MISS_DATE,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 141: PARAMD9 DATE := FND_API.G_MISS_DATE,

137: PARAMD5 DATE := FND_API.G_MISS_DATE,
138: PARAMD6 DATE := FND_API.G_MISS_DATE,
139: PARAMD7 DATE := FND_API.G_MISS_DATE,
140: PARAMD8 DATE := FND_API.G_MISS_DATE,
141: PARAMD9 DATE := FND_API.G_MISS_DATE,
142: PARAMD10 DATE := FND_API.G_MISS_DATE,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 142: PARAMD10 DATE := FND_API.G_MISS_DATE,

138: PARAMD6 DATE := FND_API.G_MISS_DATE,
139: PARAMD7 DATE := FND_API.G_MISS_DATE,
140: PARAMD8 DATE := FND_API.G_MISS_DATE,
141: PARAMD9 DATE := FND_API.G_MISS_DATE,
142: PARAMD10 DATE := FND_API.G_MISS_DATE,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

139: PARAMD7 DATE := FND_API.G_MISS_DATE,
140: PARAMD8 DATE := FND_API.G_MISS_DATE,
141: PARAMD9 DATE := FND_API.G_MISS_DATE,
142: PARAMD10 DATE := FND_API.G_MISS_DATE,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 144: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

140: PARAMD8 DATE := FND_API.G_MISS_DATE,
141: PARAMD9 DATE := FND_API.G_MISS_DATE,
142: PARAMD10 DATE := FND_API.G_MISS_DATE,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 145: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

141: PARAMD9 DATE := FND_API.G_MISS_DATE,
142: PARAMD10 DATE := FND_API.G_MISS_DATE,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 146: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

142: PARAMD10 DATE := FND_API.G_MISS_DATE,
143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 147: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

143: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 148: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

144: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 149: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

145: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 150: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

146: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 151: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

147: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 152: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

148: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 153: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

149: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 154: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

150: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 155: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

151: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

Line 156: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

152: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
160: );

Line 157: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

153: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
160: );
161:

Line 158: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

154: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
160: );
161:
162: G_MISS_REPH_REC REPH_Rec_Type;

Line 159: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

155: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
157: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
158: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
159: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
160: );
161:
162: G_MISS_REPH_REC REPH_Rec_Type;
163: TYPE REPH_Tbl_Type IS TABLE OF REPH_Rec_Type

Line 176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

172: -- Pre-Req :
173: -- Parameters:
174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- P_REPH_Rec IN REPH_Rec_Type Required
180: --

Line 177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

173: -- Parameters:
174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- P_REPH_Rec IN REPH_Rec_Type Required
180: --
181: -- OUT:

Line 178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- P_REPH_Rec IN REPH_Rec_Type Required
180: --
181: -- OUT:
182: -- x_return_status OUT NOCOPY VARCHAR2

Line 193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

189: -- End of Comments
190: --
191: PROCEDURE Create_repair_history(
192: P_Api_Version_Number IN NUMBER,
193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196: P_REPH_Rec IN REPH_Rec_Type := G_MISS_REPH_REC,
197: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 194: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

190: --
191: PROCEDURE Create_repair_history(
192: P_Api_Version_Number IN NUMBER,
193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196: P_REPH_Rec IN REPH_Rec_Type := G_MISS_REPH_REC,
197: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
198: X_REPAIR_HISTORY_ID OUT NOCOPY NUMBER,

Line 195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

191: PROCEDURE Create_repair_history(
192: P_Api_Version_Number IN NUMBER,
193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
196: P_REPH_Rec IN REPH_Rec_Type := G_MISS_REPH_REC,
197: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
198: X_REPAIR_HISTORY_ID OUT NOCOPY NUMBER,
199: X_Return_Status OUT NOCOPY VARCHAR2,

Line 213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

209: -- Pre-Req :
210: -- Parameters:
211: -- IN
212: -- p_api_version_number IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
217: -- P_REPH_Rec IN REPH_Rec_Type Required

Line 214: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

210: -- Parameters:
211: -- IN
212: -- p_api_version_number IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
217: -- P_REPH_Rec IN REPH_Rec_Type Required
218: --

Line 215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

211: -- IN
212: -- p_api_version_number IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
214: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
215: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
216: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
217: -- P_REPH_Rec IN REPH_Rec_Type Required
218: --
219: -- OUT:

Line 232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

228: --
229: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
230: PROCEDURE Update_repair_history(
231: P_Api_Version_Number IN NUMBER,
232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235: P_REPH_Rec IN REPH_Rec_Type,
236: X_Return_Status OUT NOCOPY VARCHAR2,

Line 233: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

229: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
230: PROCEDURE Update_repair_history(
231: P_Api_Version_Number IN NUMBER,
232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235: P_REPH_Rec IN REPH_Rec_Type,
236: X_Return_Status OUT NOCOPY VARCHAR2,
237: X_Msg_Count OUT NOCOPY NUMBER,

Line 234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

230: PROCEDURE Update_repair_history(
231: P_Api_Version_Number IN NUMBER,
232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
235: P_REPH_Rec IN REPH_Rec_Type,
236: X_Return_Status OUT NOCOPY VARCHAR2,
237: X_Msg_Count OUT NOCOPY NUMBER,
238: X_Msg_Data OUT NOCOPY VARCHAR2

Line 250: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

246: -- Pre-Req :
247: -- Parameters:
248: -- IN
249: -- p_api_version_number IN NUMBER Required
250: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
251: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
253: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
254: -- P_REPH_Rec IN REPH_Rec_Type Required

Line 251: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

247: -- Parameters:
248: -- IN
249: -- p_api_version_number IN NUMBER Required
250: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
251: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
253: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
254: -- P_REPH_Rec IN REPH_Rec_Type Required
255: --

Line 252: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

248: -- IN
249: -- p_api_version_number IN NUMBER Required
250: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
251: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
252: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
253: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
254: -- P_REPH_Rec IN REPH_Rec_Type Required
255: --
256: -- OUT:

Line 270: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

266: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
267: -- The Master delete procedure may not be needed depends on different business requirements.
268: PROCEDURE Delete_repair_history(
269: P_Api_Version_Number IN NUMBER,
270: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
271: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: P_REPH_Rec IN REPH_Rec_Type,
274: X_Return_Status OUT NOCOPY VARCHAR2,

Line 271: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

267: -- The Master delete procedure may not be needed depends on different business requirements.
268: PROCEDURE Delete_repair_history(
269: P_Api_Version_Number IN NUMBER,
270: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
271: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: P_REPH_Rec IN REPH_Rec_Type,
274: X_Return_Status OUT NOCOPY VARCHAR2,
275: X_Msg_Count OUT NOCOPY NUMBER,

Line 272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

268: PROCEDURE Delete_repair_history(
269: P_Api_Version_Number IN NUMBER,
270: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
271: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: P_REPH_Rec IN REPH_Rec_Type,
274: X_Return_Status OUT NOCOPY VARCHAR2,
275: X_Msg_Count OUT NOCOPY NUMBER,
276: X_Msg_Data OUT NOCOPY VARCHAR2

Line 288: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

284: -- Pre-Req :
285: -- Parameters:
286: -- IN
287: -- p_api_version_number IN NUMBER Required
288: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
289: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
290: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
291: -- P_REPH_Rec IN REPH_Rec_Type Required
292: -- Hint: Add List of bind variables here

Line 289: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

285: -- Parameters:
286: -- IN
287: -- p_api_version_number IN NUMBER Required
288: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
289: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
290: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
291: -- P_REPH_Rec IN REPH_Rec_Type Required
292: -- Hint: Add List of bind variables here
293: -- p_rec_requested IN NUMBER Optional Default = 30

Line 299: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE

295: --
296: -- Return Total Records Count Flag. This flag controls whether the total record count
297: -- and total record amount is returned.
298: --
299: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
300: -- Hint: User defined record type
301: -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
302: --
303: -- OUT:

Line 321: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

317: -- End of Comments
318: --
319: PROCEDURE Get_repair_history(
320: P_Api_Version_Number IN NUMBER,
321: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: P_identity_salesforce_id IN NUMBER := NULL,
324: P_REPH_Rec IN REPH_Rec_Type,
325: -- Hint: Add list of bind variables here

Line 322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

318: --
319: PROCEDURE Get_repair_history(
320: P_Api_Version_Number IN NUMBER,
321: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: P_identity_salesforce_id IN NUMBER := NULL,
324: P_REPH_Rec IN REPH_Rec_Type,
325: -- Hint: Add list of bind variables here
326: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

Line 328: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

324: P_REPH_Rec IN REPH_Rec_Type,
325: -- Hint: Add list of bind variables here
326: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
327: p_start_rec_prt IN NUMBER := 1,
328: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
329: -- Hint: user defined record type
330: p_order_by_rec IN REPH_sort_rec_type,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,

Line 355: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

351: --
352: -- End of Comments
353:
354: PROCEDURE Validate_REPAIR_HISTORY_ID (
355: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
356: P_Validation_mode IN VARCHAR2,
357: P_REPAIR_HISTORY_ID IN NUMBER,
358: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
359: X_Return_Status OUT NOCOPY VARCHAR2,

Line 376: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

372: --
373: -- End of Comments
374:
375: PROCEDURE Validate_REQUEST_ID (
376: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
377: P_Validation_mode IN VARCHAR2,
378: P_REQUEST_ID IN NUMBER,
379: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
380: X_Return_Status OUT NOCOPY VARCHAR2,

Line 397: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

393: --
394: -- End of Comments
395:
396: PROCEDURE Validate_REPAIR_LINE_ID (
397: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
398: P_Validation_mode IN VARCHAR2,
399: P_REPAIR_LINE_ID IN NUMBER,
400: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
401: X_Return_Status OUT NOCOPY VARCHAR2,

Line 418: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

414: --
415: -- End of Comments
416:
417: PROCEDURE Validate_EVENT_CODE (
418: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
419: P_Validation_mode IN VARCHAR2,
420: P_EVENT_CODE IN VARCHAR2,
421: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
422: X_Return_Status OUT NOCOPY VARCHAR2,

Line 431: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

427:
428:
429:
430: PROCEDURE Validate_event_meaning (
431: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
432: P_Validation_mode IN VARCHAR2,
433: P_EVENT_meaning IN VARCHAR2,
434: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
435: X_Return_Status OUT NOCOPY VARCHAR2,

Line 451: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

447: --
448: -- End of Comments
449:
450: PROCEDURE Validate_EVENT_DATE (
451: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
452: P_Validation_mode IN VARCHAR2,
453: P_EVENT_DATE IN DATE,
454: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
455: X_Return_Status OUT NOCOPY VARCHAR2,

Line 472: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

468: --
469: -- End of Comments
470:
471: PROCEDURE Validate_QUANTITY (
472: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
473: P_Validation_mode IN VARCHAR2,
474: P_QUANTITY IN NUMBER,
475: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
476: X_Return_Status OUT NOCOPY VARCHAR2,

Line 493: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

489: --
490: -- End of Comments
491:
492: PROCEDURE Validate_PARAMN1 (
493: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
494: P_Validation_mode IN VARCHAR2,
495: P_PARAMN1 IN NUMBER,
496: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
497: X_Return_Status OUT NOCOPY VARCHAR2,

Line 514: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

510: --
511: -- End of Comments
512:
513: PROCEDURE Validate_PARAMN2 (
514: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
515: P_Validation_mode IN VARCHAR2,
516: P_PARAMN2 IN NUMBER,
517: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
518: X_Return_Status OUT NOCOPY VARCHAR2,

Line 535: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

531: --
532: -- End of Comments
533:
534: PROCEDURE Validate_PARAMN3 (
535: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
536: P_Validation_mode IN VARCHAR2,
537: P_PARAMN3 IN NUMBER,
538: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
539: X_Return_Status OUT NOCOPY VARCHAR2,

Line 556: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

552: --
553: -- End of Comments
554:
555: PROCEDURE Validate_PARAMN4 (
556: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
557: P_Validation_mode IN VARCHAR2,
558: P_PARAMN4 IN NUMBER,
559: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
560: X_Return_Status OUT NOCOPY VARCHAR2,

Line 577: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

573: --
574: -- End of Comments
575:
576: PROCEDURE Validate_PARAMN5 (
577: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
578: P_Validation_mode IN VARCHAR2,
579: P_PARAMN5 IN NUMBER,
580: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
581: X_Return_Status OUT NOCOPY VARCHAR2,

Line 598: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

594: --
595: -- End of Comments
596:
597: PROCEDURE Validate_PARAMN6 (
598: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
599: P_Validation_mode IN VARCHAR2,
600: P_PARAMN6 IN NUMBER,
601: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
602: X_Return_Status OUT NOCOPY VARCHAR2,

Line 619: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

615: --
616: -- End of Comments
617:
618: PROCEDURE Validate_PARAMN7 (
619: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
620: P_Validation_mode IN VARCHAR2,
621: P_PARAMN7 IN NUMBER,
622: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
623: X_Return_Status OUT NOCOPY VARCHAR2,

Line 640: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

636: --
637: -- End of Comments
638:
639: PROCEDURE Validate_PARAMN8 (
640: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
641: P_Validation_mode IN VARCHAR2,
642: P_PARAMN8 IN NUMBER,
643: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
644: X_Return_Status OUT NOCOPY VARCHAR2,

Line 661: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

657: --
658: -- End of Comments
659:
660: PROCEDURE Validate_PARAMN9 (
661: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
662: P_Validation_mode IN VARCHAR2,
663: P_PARAMN9 IN NUMBER,
664: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
665: X_Return_Status OUT NOCOPY VARCHAR2,

Line 682: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

678: --
679: -- End of Comments
680:
681: PROCEDURE Validate_PARAMN10 (
682: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
683: P_Validation_mode IN VARCHAR2,
684: P_PARAMN10 IN NUMBER,
685: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
686: X_Return_Status OUT NOCOPY VARCHAR2,

Line 703: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

699: --
700: -- End of Comments
701:
702: PROCEDURE Validate_PARAMC1 (
703: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
704: P_Validation_mode IN VARCHAR2,
705: P_PARAMC1 IN VARCHAR2,
706: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
707: X_Return_Status OUT NOCOPY VARCHAR2,

Line 724: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

720: --
721: -- End of Comments
722:
723: PROCEDURE Validate_PARAMC2 (
724: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
725: P_Validation_mode IN VARCHAR2,
726: P_PARAMC2 IN VARCHAR2,
727: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
728: X_Return_Status OUT NOCOPY VARCHAR2,

Line 745: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

741: --
742: -- End of Comments
743:
744: PROCEDURE Validate_PARAMC3 (
745: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
746: P_Validation_mode IN VARCHAR2,
747: P_PARAMC3 IN VARCHAR2,
748: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
749: X_Return_Status OUT NOCOPY VARCHAR2,

Line 766: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

762: --
763: -- End of Comments
764:
765: PROCEDURE Validate_PARAMC4 (
766: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
767: P_Validation_mode IN VARCHAR2,
768: P_PARAMC4 IN VARCHAR2,
769: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
770: X_Return_Status OUT NOCOPY VARCHAR2,

Line 787: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

783: --
784: -- End of Comments
785:
786: PROCEDURE Validate_PARAMC5 (
787: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
788: P_Validation_mode IN VARCHAR2,
789: P_PARAMC5 IN VARCHAR2,
790: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
791: X_Return_Status OUT NOCOPY VARCHAR2,

Line 808: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

804: --
805: -- End of Comments
806:
807: PROCEDURE Validate_PARAMC6 (
808: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
809: P_Validation_mode IN VARCHAR2,
810: P_PARAMC6 IN VARCHAR2,
811: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
812: X_Return_Status OUT NOCOPY VARCHAR2,

Line 829: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

825: --
826: -- End of Comments
827:
828: PROCEDURE Validate_PARAMC7 (
829: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
830: P_Validation_mode IN VARCHAR2,
831: P_PARAMC7 IN VARCHAR2,
832: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
833: X_Return_Status OUT NOCOPY VARCHAR2,

Line 850: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

846: --
847: -- End of Comments
848:
849: PROCEDURE Validate_PARAMC8 (
850: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
851: P_Validation_mode IN VARCHAR2,
852: P_PARAMC8 IN VARCHAR2,
853: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
854: X_Return_Status OUT NOCOPY VARCHAR2,

Line 871: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

867: --
868: -- End of Comments
869:
870: PROCEDURE Validate_PARAMC9 (
871: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
872: P_Validation_mode IN VARCHAR2,
873: P_PARAMC9 IN VARCHAR2,
874: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
875: X_Return_Status OUT NOCOPY VARCHAR2,

Line 892: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

888: --
889: -- End of Comments
890:
891: PROCEDURE Validate_PARAMC10 (
892: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
893: P_Validation_mode IN VARCHAR2,
894: P_PARAMC10 IN VARCHAR2,
895: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
896: X_Return_Status OUT NOCOPY VARCHAR2,

Line 913: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

909: --
910: -- End of Comments
911:
912: PROCEDURE Validate_PARAMD1 (
913: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
914: P_Validation_mode IN VARCHAR2,
915: P_PARAMD1 IN DATE,
916: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
917: X_Return_Status OUT NOCOPY VARCHAR2,

Line 934: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

930: --
931: -- End of Comments
932:
933: PROCEDURE Validate_PARAMD2 (
934: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
935: P_Validation_mode IN VARCHAR2,
936: P_PARAMD2 IN DATE,
937: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
938: X_Return_Status OUT NOCOPY VARCHAR2,

Line 955: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

951: --
952: -- End of Comments
953:
954: PROCEDURE Validate_PARAMD3 (
955: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
956: P_Validation_mode IN VARCHAR2,
957: P_PARAMD3 IN DATE,
958: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
959: X_Return_Status OUT NOCOPY VARCHAR2,

Line 976: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

972: --
973: -- End of Comments
974:
975: PROCEDURE Validate_PARAMD4 (
976: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
977: P_Validation_mode IN VARCHAR2,
978: P_PARAMD4 IN DATE,
979: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
980: X_Return_Status OUT NOCOPY VARCHAR2,

Line 997: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

993: --
994: -- End of Comments
995:
996: PROCEDURE Validate_PARAMD5 (
997: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
998: P_Validation_mode IN VARCHAR2,
999: P_PARAMD5 IN DATE,
1000: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1001: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1018: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1014: --
1015: -- End of Comments
1016:
1017: PROCEDURE Validate_PARAMD6 (
1018: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1019: P_Validation_mode IN VARCHAR2,
1020: P_PARAMD6 IN DATE,
1021: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1022: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1039: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1035: --
1036: -- End of Comments
1037:
1038: PROCEDURE Validate_PARAMD7 (
1039: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1040: P_Validation_mode IN VARCHAR2,
1041: P_PARAMD7 IN DATE,
1042: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1043: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1060: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1056: --
1057: -- End of Comments
1058:
1059: PROCEDURE Validate_PARAMD8 (
1060: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1061: P_Validation_mode IN VARCHAR2,
1062: P_PARAMD8 IN DATE,
1063: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1064: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1081: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1077: --
1078: -- End of Comments
1079:
1080: PROCEDURE Validate_PARAMD9 (
1081: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1082: P_Validation_mode IN VARCHAR2,
1083: P_PARAMD9 IN DATE,
1084: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1085: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1102: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1098: --
1099: -- End of Comments
1100:
1101: PROCEDURE Validate_PARAMD10 (
1102: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1103: P_Validation_mode IN VARCHAR2,
1104: P_PARAMD10 IN DATE,
1105: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY JTF_PLSQL_API.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
1106: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1124: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1120: -- End of Comments
1121:
1122: -- travi OBJECT_VERSION_NUMBER validation
1123: PROCEDURE Validate_OBJECT_VERSION_NUMBER (
1124: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1125: P_Validation_mode IN VARCHAR2,
1126: P_OBJECT_VERSION_NUMBER IN NUMBER,
1127: P_REPAIR_HISTORY_ID IN NUMBER,
1128: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1134: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1130: X_Msg_Data OUT NOCOPY VARCHAR2
1131: );
1132:
1133: PROCEDURE Validate_REPH_rec(
1134: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1135: P_Validation_mode IN VARCHAR2,
1136: P_REPH_Rec IN REPH_Rec_Type,
1137: X_Return_Status OUT NOCOPY VARCHAR2,
1138: X_Msg_Count OUT NOCOPY NUMBER,

Line 1154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1150: -- 2. We can also validate table instead of record. There will be an option for user to choose.
1151: -- End of Comments
1152:
1153: PROCEDURE Validate_repair_history(
1154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1155: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1156: P_Validation_mode IN VARCHAR2,
1157: P_REPH_Rec IN REPH_Rec_Type,
1158: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1155: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1151: -- End of Comments
1152:
1153: PROCEDURE Validate_repair_history(
1154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1155: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1156: P_Validation_mode IN VARCHAR2,
1157: P_REPH_Rec IN REPH_Rec_Type,
1158: X_Return_Status OUT NOCOPY VARCHAR2,
1159: X_Msg_Count OUT NOCOPY NUMBER,