66:
67: -- travi changes
68: TYPE REPJOBXREF_Rec_Type IS RECORD
69: (
70: REPAIR_JOB_XREF_ID NUMBER := FND_API.G_MISS_NUM,
71: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
72: CREATION_DATE DATE := FND_API.G_MISS_DATE,
73: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
74: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
67: -- travi changes
68: TYPE REPJOBXREF_Rec_Type IS RECORD
69: (
70: REPAIR_JOB_XREF_ID NUMBER := FND_API.G_MISS_NUM,
71: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
72: CREATION_DATE DATE := FND_API.G_MISS_DATE,
73: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
74: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
75: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
68: TYPE REPJOBXREF_Rec_Type IS RECORD
69: (
70: REPAIR_JOB_XREF_ID NUMBER := FND_API.G_MISS_NUM,
71: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
72: CREATION_DATE DATE := FND_API.G_MISS_DATE,
73: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
74: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
75: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
76: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
69: (
70: REPAIR_JOB_XREF_ID NUMBER := FND_API.G_MISS_NUM,
71: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
72: CREATION_DATE DATE := FND_API.G_MISS_DATE,
73: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
74: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
75: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
76: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
77: WIP_ENTITY_ID NUMBER := FND_API.G_MISS_NUM,
70: REPAIR_JOB_XREF_ID NUMBER := FND_API.G_MISS_NUM,
71: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
72: CREATION_DATE DATE := FND_API.G_MISS_DATE,
73: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
74: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
75: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
76: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
77: WIP_ENTITY_ID NUMBER := FND_API.G_MISS_NUM,
78: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
71: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
72: CREATION_DATE DATE := FND_API.G_MISS_DATE,
73: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
74: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
75: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
76: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
77: WIP_ENTITY_ID NUMBER := FND_API.G_MISS_NUM,
78: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
79: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
72: CREATION_DATE DATE := FND_API.G_MISS_DATE,
73: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
74: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
75: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
76: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
77: WIP_ENTITY_ID NUMBER := FND_API.G_MISS_NUM,
78: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
79: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
80: QUANTITY NUMBER := FND_API.G_MISS_NUM,
73: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
74: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
75: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
76: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
77: WIP_ENTITY_ID NUMBER := FND_API.G_MISS_NUM,
78: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
79: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
80: QUANTITY NUMBER := FND_API.G_MISS_NUM,
81: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
74: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
75: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
76: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
77: WIP_ENTITY_ID NUMBER := FND_API.G_MISS_NUM,
78: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
79: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
80: QUANTITY NUMBER := FND_API.G_MISS_NUM,
81: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
82: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
76: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
77: WIP_ENTITY_ID NUMBER := FND_API.G_MISS_NUM,
78: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
79: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
80: QUANTITY NUMBER := FND_API.G_MISS_NUM,
81: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
82: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: SOURCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
76: REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM,
77: WIP_ENTITY_ID NUMBER := FND_API.G_MISS_NUM,
78: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
79: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
80: QUANTITY NUMBER := FND_API.G_MISS_NUM,
81: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
82: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: SOURCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: SOURCE_ID1 NUMBER := FND_API.G_MISS_NUM,
77: WIP_ENTITY_ID NUMBER := FND_API.G_MISS_NUM,
78: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
79: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
80: QUANTITY NUMBER := FND_API.G_MISS_NUM,
81: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
82: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: SOURCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: SOURCE_ID1 NUMBER := FND_API.G_MISS_NUM,
85: RO_SERVICE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
78: GROUP_ID NUMBER := FND_API.G_MISS_NUM,
79: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
80: QUANTITY NUMBER := FND_API.G_MISS_NUM,
81: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
82: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: SOURCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: SOURCE_ID1 NUMBER := FND_API.G_MISS_NUM,
85: RO_SERVICE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
86: JOB_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
79: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
80: QUANTITY NUMBER := FND_API.G_MISS_NUM,
81: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
82: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: SOURCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: SOURCE_ID1 NUMBER := FND_API.G_MISS_NUM,
85: RO_SERVICE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
86: JOB_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
80: QUANTITY NUMBER := FND_API.G_MISS_NUM,
81: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
82: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: SOURCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: SOURCE_ID1 NUMBER := FND_API.G_MISS_NUM,
85: RO_SERVICE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
86: JOB_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
88: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
82: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: SOURCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: SOURCE_ID1 NUMBER := FND_API.G_MISS_NUM,
85: RO_SERVICE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
86: JOB_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
88: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: ITEM_REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: SOURCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: SOURCE_ID1 NUMBER := FND_API.G_MISS_NUM,
85: RO_SERVICE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
86: JOB_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
88: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: SOURCE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
84: SOURCE_ID1 NUMBER := FND_API.G_MISS_NUM,
85: RO_SERVICE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
86: JOB_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
88: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: SOURCE_ID1 NUMBER := FND_API.G_MISS_NUM,
85: RO_SERVICE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
86: JOB_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
88: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: RO_SERVICE_CODE_ID NUMBER := FND_API.G_MISS_NUM,
86: JOB_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
88: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: JOB_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
88: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
88: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: QUANTITY_COMPLETED NUMBER := FND_API.G_MISS_NUM
97: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
98: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: QUANTITY_COMPLETED NUMBER := FND_API.G_MISS_NUM
105: );
98: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: QUANTITY_COMPLETED NUMBER := FND_API.G_MISS_NUM
105: );
106:
99: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: QUANTITY_COMPLETED NUMBER := FND_API.G_MISS_NUM
105: );
106:
107: G_MISS_REPJOBXREF_REC REPJOBXREF_Rec_Type;
100: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104: QUANTITY_COMPLETED NUMBER := FND_API.G_MISS_NUM
105: );
106:
107: G_MISS_REPJOBXREF_REC REPJOBXREF_Rec_Type;
108: TYPE REPJOBXREF_Tbl_Type IS TABLE OF REPJOBXREF_Rec_Type
117: -- Pre-Req :
118: -- Parameters:
119: -- IN
120: -- p_api_version_number IN NUMBER Required
121: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
122: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
124: -- P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type Required
125: --
118: -- Parameters:
119: -- IN
120: -- p_api_version_number IN NUMBER Required
121: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
122: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
124: -- P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type Required
125: --
126: -- OUT:
119: -- IN
120: -- p_api_version_number IN NUMBER Required
121: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
122: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
123: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
124: -- P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type Required
125: --
126: -- OUT:
127: -- x_return_status OUT NOCOPY VARCHAR2
134: -- End of Comments
135: --
136: PROCEDURE Create_repjobxref(
137: P_Api_Version_Number IN NUMBER,
138: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
139: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type := G_MISS_REPJOBXREF_REC,
142: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
135: --
136: PROCEDURE Create_repjobxref(
137: P_Api_Version_Number IN NUMBER,
138: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
139: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type := G_MISS_REPJOBXREF_REC,
142: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
143: X_REPAIR_JOB_XREF_ID OUT NOCOPY NUMBER,
136: PROCEDURE Create_repjobxref(
137: P_Api_Version_Number IN NUMBER,
138: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
139: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type := G_MISS_REPJOBXREF_REC,
142: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
143: X_REPAIR_JOB_XREF_ID OUT NOCOPY NUMBER,
144: X_Return_Status OUT NOCOPY VARCHAR2,
154: -- Pre-Req :
155: -- Parameters:
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
162: -- P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type Required
155: -- Parameters:
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
162: -- P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type Required
163: --
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
162: -- P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type Required
163: --
164: -- OUT:
173: --
174: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
175: PROCEDURE Update_repjobxref(
176: P_Api_Version_Number IN NUMBER,
177: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
178: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
181: X_Return_Status OUT NOCOPY VARCHAR2,
174: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
175: PROCEDURE Update_repjobxref(
176: P_Api_Version_Number IN NUMBER,
177: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
178: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
181: X_Return_Status OUT NOCOPY VARCHAR2,
182: X_Msg_Count OUT NOCOPY NUMBER,
175: PROCEDURE Update_repjobxref(
176: P_Api_Version_Number IN NUMBER,
177: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
178: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
181: X_Return_Status OUT NOCOPY VARCHAR2,
182: X_Msg_Count OUT NOCOPY NUMBER,
183: X_Msg_Data OUT NOCOPY VARCHAR2
191: -- Pre-Req :
192: -- Parameters:
193: -- IN
194: -- p_api_version_number IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
196: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
199: -- P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type Required
192: -- Parameters:
193: -- IN
194: -- p_api_version_number IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
196: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
199: -- P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type Required
200: --
193: -- IN
194: -- p_api_version_number IN NUMBER Required
195: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
196: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
197: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
199: -- P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type Required
200: --
201: -- OUT:
211: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
212: -- The Master delete procedure may not be needed depends on different business requirements.
213: PROCEDURE Delete_repjobxref(
214: P_Api_Version_Number IN NUMBER,
215: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
216: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
219: X_Return_Status OUT NOCOPY VARCHAR2,
212: -- The Master delete procedure may not be needed depends on different business requirements.
213: PROCEDURE Delete_repjobxref(
214: P_Api_Version_Number IN NUMBER,
215: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
216: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
219: X_Return_Status OUT NOCOPY VARCHAR2,
220: X_Msg_Count OUT NOCOPY NUMBER,
213: PROCEDURE Delete_repjobxref(
214: P_Api_Version_Number IN NUMBER,
215: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
216: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
217: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
219: X_Return_Status OUT NOCOPY VARCHAR2,
220: X_Msg_Count OUT NOCOPY NUMBER,
221: X_Msg_Data OUT NOCOPY VARCHAR2
229: -- Pre-Req :
230: -- Parameters:
231: -- IN
232: -- p_api_version_number IN NUMBER Required
233: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
234: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
235: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
236: -- P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type Required
237: -- Hint: Add List of bind variables here
230: -- Parameters:
231: -- IN
232: -- p_api_version_number IN NUMBER Required
233: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
234: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
235: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
236: -- P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type Required
237: -- Hint: Add List of bind variables here
238: -- p_rec_requested IN NUMBER Optional Default = 30
240: --
241: -- Return Total Records Count Flag. This flag controls whether the total record count
242: -- and total record amount is returned.
243: --
244: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
245: -- Hint: User defined record type
246: -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
247: --
248: -- OUT:
262: -- End of Comments
263: --
264: PROCEDURE Get_repjobxref(
265: P_Api_Version_Number IN NUMBER,
266: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: P_identity_salesforce_id IN NUMBER := NULL,
269: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
270: -- Hint: Add list of bind variables here
263: --
264: PROCEDURE Get_repjobxref(
265: P_Api_Version_Number IN NUMBER,
266: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268: P_identity_salesforce_id IN NUMBER := NULL,
269: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
270: -- Hint: Add list of bind variables here
271: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
269: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
270: -- Hint: Add list of bind variables here
271: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
272: p_start_rec_prt IN NUMBER := 1,
273: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
274: -- Hint: user defined record type
275: p_order_by_rec IN REPJOBXREF_sort_rec_type,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
296: --
297: -- End of Comments
298:
299: PROCEDURE Validate_REPAIR_JOB_XREF_ID (
300: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
301: P_Validation_mode IN VARCHAR2,
302: P_REPAIR_JOB_XREF_ID IN NUMBER,
303: -- 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.
304: X_Return_Status OUT NOCOPY VARCHAR2,
317: --
318: -- End of Comments
319:
320: PROCEDURE Validate_REPAIR_LINE_ID (
321: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
322: P_Validation_mode IN VARCHAR2,
323: P_REPAIR_LINE_ID IN NUMBER,
324: -- 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.
325: X_Return_Status OUT NOCOPY VARCHAR2,
338: --
339: -- End of Comments
340:
341: PROCEDURE Validate_WIP_ENTITY_ID (
342: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
343: P_Validation_mode IN VARCHAR2,
344: P_WIP_ENTITY_ID IN NUMBER,
345: -- 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.
346: X_Return_Status OUT NOCOPY VARCHAR2,
359: --
360: -- End of Comments
361:
362: PROCEDURE Validate_GROUP_ID (
363: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
364: P_Validation_mode IN VARCHAR2,
365: P_GROUP_ID IN NUMBER,
366: -- 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.
367: X_Return_Status OUT NOCOPY VARCHAR2,
380: --
381: -- End of Comments
382:
383: PROCEDURE Validate_ORGANIZATION_ID (
384: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
385: P_Validation_mode IN VARCHAR2,
386: P_ORGANIZATION_ID IN NUMBER,
387: -- 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.
388: X_Return_Status OUT NOCOPY VARCHAR2,
401: --
402: -- End of Comments
403:
404: PROCEDURE Validate_QUANTITY (
405: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
406: P_Validation_mode IN VARCHAR2,
407: P_QUANTITY IN NUMBER,
408: -- 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.
409: X_Return_Status OUT NOCOPY VARCHAR2,
422: -- 2. Developer can manually added inter-field level validation.
423: -- End of Comments
424:
425: PROCEDURE Validate_REPJOBXREF_rec(
426: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
427: P_Validation_mode IN VARCHAR2,
428: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
429: X_Return_Status OUT NOCOPY VARCHAR2,
430: X_Msg_Count OUT NOCOPY NUMBER,
442: -- 2. We can also validate table instead of record. There will be an option for user to choose.
443: -- End of Comments
444:
445: PROCEDURE Validate_repjobxref(
446: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
447: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
448: P_Validation_mode IN VARCHAR2,
449: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
450: X_Return_Status OUT NOCOPY VARCHAR2,
443: -- End of Comments
444:
445: PROCEDURE Validate_repjobxref(
446: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
447: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
448: P_Validation_mode IN VARCHAR2,
449: P_REPJOBXREF_Rec IN REPJOBXREF_Rec_Type,
450: X_Return_Status OUT NOCOPY VARCHAR2,
451: X_Msg_Count OUT NOCOPY NUMBER,