eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_RELATED_OBJ_PVT dependencies on FND_API

Line 45: RELATED_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

41: -- End of Comments
42:
43: /*TYPE RELATED_OBJ_Rec_Type IS RECORD
44: (
45: RELATED_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 46: CREATION_DATE DATE := FND_API.G_MISS_DATE,

42:
43: /*TYPE RELATED_OBJ_Rec_Type IS RECORD
44: (
45: RELATED_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

43: /*TYPE RELATED_OBJ_Rec_Type IS RECORD
44: (
45: RELATED_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
51: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

Line 48: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

44: (
45: RELATED_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
51: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

45: RELATED_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
51: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

Line 50: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
51: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 51: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
51: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 52: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

48: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
51: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

Line 53: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

49: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
50: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
51: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 54: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

50: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
51: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

Line 55: QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

51: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
59: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 56: QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

52: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
59: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 57: OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

53: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
59: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: QUOTE_OBJECT_CODE NUMBER := FND_API.G_MISS_NUM

Line 58: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

54: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
55: QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
59: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: QUOTE_OBJECT_CODE NUMBER := FND_API.G_MISS_NUM
62: );

Line 59: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

55: QUOTE_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
59: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: QUOTE_OBJECT_CODE NUMBER := FND_API.G_MISS_NUM
62: );
63:

Line 60: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

56: QUOTE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
57: OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
59: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: QUOTE_OBJECT_CODE NUMBER := FND_API.G_MISS_NUM
62: );
63:
64: G_MISS_RELATED_OBJ_REC RELATED_OBJ_Rec_Type;

Line 61: QUOTE_OBJECT_CODE NUMBER := FND_API.G_MISS_NUM

57: OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
59: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
61: QUOTE_OBJECT_CODE NUMBER := FND_API.G_MISS_NUM
62: );
63:
64: G_MISS_RELATED_OBJ_REC RELATED_OBJ_Rec_Type;
65: TYPE RELATED_OBJ_Tbl_Type IS TABLE OF RELATED_OBJ_Rec_Type

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

75: -- Pre-Req :
76: -- Parameters:
77: -- IN
78: -- p_api_version_number IN NUMBER Required
79: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82: -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
83: --

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

76: -- Parameters:
77: -- IN
78: -- p_api_version_number IN NUMBER Required
79: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82: -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
83: --
84: -- OUT:

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

77: -- IN
78: -- p_api_version_number IN NUMBER Required
79: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82: -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
83: --
84: -- OUT:
85: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

92: -- End of Comments
93: --
94: PROCEDURE Create_related_obj(
95: P_Api_Version_Number IN NUMBER,
96: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
97: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: P_RELATED_OBJ_Rec IN ASO_quote_PUB.RELATED_OBJ_Rec_Type := ASO_quote_PUB.G_MISS_RELATED_OBJ_REC,
100: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

93: --
94: PROCEDURE Create_related_obj(
95: P_Api_Version_Number IN NUMBER,
96: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
97: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: P_RELATED_OBJ_Rec IN ASO_quote_PUB.RELATED_OBJ_Rec_Type := ASO_quote_PUB.G_MISS_RELATED_OBJ_REC,
100: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
101: X_RELATED_OBJECT_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

94: PROCEDURE Create_related_obj(
95: P_Api_Version_Number IN NUMBER,
96: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
97: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: P_RELATED_OBJ_Rec IN ASO_quote_PUB.RELATED_OBJ_Rec_Type := ASO_quote_PUB.G_MISS_RELATED_OBJ_REC,
100: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
101: X_RELATED_OBJECT_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
102: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

112: -- Pre-Req :
113: -- Parameters:
114: -- IN
115: -- p_api_version_number IN NUMBER Required
116: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
119: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
120: -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required

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

113: -- Parameters:
114: -- IN
115: -- p_api_version_number IN NUMBER Required
116: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
119: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
120: -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
121: --

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

114: -- IN
115: -- p_api_version_number IN NUMBER Required
116: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
117: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
118: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
119: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
120: -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
121: --
122: -- OUT:

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

131: --
132: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
133: PROCEDURE Update_related_obj(
134: P_Api_Version_Number IN NUMBER,
135: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138: -- P_Identity_Salesforce_Id IN NUMBER := NULL,
139: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,

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

132: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
133: PROCEDURE Update_related_obj(
134: P_Api_Version_Number IN NUMBER,
135: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138: -- P_Identity_Salesforce_Id IN NUMBER := NULL,
139: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
140: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

133: PROCEDURE Update_related_obj(
134: P_Api_Version_Number IN NUMBER,
135: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138: -- P_Identity_Salesforce_Id IN NUMBER := NULL,
139: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
140: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
141: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

150: -- Pre-Req :
151: -- Parameters:
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
158: -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required

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

151: -- Parameters:
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
158: -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
159: --

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

152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
158: -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
159: --
160: -- OUT:

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

170: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
171: -- The Master delete procedure may not be needed depends on different business requirements.
172: PROCEDURE Delete_related_obj(
173: P_Api_Version_Number IN NUMBER,
174: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
175: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: -- P_identity_salesforce_id IN NUMBER := NULL,
178: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,

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

171: -- The Master delete procedure may not be needed depends on different business requirements.
172: PROCEDURE Delete_related_obj(
173: P_Api_Version_Number IN NUMBER,
174: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
175: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: -- P_identity_salesforce_id IN NUMBER := NULL,
178: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
179: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

172: PROCEDURE Delete_related_obj(
173: P_Api_Version_Number IN NUMBER,
174: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
175: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: -- P_identity_salesforce_id IN NUMBER := NULL,
178: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
179: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
180: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

189: -- Pre-Req :
190: -- Parameters:
191: -- IN
192: -- p_api_version_number IN NUMBER Required
193: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
194: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
195: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
196: -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
197: -- Hint: Add List of bind variables here

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

190: -- Parameters:
191: -- IN
192: -- p_api_version_number IN NUMBER Required
193: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
194: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
195: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
196: -- P_RELATED_OBJ_Rec IN RELATED_OBJ_Rec_Type Required
197: -- Hint: Add List of bind variables here
198: -- p_rec_requested IN NUMBER Optional Default = 30

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

200: --
201: -- Return Total Records Count Flag. This flag controls whether the total record count
202: -- and total record amount is returned.
203: --
204: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
205: -- Hint: User defined record type
206: -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
207: --
208: -- OUT:

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

234: --
235: -- End of Comments
236:
237: PROCEDURE Validate_RELATED_OBJECT_ID (
238: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
239: P_Validation_mode IN VARCHAR2,
240: P_RELATED_OBJECT_ID IN NUMBER,
241: -- Hint: You may add 'X_Item_Property_Rec OUT NOCOPY /* file.sql.39 change */ AS_UTILITY_PVT.ITEM_PROPERTY_REC_TYPE' here if you'd like to pass back item property.
242: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

