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

Line 83: DECODE( px_offer_adjustment_id, FND_API.g_miss_num, NULL, px_offer_adjustment_id),

79: last_update_login,
80: object_version_number,
81: security_group_id
82: ) VALUES (
83: DECODE( px_offer_adjustment_id, FND_API.g_miss_num, NULL, px_offer_adjustment_id),
84: DECODE( p_effective_date, FND_API.g_miss_date, to_date(NULL), p_effective_date),
85: DECODE( p_approved_date, FND_API.g_miss_date, to_date(NULL), p_approved_date),
86: DECODE( p_settlement_code, FND_API.g_miss_char, NULL, p_settlement_code),
87: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

Line 84: DECODE( p_effective_date, FND_API.g_miss_date, to_date(NULL), p_effective_date),

80: object_version_number,
81: security_group_id
82: ) VALUES (
83: DECODE( px_offer_adjustment_id, FND_API.g_miss_num, NULL, px_offer_adjustment_id),
84: DECODE( p_effective_date, FND_API.g_miss_date, to_date(NULL), p_effective_date),
85: DECODE( p_approved_date, FND_API.g_miss_date, to_date(NULL), p_approved_date),
86: DECODE( p_settlement_code, FND_API.g_miss_char, NULL, p_settlement_code),
87: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
88: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),

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

81: security_group_id
82: ) VALUES (
83: DECODE( px_offer_adjustment_id, FND_API.g_miss_num, NULL, px_offer_adjustment_id),
84: DECODE( p_effective_date, FND_API.g_miss_date, to_date(NULL), p_effective_date),
85: DECODE( p_approved_date, FND_API.g_miss_date, to_date(NULL), p_approved_date),
86: DECODE( p_settlement_code, FND_API.g_miss_char, NULL, p_settlement_code),
87: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
88: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
89: DECODE( p_version, FND_API.g_miss_num, NULL, p_version),

Line 86: DECODE( p_settlement_code, FND_API.g_miss_char, NULL, p_settlement_code),

82: ) VALUES (
83: DECODE( px_offer_adjustment_id, FND_API.g_miss_num, NULL, px_offer_adjustment_id),
84: DECODE( p_effective_date, FND_API.g_miss_date, to_date(NULL), p_effective_date),
85: DECODE( p_approved_date, FND_API.g_miss_date, to_date(NULL), p_approved_date),
86: DECODE( p_settlement_code, FND_API.g_miss_char, NULL, p_settlement_code),
87: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
88: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
89: DECODE( p_version, FND_API.g_miss_num, NULL, p_version),
90: DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, NULL, p_budget_adjusted_flag),

Line 87: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

83: DECODE( px_offer_adjustment_id, FND_API.g_miss_num, NULL, px_offer_adjustment_id),
84: DECODE( p_effective_date, FND_API.g_miss_date, to_date(NULL), p_effective_date),
85: DECODE( p_approved_date, FND_API.g_miss_date, to_date(NULL), p_approved_date),
86: DECODE( p_settlement_code, FND_API.g_miss_char, NULL, p_settlement_code),
87: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
88: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
89: DECODE( p_version, FND_API.g_miss_num, NULL, p_version),
90: DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, NULL, p_budget_adjusted_flag),
91: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),

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

84: DECODE( p_effective_date, FND_API.g_miss_date, to_date(NULL), p_effective_date),
85: DECODE( p_approved_date, FND_API.g_miss_date, to_date(NULL), p_approved_date),
86: DECODE( p_settlement_code, FND_API.g_miss_char, NULL, p_settlement_code),
87: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
88: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
89: DECODE( p_version, FND_API.g_miss_num, NULL, p_version),
90: DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, NULL, p_budget_adjusted_flag),
91: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
92: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),

Line 89: DECODE( p_version, FND_API.g_miss_num, NULL, p_version),

85: DECODE( p_approved_date, FND_API.g_miss_date, to_date(NULL), p_approved_date),
86: DECODE( p_settlement_code, FND_API.g_miss_char, NULL, p_settlement_code),
87: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
88: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
89: DECODE( p_version, FND_API.g_miss_num, NULL, p_version),
90: DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, NULL, p_budget_adjusted_flag),
91: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
92: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
93: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 90: DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, NULL, p_budget_adjusted_flag),

86: DECODE( p_settlement_code, FND_API.g_miss_char, NULL, p_settlement_code),
87: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
88: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
89: DECODE( p_version, FND_API.g_miss_num, NULL, p_version),
90: DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, NULL, p_budget_adjusted_flag),
91: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
92: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
93: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
94: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),

Line 91: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),

87: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
88: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
89: DECODE( p_version, FND_API.g_miss_num, NULL, p_version),
90: DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, NULL, p_budget_adjusted_flag),
91: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
92: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
93: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
94: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
95: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

88: DECODE( p_list_header_id, FND_API.g_miss_num, NULL, p_list_header_id),
89: DECODE( p_version, FND_API.g_miss_num, NULL, p_version),
90: DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, NULL, p_budget_adjusted_flag),
91: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
92: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
93: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
94: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
95: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
96: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

89: DECODE( p_version, FND_API.g_miss_num, NULL, p_version),
90: DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, NULL, p_budget_adjusted_flag),
91: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
92: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
93: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
94: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
95: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
96: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
97: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

90: DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, NULL, p_budget_adjusted_flag),
91: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
92: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
93: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
94: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
95: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
96: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
97: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
98: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));

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

91: DECODE( p_comments, FND_API.g_miss_char, NULL, p_comments),
92: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
93: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
94: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
95: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
96: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
97: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
98: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
99: END Insert_Row;

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

92: DECODE( p_last_update_date, FND_API.g_miss_date, to_date(NULL), p_last_update_date),
93: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
94: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
95: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
96: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
97: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
98: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
99: END Insert_Row;
100:

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

93: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
94: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
95: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
96: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
97: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
98: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
99: END Insert_Row;
100:
101:

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

94: DECODE( p_creation_date, FND_API.g_miss_date, to_date(NULL), p_creation_date),
95: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
96: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
97: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
98: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
99: END Insert_Row;
100:
101:
102: ----------------------------------------------------------

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

134: IS
135: BEGIN
136: Update ozf_OFFER_ADJUSTMENTS_B
137: SET
138: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
139: effective_date = DECODE( p_effective_date, FND_API.g_miss_date, effective_date, p_effective_date),
140: approved_date = DECODE( p_approved_date, FND_API.g_miss_date, approved_date, p_approved_date),
141: settlement_code = DECODE( p_settlement_code, FND_API.g_miss_char, settlement_code, p_settlement_code),
142: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),

Line 139: effective_date = DECODE( p_effective_date, FND_API.g_miss_date, effective_date, p_effective_date),

135: BEGIN
136: Update ozf_OFFER_ADJUSTMENTS_B
137: SET
138: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
139: effective_date = DECODE( p_effective_date, FND_API.g_miss_date, effective_date, p_effective_date),
140: approved_date = DECODE( p_approved_date, FND_API.g_miss_date, approved_date, p_approved_date),
141: settlement_code = DECODE( p_settlement_code, FND_API.g_miss_char, settlement_code, p_settlement_code),
142: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
143: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),

Line 140: approved_date = DECODE( p_approved_date, FND_API.g_miss_date, approved_date, p_approved_date),

136: Update ozf_OFFER_ADJUSTMENTS_B
137: SET
138: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
139: effective_date = DECODE( p_effective_date, FND_API.g_miss_date, effective_date, p_effective_date),
140: approved_date = DECODE( p_approved_date, FND_API.g_miss_date, approved_date, p_approved_date),
141: settlement_code = DECODE( p_settlement_code, FND_API.g_miss_char, settlement_code, p_settlement_code),
142: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
143: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
144: version = DECODE( p_version, FND_API.g_miss_num, version, p_version),

Line 141: settlement_code = DECODE( p_settlement_code, FND_API.g_miss_char, settlement_code, p_settlement_code),

137: SET
138: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
139: effective_date = DECODE( p_effective_date, FND_API.g_miss_date, effective_date, p_effective_date),
140: approved_date = DECODE( p_approved_date, FND_API.g_miss_date, approved_date, p_approved_date),
141: settlement_code = DECODE( p_settlement_code, FND_API.g_miss_char, settlement_code, p_settlement_code),
142: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
143: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
144: version = DECODE( p_version, FND_API.g_miss_num, version, p_version),
145: budget_adjusted_flag = DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, budget_adjusted_flag, p_budget_adjusted_flag),

Line 142: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),

