53: -- End of Comments
54:
55: TYPE WARRANTY_Rec_Type IS RECORD
56: (
57: WARRANTY_CONTRACT_XREF_ID NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
60: , CREATION_DATE DATE := FND_API.G_MISS_DATE
61: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
54:
55: TYPE WARRANTY_Rec_Type IS RECORD
56: (
57: WARRANTY_CONTRACT_XREF_ID NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
60: , CREATION_DATE DATE := FND_API.G_MISS_DATE
61: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
62: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
55: TYPE WARRANTY_Rec_Type IS RECORD
56: (
57: WARRANTY_CONTRACT_XREF_ID NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
60: , CREATION_DATE DATE := FND_API.G_MISS_DATE
61: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
62: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
56: (
57: WARRANTY_CONTRACT_XREF_ID NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
60: , CREATION_DATE DATE := FND_API.G_MISS_DATE
61: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
62: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
64: , SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR
57: WARRANTY_CONTRACT_XREF_ID NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
60: , CREATION_DATE DATE := FND_API.G_MISS_DATE
61: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
62: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
64: , SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
60: , CREATION_DATE DATE := FND_API.G_MISS_DATE
61: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
62: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
64: , SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
59: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
60: , CREATION_DATE DATE := FND_API.G_MISS_DATE
61: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
62: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
64: , SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
67: , WARRANTY_CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
60: , CREATION_DATE DATE := FND_API.G_MISS_DATE
61: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
62: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
64: , SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
67: , WARRANTY_CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
68: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
61: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
62: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
64: , SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
67: , WARRANTY_CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
68: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
64: , SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
67: , WARRANTY_CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
68: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
64: , SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
67: , WARRANTY_CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
68: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , SOURCE_TABLE VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
67: , WARRANTY_CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
68: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , SOURCE_COLUMN VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
67: , WARRANTY_CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
68: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , SOURCE_ID NUMBER := FND_API.G_MISS_NUM
67: , WARRANTY_CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
68: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , WARRANTY_CONTRACT_ID NUMBER := FND_API.G_MISS_NUM
68: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
69: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
76: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
77: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
85: , INSTANCE_ID NUMBER := FND_API.G_MISS_NUM --yvchen
78: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
85: , INSTANCE_ID NUMBER := FND_API.G_MISS_NUM --yvchen
86: );
79: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
85: , INSTANCE_ID NUMBER := FND_API.G_MISS_NUM --yvchen
86: );
87:
80: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
85: , INSTANCE_ID NUMBER := FND_API.G_MISS_NUM --yvchen
86: );
87:
88: G_MISS_WARRANTY_REC WARRANTY_Rec_Type;
81: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , REPAIR_LINE_ID NUMBER := FND_API.G_MISS_NUM
85: , INSTANCE_ID NUMBER := FND_API.G_MISS_NUM --yvchen
86: );
87:
88: G_MISS_WARRANTY_REC WARRANTY_Rec_Type;
89: TYPE WARRANTY_Tbl_Type IS TABLE OF WARRANTY_Rec_Type
98: -- Pre-Req :
99: -- Parameters:
100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
99: -- Parameters:
100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_admin_group_id IN NUMBER Required
100: -- IN
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_admin_group_id IN NUMBER Required
108: -- P_WARRANTY_Rec IN WARRANTY_Rec_Type Required
101: -- p_api_version_number IN NUMBER Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_admin_group_id IN NUMBER Required
108: -- P_WARRANTY_Rec IN WARRANTY_Rec_Type Required
109: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
102: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
103: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
105: -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
107: -- p_admin_group_id IN NUMBER Required
108: -- P_WARRANTY_Rec IN WARRANTY_Rec_Type Required
109: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
110: --
119: -- End of Comments
120: --
121: PROCEDURE Create_warranty_contract(
122: P_Api_Version_Number IN NUMBER,
123: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
124: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126: P_WARRANTY_Rec IN WARRANTY_Rec_Type := G_MISS_WARRANTY_REC,
127: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
120: --
121: PROCEDURE Create_warranty_contract(
122: P_Api_Version_Number IN NUMBER,
123: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
124: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126: P_WARRANTY_Rec IN WARRANTY_Rec_Type := G_MISS_WARRANTY_REC,
127: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
128: X_WARRANTY_CONTRACT_XREF_ID OUT NOCOPY NUMBER,
121: PROCEDURE Create_warranty_contract(
122: P_Api_Version_Number IN NUMBER,
123: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
124: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
126: P_WARRANTY_Rec IN WARRANTY_Rec_Type := G_MISS_WARRANTY_REC,
127: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
128: X_WARRANTY_CONTRACT_XREF_ID OUT NOCOPY NUMBER,
129: X_Return_Status OUT NOCOPY VARCHAR2,
132: );
133:
134: PROCEDURE Default_Warranty_Contract(
135: P_Api_Version_Number IN NUMBER,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Repair_Line_Id IN NUMBER,
140: P_Wip_Entity_Id IN NUMBER,
133:
134: PROCEDURE Default_Warranty_Contract(
135: P_Api_Version_Number IN NUMBER,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Repair_Line_Id IN NUMBER,
140: P_Wip_Entity_Id IN NUMBER,
141: P_Instance_Id IN NUMBER DEFAULT NULL, --yvchen
134: PROCEDURE Default_Warranty_Contract(
135: P_Api_Version_Number IN NUMBER,
136: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
137: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Repair_Line_Id IN NUMBER,
140: P_Wip_Entity_Id IN NUMBER,
141: P_Instance_Id IN NUMBER DEFAULT NULL, --yvchen
142: P_Is_Parent IN VARCHAR2 := FND_API.G_TRUE, --yvchen
138: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
139: P_Repair_Line_Id IN NUMBER,
140: P_Wip_Entity_Id IN NUMBER,
141: P_Instance_Id IN NUMBER DEFAULT NULL, --yvchen
142: P_Is_Parent IN VARCHAR2 := FND_API.G_TRUE, --yvchen
143: X_Return_Status OUT NOCOPY VARCHAR2,
144: X_Msg_Count OUT NOCOPY NUMBER,
145: X_Msg_Data OUT NOCOPY VARCHAR2
146: );