255: --
256: -- End of Comments
257:
258: PROCEDURE Validate_REQUEST_ID (
259: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
260: P_Validation_mode IN VARCHAR2,
261: P_REQUEST_ID IN NUMBER,
262: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
263: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

275: --
276: -- End of Comments
277:
278: PROCEDURE Validate_PROGRAM_APPL_ID (
279: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
280: P_Validation_mode IN VARCHAR2,
281: P_PROGRAM_APPLICATION_ID IN NUMBER,
282: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
283: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

295: --
296: -- End of Comments
297:
298: PROCEDURE Validate_PROGRAM_ID (
299: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
300: P_Validation_mode IN VARCHAR2,
301: P_PROGRAM_ID IN NUMBER,
302: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
303: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

315: --
316: -- End of Comments
317:
318: PROCEDURE Validate_PROGRAM_UPDATE_DATE (
319: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
320: P_Validation_mode IN VARCHAR2,
321: P_PROGRAM_UPDATE_DATE IN DATE,
322: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
323: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

335: --
336: -- End of Comments
337:
338: PROCEDURE Validate_QTE_OBJ_TYPE_CODE (
339: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
340: P_Validation_mode IN VARCHAR2,
341: P_QUOTE_OBJECT_TYPE_CODE IN VARCHAR2,
342: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
343: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

355: --
356: -- End of Comments
357:
358: PROCEDURE Validate_QUOTE_OBJECT_ID (
359: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
360: P_Validation_mode IN VARCHAR2,
361: P_QUOTE_OBJECT_ID IN NUMBER,
362: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
363: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

375: --
376: -- End of Comments
377:
378: PROCEDURE Validate_OBJECT_TYPE_CODE (
379: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
380: P_Validation_mode IN VARCHAR2,
381: P_OBJECT_TYPE_CODE IN VARCHAR2,
382: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
383: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

395: --
396: -- End of Comments
397:
398: PROCEDURE Validate_OBJECT_ID (
399: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
400: P_Validation_mode IN VARCHAR2,
401: P_OBJECT_ID IN NUMBER,
402: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
403: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

415: --
416: -- End of Comments
417:
418: PROCEDURE Validate_RLTSHIP_TYPE_CODE (
419: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
420: P_Validation_mode IN VARCHAR2,
421: P_RELATIONSHIP_TYPE_CODE IN VARCHAR2,
422: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
423: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

435: --
436: -- End of Comments
437:
438: PROCEDURE Validate_RECIPROCAL_FLAG (
439: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
440: P_Validation_mode IN VARCHAR2,
441: P_RECIPROCAL_FLAG IN VARCHAR2,
442: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
443: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

455: --
456: -- End of Comments
457:
458: PROCEDURE Validate_QUOTE_OBJECT_CODE (
459: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
460: P_Validation_mode IN VARCHAR2,
461: P_QUOTE_OBJECT_CODE IN NUMBER,
462: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
463: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

475: -- 2. Developer can manually added inter-field level validation.
476: -- End of Comments
477:
478: PROCEDURE Validate_RELATED_OBJ_rec(
479: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
480: P_Validation_mode IN VARCHAR2,
481: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
482: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
483: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

495: -- 2. We can also validate table instead of record. There will be an option for user to choose.
496: -- End of Comments
497:
498: PROCEDURE Validate_related_obj(
499: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
500: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
501: P_Validation_mode IN VARCHAR2,
502: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
503: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

496: -- End of Comments
497:
498: PROCEDURE Validate_related_obj(
499: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
500: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
501: P_Validation_mode IN VARCHAR2,
502: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
503: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
504: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,