138: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
139: effective_date = DECODE( p_effective_date, FND_API.g_miss_date, effective_date, p_effective_date),
140: approved_date = DECODE( p_approved_date, FND_API.g_miss_date, approved_date, p_approved_date),
141: settlement_code = DECODE( p_settlement_code, FND_API.g_miss_char, settlement_code, p_settlement_code),
142: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
143: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
144: version = DECODE( p_version, FND_API.g_miss_num, version, p_version),
145: budget_adjusted_flag = DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, budget_adjusted_flag, p_budget_adjusted_flag),
146: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),

Line 143: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),

139: effective_date = DECODE( p_effective_date, FND_API.g_miss_date, effective_date, p_effective_date),
140: approved_date = DECODE( p_approved_date, FND_API.g_miss_date, approved_date, p_approved_date),
141: settlement_code = DECODE( p_settlement_code, FND_API.g_miss_char, settlement_code, p_settlement_code),
142: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
143: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
144: version = DECODE( p_version, FND_API.g_miss_num, version, p_version),
145: budget_adjusted_flag = DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, budget_adjusted_flag, p_budget_adjusted_flag),
146: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
147: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 144: version = DECODE( p_version, FND_API.g_miss_num, version, p_version),

140: approved_date = DECODE( p_approved_date, FND_API.g_miss_date, approved_date, p_approved_date),
141: settlement_code = DECODE( p_settlement_code, FND_API.g_miss_char, settlement_code, p_settlement_code),
142: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
143: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
144: version = DECODE( p_version, FND_API.g_miss_num, version, p_version),
145: budget_adjusted_flag = DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, budget_adjusted_flag, p_budget_adjusted_flag),
146: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
147: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
148: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 145: budget_adjusted_flag = DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, budget_adjusted_flag, p_budget_adjusted_flag),

141: settlement_code = DECODE( p_settlement_code, FND_API.g_miss_char, settlement_code, p_settlement_code),
142: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
143: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
144: version = DECODE( p_version, FND_API.g_miss_num, version, p_version),
145: budget_adjusted_flag = DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, budget_adjusted_flag, p_budget_adjusted_flag),
146: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
147: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
148: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
149: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 146: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),

142: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
143: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
144: version = DECODE( p_version, FND_API.g_miss_num, version, p_version),
145: budget_adjusted_flag = DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, budget_adjusted_flag, p_budget_adjusted_flag),
146: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
147: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
148: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
149: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
150: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

143: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
144: version = DECODE( p_version, FND_API.g_miss_num, version, p_version),
145: budget_adjusted_flag = DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, budget_adjusted_flag, p_budget_adjusted_flag),
146: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
147: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
148: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
149: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
150: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

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

144: version = DECODE( p_version, FND_API.g_miss_num, version, p_version),
145: budget_adjusted_flag = DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, budget_adjusted_flag, p_budget_adjusted_flag),
146: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
147: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
148: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
149: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
150: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
152: WHERE OFFER_ADJUSTMENT_ID = p_OFFER_ADJUSTMENT_ID

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

145: budget_adjusted_flag = DECODE( p_budget_adjusted_flag, FND_API.g_miss_char, budget_adjusted_flag, p_budget_adjusted_flag),
146: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
147: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
148: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
149: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
150: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
152: WHERE OFFER_ADJUSTMENT_ID = p_OFFER_ADJUSTMENT_ID
153: AND object_version_number = p_object_version_number;

Line 150: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

146: comments = DECODE( p_comments, FND_API.g_miss_char, comments, p_comments),
147: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
148: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
149: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
150: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
152: WHERE OFFER_ADJUSTMENT_ID = p_OFFER_ADJUSTMENT_ID
153: AND object_version_number = p_object_version_number;
154:

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

147: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
148: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
149: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
150: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
151: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
152: WHERE OFFER_ADJUSTMENT_ID = p_OFFER_ADJUSTMENT_ID
153: AND object_version_number = p_object_version_number;
154:
155: IF (SQL%NOTFOUND) THEN

Line 156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

152: WHERE OFFER_ADJUSTMENT_ID = p_OFFER_ADJUSTMENT_ID
153: AND object_version_number = p_object_version_number;
154:
155: IF (SQL%NOTFOUND) THEN
156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
157: END IF;
158: END Update_Row;
159:
160:

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180: BEGIN
181: DELETE FROM ozf_OFFER_ADJUSTMENTS_B
182: WHERE OFFER_ADJUSTMENT_ID = p_OFFER_ADJUSTMENT_ID;
183: If (SQL%NOTFOUND) then
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: End If;
186: END Delete_Row ;
187:
188: