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.OZF_OFFER_BACK_CREATE_PVT dependencies on FND_API

Line 51: offer_adjustment_line_id NUMBER := FND_API.G_MISS_NUM,

47:
48: --===================================================================
49: TYPE offer_back_create_rec_type IS RECORD
50: (
51: offer_adjustment_line_id NUMBER := FND_API.G_MISS_NUM,
52: offer_adjustment_id NUMBER := FND_API.G_MISS_NUM,
53: list_line_id NUMBER := FND_API.G_MISS_NUM,
54: arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: original_discount NUMBER := FND_API.G_MISS_NUM,

Line 52: offer_adjustment_id NUMBER := FND_API.G_MISS_NUM,

48: --===================================================================
49: TYPE offer_back_create_rec_type IS RECORD
50: (
51: offer_adjustment_line_id NUMBER := FND_API.G_MISS_NUM,
52: offer_adjustment_id NUMBER := FND_API.G_MISS_NUM,
53: list_line_id NUMBER := FND_API.G_MISS_NUM,
54: arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: original_discount NUMBER := FND_API.G_MISS_NUM,
56: modified_discount NUMBER := FND_API.G_MISS_NUM,

Line 53: list_line_id NUMBER := FND_API.G_MISS_NUM,

49: TYPE offer_back_create_rec_type IS RECORD
50: (
51: offer_adjustment_line_id NUMBER := FND_API.G_MISS_NUM,
52: offer_adjustment_id NUMBER := FND_API.G_MISS_NUM,
53: list_line_id NUMBER := FND_API.G_MISS_NUM,
54: arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: original_discount NUMBER := FND_API.G_MISS_NUM,
56: modified_discount NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,

Line 54: arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,

50: (
51: offer_adjustment_line_id NUMBER := FND_API.G_MISS_NUM,
52: offer_adjustment_id NUMBER := FND_API.G_MISS_NUM,
53: list_line_id NUMBER := FND_API.G_MISS_NUM,
54: arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: original_discount NUMBER := FND_API.G_MISS_NUM,
56: modified_discount NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 55: original_discount NUMBER := FND_API.G_MISS_NUM,

51: offer_adjustment_line_id NUMBER := FND_API.G_MISS_NUM,
52: offer_adjustment_id NUMBER := FND_API.G_MISS_NUM,
53: list_line_id NUMBER := FND_API.G_MISS_NUM,
54: arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: original_discount NUMBER := FND_API.G_MISS_NUM,
56: modified_discount NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,

Line 56: modified_discount NUMBER := FND_API.G_MISS_NUM,

52: offer_adjustment_id NUMBER := FND_API.G_MISS_NUM,
53: list_line_id NUMBER := FND_API.G_MISS_NUM,
54: arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: original_discount NUMBER := FND_API.G_MISS_NUM,
56: modified_discount NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,

Line 57: last_update_date DATE := FND_API.G_MISS_DATE,

53: list_line_id NUMBER := FND_API.G_MISS_NUM,
54: arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: original_discount NUMBER := FND_API.G_MISS_NUM,
56: modified_discount NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 58: last_updated_by NUMBER := FND_API.G_MISS_NUM,

54: arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR,
55: original_discount NUMBER := FND_API.G_MISS_NUM,
56: modified_discount NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 59: creation_date DATE := FND_API.G_MISS_DATE,

55: original_discount NUMBER := FND_API.G_MISS_NUM,
56: modified_discount NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: security_group_id NUMBER := FND_API.G_MISS_NUM

Line 60: created_by NUMBER := FND_API.G_MISS_NUM,

56: modified_discount NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: security_group_id NUMBER := FND_API.G_MISS_NUM
64: );

Line 61: last_update_login NUMBER := FND_API.G_MISS_NUM,

57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: security_group_id NUMBER := FND_API.G_MISS_NUM
64: );
65:

Line 62: object_version_number NUMBER := FND_API.G_MISS_NUM,

58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: security_group_id NUMBER := FND_API.G_MISS_NUM
64: );
65:
66: g_miss_offer_back_create_rec offer_back_create_rec_type;

Line 63: security_group_id NUMBER := FND_API.G_MISS_NUM

59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: security_group_id NUMBER := FND_API.G_MISS_NUM
64: );
65:
66: g_miss_offer_back_create_rec offer_back_create_rec_type;
67: TYPE offer_back_create_tbl_type IS TABLE OF offer_back_create_rec_type INDEX BY BINARY_INTEGER;

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

79: -- Parameters
80: --
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_offer_back_create_rec IN offer_back_create_rec_type Required
87: --

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

80: --
81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_offer_back_create_rec IN offer_back_create_rec_type Required
87: --
88: -- OUT

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

81: -- IN
82: -- p_api_version_number IN NUMBER Required
83: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
84: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
85: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
86: -- p_offer_back_create_rec IN offer_back_create_rec_type Required
87: --
88: -- OUT
89: -- x_return_status OUT VARCHAR2

Line 102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

98: --
99:
100: PROCEDURE Create_Offer_Back(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105:
106: x_return_status OUT NOCOPY VARCHAR2,

Line 103: p_commit IN VARCHAR2 := FND_API.G_FALSE,

99:
100: PROCEDURE Create_Offer_Back(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105:
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,

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

100: PROCEDURE Create_Offer_Back(
101: p_api_version_number IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105:
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,

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

123: -- Parameters
124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_offer_back_create_rec IN offer_back_create_rec_type Required
131: --

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

124: --
125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_offer_back_create_rec IN offer_back_create_rec_type Required
131: --
132: -- OUT

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

125: -- IN
126: -- p_api_version_number IN NUMBER Required
127: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
128: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
129: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
130: -- p_offer_back_create_rec IN offer_back_create_rec_type Required
131: --
132: -- OUT
133: -- x_return_status OUT VARCHAR2

Line 146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

142: --
143:
144: PROCEDURE Update_Offer_Back(
145: p_api_version_number IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149:
150: x_return_status OUT NOCOPY VARCHAR2,

Line 147: p_commit IN VARCHAR2 := FND_API.G_FALSE,

143:
144: PROCEDURE Update_Offer_Back(
145: p_api_version_number IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149:
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,

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

144: PROCEDURE Update_Offer_Back(
145: p_api_version_number IN NUMBER,
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149:
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,

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

167: -- Parameters
168: --
169: -- IN
170: -- p_api_version_number IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_OFFER_ADJUSTMENT_LINE_ID IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL

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

168: --
169: -- IN
170: -- p_api_version_number IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_OFFER_ADJUSTMENT_LINE_ID IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL
176: --

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

169: -- IN
170: -- p_api_version_number IN NUMBER Required
171: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
172: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174: -- p_OFFER_ADJUSTMENT_LINE_ID IN NUMBER
175: -- p_object_version_number IN NUMBER Optional Default = NULL
176: --
177: -- OUT

Line 191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

187: --
188:
189: PROCEDURE Delete_Offer_Back(
190: p_api_version_number IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,

Line 192: p_commit IN VARCHAR2 := FND_API.G_FALSE,

188:
189: PROCEDURE Delete_Offer_Back(
190: p_api_version_number IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,

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

189: PROCEDURE Delete_Offer_Back(
190: p_api_version_number IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_offer_adjustment_line_id IN NUMBER,

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

210: -- Parameters
211: --
212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_offer_back_create_rec IN offer_back_create_rec_type Required
218: --

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

211: --
212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_offer_back_create_rec IN offer_back_create_rec_type Required
218: --
219: -- OUT

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

212: -- IN
213: -- p_api_version_number IN NUMBER Required
214: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
215: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
216: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
217: -- p_offer_back_create_rec IN offer_back_create_rec_type Required
218: --
219: -- OUT
220: -- x_return_status OUT VARCHAR2

Line 233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

229: --
230:
231: PROCEDURE Lock_Offer_Back(
232: p_api_version_number IN NUMBER,
233: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234:
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,
237: x_msg_data OUT NOCOPY VARCHAR2,

Line 257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

253: -- End of Comments
254:
255: PROCEDURE Validate_offer_back(
256: p_api_version_number IN NUMBER,
257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: p_offer_back_create_rec IN offer_back_create_rec_type,
260: p_validation_mode IN VARCHAR2,
261: x_return_status OUT NOCOPY VARCHAR2,

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

254:
255: PROCEDURE Validate_offer_back(
256: p_api_version_number IN NUMBER,
257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: p_offer_back_create_rec IN offer_back_create_rec_type,
260: p_validation_mode IN VARCHAR2,
261: x_return_status OUT NOCOPY VARCHAR2,
262: x_msg_count OUT NOCOPY NUMBER,

Line 296: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

292: -- End of Comments
293:
294: PROCEDURE Validate_offer_back_rec(
295: p_api_version_number IN NUMBER,
296: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
297: x_return_status OUT NOCOPY VARCHAR2,
298: x_msg_count OUT NOCOPY NUMBER,
299: x_msg_data OUT NOCOPY VARCHAR2,
300: p_offer_back_create_rec IN offer_back_create_rec_type