73: last_update_login,
74: object_version_number,
75: security_group_id
76: ) VALUES (
77: DECODE( px_offer_adjustment_line_id, FND_API.g_miss_num, NULL, px_offer_adjustment_line_id),
78: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
79: DECODE( p_list_line_id, FND_API.g_miss_num, NULL, p_list_line_id),
80: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
81: DECODE( p_original_discount, FND_API.g_miss_num, NULL, p_original_discount),
74: object_version_number,
75: security_group_id
76: ) VALUES (
77: DECODE( px_offer_adjustment_line_id, FND_API.g_miss_num, NULL, px_offer_adjustment_line_id),
78: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
79: DECODE( p_list_line_id, FND_API.g_miss_num, NULL, p_list_line_id),
80: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
81: DECODE( p_original_discount, FND_API.g_miss_num, NULL, p_original_discount),
82: DECODE( p_modified_discount, FND_API.g_miss_num, NULL, p_modified_discount),
75: security_group_id
76: ) VALUES (
77: DECODE( px_offer_adjustment_line_id, FND_API.g_miss_num, NULL, px_offer_adjustment_line_id),
78: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
79: DECODE( p_list_line_id, FND_API.g_miss_num, NULL, p_list_line_id),
80: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
81: DECODE( p_original_discount, FND_API.g_miss_num, NULL, p_original_discount),
82: DECODE( p_modified_discount, FND_API.g_miss_num, NULL, p_modified_discount),
83: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
76: ) VALUES (
77: DECODE( px_offer_adjustment_line_id, FND_API.g_miss_num, NULL, px_offer_adjustment_line_id),
78: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
79: DECODE( p_list_line_id, FND_API.g_miss_num, NULL, p_list_line_id),
80: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
81: DECODE( p_original_discount, FND_API.g_miss_num, NULL, p_original_discount),
82: DECODE( p_modified_discount, FND_API.g_miss_num, NULL, p_modified_discount),
83: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
77: DECODE( px_offer_adjustment_line_id, FND_API.g_miss_num, NULL, px_offer_adjustment_line_id),
78: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
79: DECODE( p_list_line_id, FND_API.g_miss_num, NULL, p_list_line_id),
80: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
81: DECODE( p_original_discount, FND_API.g_miss_num, NULL, p_original_discount),
82: DECODE( p_modified_discount, FND_API.g_miss_num, NULL, p_modified_discount),
83: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
78: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
79: DECODE( p_list_line_id, FND_API.g_miss_num, NULL, p_list_line_id),
80: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
81: DECODE( p_original_discount, FND_API.g_miss_num, NULL, p_original_discount),
82: DECODE( p_modified_discount, FND_API.g_miss_num, NULL, p_modified_discount),
83: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
79: DECODE( p_list_line_id, FND_API.g_miss_num, NULL, p_list_line_id),
80: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
81: DECODE( p_original_discount, FND_API.g_miss_num, NULL, p_original_discount),
82: DECODE( p_modified_discount, FND_API.g_miss_num, NULL, p_modified_discount),
83: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
80: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
81: DECODE( p_original_discount, FND_API.g_miss_num, NULL, p_original_discount),
82: DECODE( p_modified_discount, FND_API.g_miss_num, NULL, p_modified_discount),
83: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
81: DECODE( p_original_discount, FND_API.g_miss_num, NULL, p_original_discount),
82: DECODE( p_modified_discount, FND_API.g_miss_num, NULL, p_modified_discount),
83: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
82: DECODE( p_modified_discount, FND_API.g_miss_num, NULL, p_modified_discount),
83: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
90: END Insert_Row;
83: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
90: END Insert_Row;
91:
84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
90: END Insert_Row;
91:
92:
85: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
90: END Insert_Row;
91:
92:
93: ----------------------------------------------------------
122: IS
123: BEGIN
124: Update OZF_OFFER_ADJUSTMENT_LINES
125: SET
126: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, FND_API.g_miss_num, offer_adjustment_line_id, p_offer_adjustment_line_id),
127: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
128: list_line_id = DECODE( p_list_line_id, FND_API.g_miss_num, list_line_id, p_list_line_id),
129: arithmetic_operator = DECODE( p_arithmetic_operator, FND_API.g_miss_char, arithmetic_operator, p_arithmetic_operator),
130: original_discount = DECODE( p_original_discount, FND_API.g_miss_num, original_discount, p_original_discount),
123: BEGIN
124: Update OZF_OFFER_ADJUSTMENT_LINES
125: SET
126: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, FND_API.g_miss_num, offer_adjustment_line_id, p_offer_adjustment_line_id),
127: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
128: list_line_id = DECODE( p_list_line_id, FND_API.g_miss_num, list_line_id, p_list_line_id),
129: arithmetic_operator = DECODE( p_arithmetic_operator, FND_API.g_miss_char, arithmetic_operator, p_arithmetic_operator),
130: original_discount = DECODE( p_original_discount, FND_API.g_miss_num, original_discount, p_original_discount),
131: modified_discount = DECODE( p_modified_discount, FND_API.g_miss_num, modified_discount, p_modified_discount),
124: Update OZF_OFFER_ADJUSTMENT_LINES
125: SET
126: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, FND_API.g_miss_num, offer_adjustment_line_id, p_offer_adjustment_line_id),
127: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
128: list_line_id = DECODE( p_list_line_id, FND_API.g_miss_num, list_line_id, p_list_line_id),
129: arithmetic_operator = DECODE( p_arithmetic_operator, FND_API.g_miss_char, arithmetic_operator, p_arithmetic_operator),
130: original_discount = DECODE( p_original_discount, FND_API.g_miss_num, original_discount, p_original_discount),
131: modified_discount = DECODE( p_modified_discount, FND_API.g_miss_num, modified_discount, p_modified_discount),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
125: SET
126: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, FND_API.g_miss_num, offer_adjustment_line_id, p_offer_adjustment_line_id),
127: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
128: list_line_id = DECODE( p_list_line_id, FND_API.g_miss_num, list_line_id, p_list_line_id),
129: arithmetic_operator = DECODE( p_arithmetic_operator, FND_API.g_miss_char, arithmetic_operator, p_arithmetic_operator),
130: original_discount = DECODE( p_original_discount, FND_API.g_miss_num, original_discount, p_original_discount),
131: modified_discount = DECODE( p_modified_discount, FND_API.g_miss_num, modified_discount, p_modified_discount),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
126: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, FND_API.g_miss_num, offer_adjustment_line_id, p_offer_adjustment_line_id),
127: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
128: list_line_id = DECODE( p_list_line_id, FND_API.g_miss_num, list_line_id, p_list_line_id),
129: arithmetic_operator = DECODE( p_arithmetic_operator, FND_API.g_miss_char, arithmetic_operator, p_arithmetic_operator),
130: original_discount = DECODE( p_original_discount, FND_API.g_miss_num, original_discount, p_original_discount),
131: modified_discount = DECODE( p_modified_discount, FND_API.g_miss_num, modified_discount, p_modified_discount),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
127: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
128: list_line_id = DECODE( p_list_line_id, FND_API.g_miss_num, list_line_id, p_list_line_id),
129: arithmetic_operator = DECODE( p_arithmetic_operator, FND_API.g_miss_char, arithmetic_operator, p_arithmetic_operator),
130: original_discount = DECODE( p_original_discount, FND_API.g_miss_num, original_discount, p_original_discount),
131: modified_discount = DECODE( p_modified_discount, FND_API.g_miss_num, modified_discount, p_modified_discount),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
135: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
128: list_line_id = DECODE( p_list_line_id, FND_API.g_miss_num, list_line_id, p_list_line_id),
129: arithmetic_operator = DECODE( p_arithmetic_operator, FND_API.g_miss_char, arithmetic_operator, p_arithmetic_operator),
130: original_discount = DECODE( p_original_discount, FND_API.g_miss_num, original_discount, p_original_discount),
131: modified_discount = DECODE( p_modified_discount, FND_API.g_miss_num, modified_discount, p_modified_discount),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
135: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
136: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
129: arithmetic_operator = DECODE( p_arithmetic_operator, FND_API.g_miss_char, arithmetic_operator, p_arithmetic_operator),
130: original_discount = DECODE( p_original_discount, FND_API.g_miss_num, original_discount, p_original_discount),
131: modified_discount = DECODE( p_modified_discount, FND_API.g_miss_num, modified_discount, p_modified_discount),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
135: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
136: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
137: WHERE OFFER_ADJUSTMENT_LINE_ID = p_OFFER_ADJUSTMENT_LINE_ID
130: original_discount = DECODE( p_original_discount, FND_API.g_miss_num, original_discount, p_original_discount),
131: modified_discount = DECODE( p_modified_discount, FND_API.g_miss_num, modified_discount, p_modified_discount),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
135: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
136: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
137: WHERE OFFER_ADJUSTMENT_LINE_ID = p_OFFER_ADJUSTMENT_LINE_ID
138: AND object_version_number = p_object_version_number;
131: modified_discount = DECODE( p_modified_discount, FND_API.g_miss_num, modified_discount, p_modified_discount),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
135: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
136: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
137: WHERE OFFER_ADJUSTMENT_LINE_ID = p_OFFER_ADJUSTMENT_LINE_ID
138: AND object_version_number = p_object_version_number;
139:
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
134: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
135: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
136: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
137: WHERE OFFER_ADJUSTMENT_LINE_ID = p_OFFER_ADJUSTMENT_LINE_ID
138: AND object_version_number = p_object_version_number;
139:
140: IF (SQL%NOTFOUND) THEN
137: WHERE OFFER_ADJUSTMENT_LINE_ID = p_OFFER_ADJUSTMENT_LINE_ID
138: AND object_version_number = p_object_version_number;
139:
140: IF (SQL%NOTFOUND) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143: END Update_Row;
144:
145:
165: BEGIN
166: DELETE FROM OZF_OFFER_ADJUSTMENT_LINES
167: WHERE OFFER_ADJUSTMENT_LINE_ID = p_OFFER_ADJUSTMENT_LINE_ID;
168: If (SQL%NOTFOUND) then
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: End If;
171: END Delete_Row ;
172:
173: