DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJUSTMENT_LINES_PKG dependencies on FND_API

Line 77: DECODE( px_offer_adjustment_line_id, FND_API.g_miss_num, NULL, px_offer_adjustment_line_id),

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),

Line 78: DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),

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),

Line 79: DECODE( p_list_line_id, FND_API.g_miss_num, NULL, p_list_line_id),

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),

Line 80: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),

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),

Line 81: DECODE( p_original_discount, FND_API.g_miss_num, NULL, p_original_discount),

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),

Line 82: DECODE( p_modified_discount, FND_API.g_miss_num, NULL, p_modified_discount),

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),

Line 83: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),

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),

Line 84: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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),

Line 85: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),

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));

Line 86: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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;

Line 87: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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:

Line 88: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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:

Line 89: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));

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: ----------------------------------------------------------

Line 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),

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),

Line 127: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),

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),

Line 128: list_line_id = DECODE( p_list_line_id, FND_API.g_miss_num, list_line_id, p_list_line_id),

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),

Line 129: arithmetic_operator = DECODE( p_arithmetic_operator, FND_API.g_miss_char, arithmetic_operator, p_arithmetic_operator),

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),

Line 130: original_discount = DECODE( p_original_discount, FND_API.g_miss_num, original_discount, p_original_discount),

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),

Line 131: modified_discount = DECODE( p_modified_discount, FND_API.g_miss_num, modified_discount, p_modified_discount),

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),

Line 132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

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)

Line 133: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

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

Line 134: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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;

Line 135: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, 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:

Line 136: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

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

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: