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

Line 43: LINE_RELATIONSHIP_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 44: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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

Line 45: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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

Line 46: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

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

Line 47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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

Line 48: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

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

Line 49: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 50: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 51: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 52: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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

Line 53: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,

49: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
50: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
51: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: RELATED_QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: RELATIONAL_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
57: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 54: RELATED_QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,

50: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
51: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: RELATED_QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: RELATIONAL_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
57: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
58: );

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

51: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
52: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: RELATED_QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: RELATIONAL_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
57: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
58: );
59:

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

52: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
53: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: RELATED_QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: RELATIONAL_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
57: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
58: );
59:
60: G_MISS_LINE_RLTSHIP_REC LINE_RLTSHIP_Rec_Type;

Line 57: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR

53: QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
54: RELATED_QUOTE_LINE_ID NUMBER := FND_API.G_MISS_NUM,
55: RELATIONAL_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
57: RELATIONSHIP_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
58: );
59:
60: G_MISS_LINE_RLTSHIP_REC LINE_RLTSHIP_Rec_Type;
61: TYPE LINE_RLTSHIP_Tbl_Type IS TABLE OF LINE_RLTSHIP_Rec_Type

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

70: -- Pre-Req :
71: -- Parameters:
72: -- IN
73: -- p_api_version_number IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
75: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
76: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
77: -- P_LINE_RLTSHIP_Rec IN LINE_RLTSHIP_Rec_Type Required
78: --

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

71: -- Parameters:
72: -- IN
73: -- p_api_version_number IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
75: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
76: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
77: -- P_LINE_RLTSHIP_Rec IN LINE_RLTSHIP_Rec_Type Required
78: --
79: -- OUT:

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

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

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

87: -- End of Comments
88: --
89: PROCEDURE Create_line_rltship(
90: P_Api_Version_Number IN NUMBER,
91: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
92: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC,
95: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

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

88: --
89: PROCEDURE Create_line_rltship(
90: P_Api_Version_Number IN NUMBER,
91: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
92: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC,
95: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
96: X_LINE_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

89: PROCEDURE Create_line_rltship(
90: P_Api_Version_Number IN NUMBER,
91: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
92: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
93: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type := ASO_QUOTE_PUB.G_MISS_LINE_RLTSHIP_REC,
95: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
96: X_LINE_RELATIONSHIP_ID OUT NOCOPY /* file.sql.39 change */ NUMBER,
97: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

107: -- Pre-Req :
108: -- Parameters:
109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
115: -- P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type Required

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

108: -- Parameters:
109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
115: -- P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type Required
116: --

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

109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
115: -- P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type Required
116: --
117: -- OUT:

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

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

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

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

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

128: PROCEDURE Update_line_rltship(
129: P_Api_Version_Number IN NUMBER,
130: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
131: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
132: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: -- P_Identity_Salesforce_Id IN NUMBER := NULL,
134: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
135: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
136: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

145: -- Pre-Req :
146: -- Parameters:
147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
153: -- P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type Required

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

146: -- Parameters:
147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
153: -- P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type Required
154: --

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

147: -- IN
148: -- p_api_version_number IN NUMBER Required
149: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
150: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
152: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
153: -- P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type Required
154: --
155: -- OUT:

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

165: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
166: -- The Master delete procedure may not be needed depends on different business requirements.
167: PROCEDURE Delete_line_rltship(
168: P_Api_Version_Number IN NUMBER,
169: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
170: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
173: -- P_identity_salesforce_id IN NUMBER := NULL,

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

166: -- The Master delete procedure may not be needed depends on different business requirements.
167: PROCEDURE Delete_line_rltship(
168: P_Api_Version_Number IN NUMBER,
169: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
170: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
173: -- P_identity_salesforce_id IN NUMBER := NULL,
174: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,

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

167: PROCEDURE Delete_line_rltship(
168: P_Api_Version_Number IN NUMBER,
169: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
170: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
173: -- P_identity_salesforce_id IN NUMBER := NULL,
174: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
175: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

185: -- Pre-Req :
186: -- Parameters:
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
191: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
192: -- P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type Required
193: -- Hint: Add List of bind variables here

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

186: -- Parameters:
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
191: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
192: -- P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type Required
193: -- Hint: Add List of bind variables here
194: -- p_rec_requested IN NUMBER Optional Default = 30

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

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

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

228: --
229: -- End of Comments
230:
231: PROCEDURE Validate_LINE_RELATIONSHIP_ID (
232: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
233: P_Validation_mode IN VARCHAR2,
234: P_LINE_RELATIONSHIP_ID IN NUMBER,
235: -- 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.
236: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

249: --
250: -- End of Comments
251:
252: PROCEDURE Validate_REQUEST_ID (
253: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
254: P_Validation_mode IN VARCHAR2,
255: P_REQUEST_ID IN NUMBER,
256: -- 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.
257: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

270: --
271: -- End of Comments
272:
273: PROCEDURE Validate_PROG_APPL_ID (
274: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
275: P_Validation_mode IN VARCHAR2,
276: P_PROGRAM_APPLICATION_ID IN NUMBER,
277: -- 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.
278: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

291: --
292: -- End of Comments
293:
294: PROCEDURE Validate_PROGRAM_ID (
295: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
296: P_Validation_mode IN VARCHAR2,
297: P_PROGRAM_ID IN NUMBER,
298: -- 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.
299: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

312: --
313: -- End of Comments
314:
315: PROCEDURE Validate_PROGRAM_UPDATE_DATE (
316: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
317: P_Validation_mode IN VARCHAR2,
318: P_PROGRAM_UPDATE_DATE IN DATE,
319: -- 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.
320: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

333: --
334: -- End of Comments
335:
336: PROCEDURE Validate_QUOTE_LINE_ID (
337: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
338: P_Validation_mode IN VARCHAR2,
339: P_QUOTE_LINE_ID IN NUMBER,
340: -- 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.
341: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

354: --
355: -- End of Comments
356:
357: PROCEDURE Validate_RELATED_QUOTE_LINE_ID (
358: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
359: P_Validation_mode IN VARCHAR2,
360: P_RELATED_QUOTE_LINE_ID IN NUMBER,
361: -- 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.
362: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

375: --
376: -- End of Comments
377:
378: PROCEDURE Validate_RELATIONAL_TYPE_CODE (
379: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
380: P_Validation_mode IN VARCHAR2,
381: P_RELATIONAL_TYPE_CODE IN VARCHAR2,
382: -- 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.
383: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

396: --
397: -- End of Comments
398:
399: PROCEDURE Validate_RECIPROCAL_FLAG (
400: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
401: P_Validation_mode IN VARCHAR2,
402: P_RECIPROCAL_FLAG IN VARCHAR2,
403: -- 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.
404: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

417: --
418: -- End of Comments
419:
420: PROCEDURE Validate_RLTSHIP_TYPE_CODE (
421: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
422: P_Validation_mode IN VARCHAR2,
423: P_RELATIONSHIP_TYPE_CODE IN VARCHAR2,
424: -- 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.
425: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

438: -- 2. Developer can manually added inter-field level validation.
439: -- End of Comments
440:
441: PROCEDURE Validate_LINE_RLTSHIP_rec(
442: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
443: P_Validation_mode IN VARCHAR2,
444: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
445: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
446: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

458: -- 2. We can also validate table instead of record. There will be an option for user to choose.
459: -- End of Comments
460:
461: PROCEDURE Validate_line_rltship(
462: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
463: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: P_Validation_mode IN VARCHAR2,
465: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
466: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

459: -- End of Comments
460:
461: PROCEDURE Validate_line_rltship(
462: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
463: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
464: P_Validation_mode IN VARCHAR2,
465: P_LINE_RLTSHIP_Rec IN ASO_quote_PUB.LINE_RLTSHIP_Rec_Type,
466: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
467: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,