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_LINE_ATTRIBS_PVT dependencies on FND_API

Line 44: LINE_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 45: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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

Line 46: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

42: TYPE LINE_ATTRIBS_Rec_Type IS RECORD
43: (
44: LINE_ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
45: CREATION_DATE DATE := FND_API.G_MISS_DATE,
46: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
49: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
50: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

Line 47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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

Line 48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

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

Line 49: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

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

Line 50: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 51: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 52: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 53: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

49: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
50: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
51: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
54: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: ATTRIBUTE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 54: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,

50: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
51: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
54: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: ATTRIBUTE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
58: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,

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

51: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
54: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: ATTRIBUTE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
58: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
59: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE

Line 56: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,

52: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
54: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: ATTRIBUTE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
58: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
59: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
60: );

Line 57: VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR,

53: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
54: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: ATTRIBUTE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
58: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
59: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
60: );
61:

Line 58: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,

54: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: ATTRIBUTE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
58: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
59: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
60: );
61:
62: G_MISS_LINE_ATTRIBS_REC ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type;

Line 59: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE

55: ATTRIBUTE_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
58: START_DATE_ACTIVE DATE := FND_API.G_MISS_DATE,
59: END_DATE_ACTIVE DATE := FND_API.G_MISS_DATE
60: );
61:
62: G_MISS_LINE_ATTRIBS_REC ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type;
63: TYPE LINE_ATTRIBS_Tbl_Type IS TABLE OF LINE_ATTRIBS_Rec_Type

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

72: -- Pre-Req :
73: -- Parameters:
74: -- IN
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
79: -- P_LINE_ATTRIBS_Rec IN LINE_ATTRIBS_Rec_Type Required
80: --

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

73: -- Parameters:
74: -- IN
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
79: -- P_LINE_ATTRIBS_Rec IN LINE_ATTRIBS_Rec_Type Required
80: --
81: -- OUT:

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

74: -- IN
75: -- p_api_version_number IN NUMBER Required
76: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
79: -- P_LINE_ATTRIBS_Rec IN LINE_ATTRIBS_Rec_Type Required
80: --
81: -- OUT:
82: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

89: -- End of Comments
90: --
91: PROCEDURE Create_line_attribs(
92: P_Api_Version_Number IN NUMBER,
93: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type := ASO_quote_PUB.G_MISS_LINE_ATTRIBS_EXT_REC,
97: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

90: --
91: PROCEDURE Create_line_attribs(
92: P_Api_Version_Number IN NUMBER,
93: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type := ASO_quote_PUB.G_MISS_LINE_ATTRIBS_EXT_REC,
97: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
98: X_LINE_ATTRIB_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

91: PROCEDURE Create_line_attribs(
92: P_Api_Version_Number IN NUMBER,
93: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type := ASO_quote_PUB.G_MISS_LINE_ATTRIBS_EXT_REC,
97: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
98: X_LINE_ATTRIB_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
99: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

109: -- Pre-Req :
110: -- Parameters:
111: -- IN
112: -- p_api_version_number IN NUMBER Required
113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
117: -- P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type Required

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

110: -- Parameters:
111: -- IN
112: -- p_api_version_number IN NUMBER Required
113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
117: -- P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type Required
118: --

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

111: -- IN
112: -- p_api_version_number IN NUMBER Required
113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
115: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
116: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
117: -- P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type Required
118: --
119: -- OUT:

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

128: --
129: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
130: PROCEDURE Update_line_attribs(
131: P_Api_Version_Number IN NUMBER,
132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: -- P_Identity_Salesforce_Id IN NUMBER := NULL,
136: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,

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

129: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
130: PROCEDURE Update_line_attribs(
131: P_Api_Version_Number IN NUMBER,
132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: -- P_Identity_Salesforce_Id IN NUMBER := NULL,
136: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,
137: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

130: PROCEDURE Update_line_attribs(
131: P_Api_Version_Number IN NUMBER,
132: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
133: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: -- P_Identity_Salesforce_Id IN NUMBER := NULL,
136: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,
137: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
138: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

147: -- Pre-Req :
148: -- Parameters:
149: -- IN
150: -- p_api_version_number IN NUMBER Required
151: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
152: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
153: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
154: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
155: -- P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type Required

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

148: -- Parameters:
149: -- IN
150: -- p_api_version_number IN NUMBER Required
151: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
152: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
153: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
154: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
155: -- P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type Required
156: --

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

149: -- IN
150: -- p_api_version_number IN NUMBER Required
151: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
152: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
153: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
154: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
155: -- P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type Required
156: --
157: -- OUT:

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

167: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
168: -- The Master delete procedure may not be needed depends on different business requirements.
169: PROCEDURE Delete_line_attribs(
170: P_Api_Version_Number IN NUMBER,
171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: -- P_identity_salesforce_id IN NUMBER := NULL,
175: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,

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

168: -- The Master delete procedure may not be needed depends on different business requirements.
169: PROCEDURE Delete_line_attribs(
170: P_Api_Version_Number IN NUMBER,
171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: -- P_identity_salesforce_id IN NUMBER := NULL,
175: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,
176: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

169: PROCEDURE Delete_line_attribs(
170: P_Api_Version_Number IN NUMBER,
171: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
172: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174: -- P_identity_salesforce_id IN NUMBER := NULL,
175: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,
176: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
177: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

192: --
193: -- End of Comments
194:
195: PROCEDURE Validate_LINE_ATTRIBUTE_ID (
196: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
197: P_Validation_mode IN VARCHAR2,
198: P_LINE_ATTRIBUTE_ID IN NUMBER,
199: -- 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.
200: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

213: --
214: -- End of Comments
215:
216: PROCEDURE Validate_REQUEST_ID (
217: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
218: P_Validation_mode IN VARCHAR2,
219: P_REQUEST_ID IN NUMBER,
220: -- 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.
221: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

234: --
235: -- End of Comments
236:
237: PROCEDURE Validate_PROG_APPL_ID (
238: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
239: P_Validation_mode IN VARCHAR2,
240: P_PROGRAM_APPLICATION_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_PROGRAM_ID (
259: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
260: P_Validation_mode IN VARCHAR2,
261: P_PROGRAM_ID IN NUMBER,
262: -- 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.
263: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

276: --
277: -- End of Comments
278:
279: PROCEDURE Validate_PROGRAM_UPDATE_DATE (
280: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
281: P_Validation_mode IN VARCHAR2,
282: P_PROGRAM_UPDATE_DATE IN DATE,
283: -- 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.
284: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

297: --
298: -- End of Comments
299:
300: PROCEDURE Validate_QUOTE_LINE_ID (
301: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
302: P_Validation_mode IN VARCHAR2,
303: P_QUOTE_LINE_ID IN NUMBER,
304: -- 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.
305: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

308: );
309:
310:
311: PROCEDURE Validate_ATTRIBUTE_TYPE_CODE(
312: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
313: P_Validation_mode IN VARCHAR2,
314: P_ATTRIBUTE_TYPE_CODE IN VARCHAR2,
315: -- 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.
316: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

318: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
319:
320:
321: PROCEDURE Validate_STATUS(
322: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
323: P_Validation_mode IN VARCHAR2,
324: P_STATUS IN VARCHAR2,
325: -- 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.
326: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

341: --
342: -- End of Comments
343:
344: PROCEDURE Validate_NAME (
345: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346: P_Validation_mode IN VARCHAR2,
347: P_NAME IN VARCHAR2,
348: -- 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.
349: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

362: --
363: -- End of Comments
364:
365: PROCEDURE Validate_VALUE (
366: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
367: P_Validation_mode IN VARCHAR2,
368: P_VALUE IN VARCHAR2,
369: -- 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.
370: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

383: --
384: -- End of Comments
385:
386: PROCEDURE Validate_START_DATE_ACTIVE (
387: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
388: P_Validation_mode IN VARCHAR2,
389: P_START_DATE_ACTIVE IN DATE,
390: -- 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.
391: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

404: --
405: -- End of Comments
406:
407: PROCEDURE Validate_END_DATE_ACTIVE (
408: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
409: P_Validation_mode IN VARCHAR2,
410: P_END_DATE_ACTIVE IN DATE,
411: -- 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.
412: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

425: -- 2. Developer can manually added inter-field level validation.
426: -- End of Comments
427:
428: PROCEDURE Validate_LINE_ATTRIBS_rec(
429: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
430: P_Validation_mode IN VARCHAR2,
431: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,
432: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
433: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

445: -- 2. We can also validate table instead of record. There will be an option for user to choose.
446: -- End of Comments
447:
448: PROCEDURE Validate_line_attribs(
449: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
450: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
451: P_Validation_mode IN VARCHAR2,
452: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,
453: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

446: -- End of Comments
447:
448: PROCEDURE Validate_line_attribs(
449: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
450: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
451: P_Validation_mode IN VARCHAR2,
452: P_LINE_ATTRIBS_Rec IN ASO_quote_PUB.LINE_ATTRIBS_EXT_rec_type,
453: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
454: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,