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

Line 92: DECODE( px_offer_adjustment_line_id, FND_API.G_MISS_NUM, NULL, px_offer_adjustment_line_id),

88: quantity,
89: created_from_adjustments,
90: discount_end_date
91: ) VALUES (
92: DECODE( px_offer_adjustment_line_id, FND_API.G_MISS_NUM, NULL, px_offer_adjustment_line_id),
93: DECODE( p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
94: DECODE( p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id),
95: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
96: DECODE( p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),

Line 93: DECODE( p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),

89: created_from_adjustments,
90: discount_end_date
91: ) VALUES (
92: DECODE( px_offer_adjustment_line_id, FND_API.G_MISS_NUM, NULL, px_offer_adjustment_line_id),
93: DECODE( p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
94: DECODE( p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id),
95: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
96: DECODE( p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
97: DECODE( p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),

Line 94: DECODE( p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id),

90: discount_end_date
91: ) VALUES (
92: DECODE( px_offer_adjustment_line_id, FND_API.G_MISS_NUM, NULL, px_offer_adjustment_line_id),
93: DECODE( p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
94: DECODE( p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id),
95: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
96: DECODE( p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
97: DECODE( p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

91: ) VALUES (
92: DECODE( px_offer_adjustment_line_id, FND_API.G_MISS_NUM, NULL, px_offer_adjustment_line_id),
93: DECODE( p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
94: DECODE( p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id),
95: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
96: DECODE( p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
97: DECODE( p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 96: DECODE( p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),

92: DECODE( px_offer_adjustment_line_id, FND_API.G_MISS_NUM, NULL, px_offer_adjustment_line_id),
93: DECODE( p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
94: DECODE( p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id),
95: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
96: DECODE( p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
97: DECODE( p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
100: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 97: DECODE( p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),

93: DECODE( p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
94: DECODE( p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id),
95: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
96: DECODE( p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
97: DECODE( p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
100: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

94: DECODE( p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id),
95: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
96: DECODE( p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
97: DECODE( p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
100: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
102: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 99: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

95: DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
96: DECODE( p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
97: DECODE( p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
100: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
102: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

Line 100: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

96: DECODE( p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
97: DECODE( p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
100: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
102: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_list_header_id, FND_API.G_MISS_NUM, NULL, p_list_header_id),

Line 101: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

97: DECODE( p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
100: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
102: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_list_header_id, FND_API.G_MISS_NUM, NULL, p_list_header_id),
105: DECODE( p_accrual_flag, FND_API.g_miss_char, NULL, p_accrual_flag),

Line 102: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
100: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
102: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_list_header_id, FND_API.G_MISS_NUM, NULL, p_list_header_id),
105: DECODE( p_accrual_flag, FND_API.g_miss_char, NULL, p_accrual_flag),
106: DECODE( p_list_line_id_td, FND_API.G_MISS_NUM, NULL, p_list_line_id_td),

Line 103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

99: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
100: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
102: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_list_header_id, FND_API.G_MISS_NUM, NULL, p_list_header_id),
105: DECODE( p_accrual_flag, FND_API.g_miss_char, NULL, p_accrual_flag),
106: DECODE( p_list_line_id_td, FND_API.G_MISS_NUM, NULL, p_list_line_id_td),
107: DECODE( p_original_discount_td, FND_API.G_MISS_NUM, NULL, p_original_discount_td),

Line 104: DECODE( p_list_header_id, FND_API.G_MISS_NUM, NULL, p_list_header_id),

100: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
102: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_list_header_id, FND_API.G_MISS_NUM, NULL, p_list_header_id),
105: DECODE( p_accrual_flag, FND_API.g_miss_char, NULL, p_accrual_flag),
106: DECODE( p_list_line_id_td, FND_API.G_MISS_NUM, NULL, p_list_line_id_td),
107: DECODE( p_original_discount_td, FND_API.G_MISS_NUM, NULL, p_original_discount_td),
108: DECODE( p_modified_discount_td, FND_API.G_MISS_NUM, NULL, p_modified_discount_td),

Line 105: DECODE( p_accrual_flag, FND_API.g_miss_char, NULL, p_accrual_flag),

101: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
102: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_list_header_id, FND_API.G_MISS_NUM, NULL, p_list_header_id),
105: DECODE( p_accrual_flag, FND_API.g_miss_char, NULL, p_accrual_flag),
106: DECODE( p_list_line_id_td, FND_API.G_MISS_NUM, NULL, p_list_line_id_td),
107: DECODE( p_original_discount_td, FND_API.G_MISS_NUM, NULL, p_original_discount_td),
108: DECODE( p_modified_discount_td, FND_API.G_MISS_NUM, NULL, p_modified_discount_td),
109: DECODE( p_quantity, FND_API.G_MISS_NUM, NULL, p_quantity),

Line 106: DECODE( p_list_line_id_td, FND_API.G_MISS_NUM, NULL, p_list_line_id_td),

102: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_list_header_id, FND_API.G_MISS_NUM, NULL, p_list_header_id),
105: DECODE( p_accrual_flag, FND_API.g_miss_char, NULL, p_accrual_flag),
106: DECODE( p_list_line_id_td, FND_API.G_MISS_NUM, NULL, p_list_line_id_td),
107: DECODE( p_original_discount_td, FND_API.G_MISS_NUM, NULL, p_original_discount_td),
108: DECODE( p_modified_discount_td, FND_API.G_MISS_NUM, NULL, p_modified_discount_td),
109: DECODE( p_quantity, FND_API.G_MISS_NUM, NULL, p_quantity),
110: DECODE( p_created_from_adjustments, FND_API.g_miss_char, NULL, p_created_from_adjustments),

Line 107: DECODE( p_original_discount_td, FND_API.G_MISS_NUM, NULL, p_original_discount_td),

103: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104: DECODE( p_list_header_id, FND_API.G_MISS_NUM, NULL, p_list_header_id),
105: DECODE( p_accrual_flag, FND_API.g_miss_char, NULL, p_accrual_flag),
106: DECODE( p_list_line_id_td, FND_API.G_MISS_NUM, NULL, p_list_line_id_td),
107: DECODE( p_original_discount_td, FND_API.G_MISS_NUM, NULL, p_original_discount_td),
108: DECODE( p_modified_discount_td, FND_API.G_MISS_NUM, NULL, p_modified_discount_td),
109: DECODE( p_quantity, FND_API.G_MISS_NUM, NULL, p_quantity),
110: DECODE( p_created_from_adjustments, FND_API.g_miss_char, NULL, p_created_from_adjustments),
111: DECODE( p_discount_end_date, FND_API.g_miss_date, NULL, p_discount_end_date)

Line 108: DECODE( p_modified_discount_td, FND_API.G_MISS_NUM, NULL, p_modified_discount_td),

104: DECODE( p_list_header_id, FND_API.G_MISS_NUM, NULL, p_list_header_id),
105: DECODE( p_accrual_flag, FND_API.g_miss_char, NULL, p_accrual_flag),
106: DECODE( p_list_line_id_td, FND_API.G_MISS_NUM, NULL, p_list_line_id_td),
107: DECODE( p_original_discount_td, FND_API.G_MISS_NUM, NULL, p_original_discount_td),
108: DECODE( p_modified_discount_td, FND_API.G_MISS_NUM, NULL, p_modified_discount_td),
109: DECODE( p_quantity, FND_API.G_MISS_NUM, NULL, p_quantity),
110: DECODE( p_created_from_adjustments, FND_API.g_miss_char, NULL, p_created_from_adjustments),
111: DECODE( p_discount_end_date, FND_API.g_miss_date, NULL, p_discount_end_date)
112: );

Line 109: DECODE( p_quantity, FND_API.G_MISS_NUM, NULL, p_quantity),

105: DECODE( p_accrual_flag, FND_API.g_miss_char, NULL, p_accrual_flag),
106: DECODE( p_list_line_id_td, FND_API.G_MISS_NUM, NULL, p_list_line_id_td),
107: DECODE( p_original_discount_td, FND_API.G_MISS_NUM, NULL, p_original_discount_td),
108: DECODE( p_modified_discount_td, FND_API.G_MISS_NUM, NULL, p_modified_discount_td),
109: DECODE( p_quantity, FND_API.G_MISS_NUM, NULL, p_quantity),
110: DECODE( p_created_from_adjustments, FND_API.g_miss_char, NULL, p_created_from_adjustments),
111: DECODE( p_discount_end_date, FND_API.g_miss_date, NULL, p_discount_end_date)
112: );
113:

Line 110: DECODE( p_created_from_adjustments, FND_API.g_miss_char, NULL, p_created_from_adjustments),

106: DECODE( p_list_line_id_td, FND_API.G_MISS_NUM, NULL, p_list_line_id_td),
107: DECODE( p_original_discount_td, FND_API.G_MISS_NUM, NULL, p_original_discount_td),
108: DECODE( p_modified_discount_td, FND_API.G_MISS_NUM, NULL, p_modified_discount_td),
109: DECODE( p_quantity, FND_API.G_MISS_NUM, NULL, p_quantity),
110: DECODE( p_created_from_adjustments, FND_API.g_miss_char, NULL, p_created_from_adjustments),
111: DECODE( p_discount_end_date, FND_API.g_miss_date, NULL, p_discount_end_date)
112: );
113:
114: END Insert_Row;

Line 111: DECODE( p_discount_end_date, FND_API.g_miss_date, NULL, p_discount_end_date)

107: DECODE( p_original_discount_td, FND_API.G_MISS_NUM, NULL, p_original_discount_td),
108: DECODE( p_modified_discount_td, FND_API.G_MISS_NUM, NULL, p_modified_discount_td),
109: DECODE( p_quantity, FND_API.G_MISS_NUM, NULL, p_quantity),
110: DECODE( p_created_from_adjustments, FND_API.g_miss_char, NULL, p_created_from_adjustments),
111: DECODE( p_discount_end_date, FND_API.g_miss_date, NULL, p_discount_end_date)
112: );
113:
114: END Insert_Row;
115:

Line 156: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, null, offer_adjustment_line_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_line_id),

152: IS
153: BEGIN
154: Update ozf_offer_adjustment_lines
155: SET
156: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, null, offer_adjustment_line_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
158: list_line_id = DECODE( p_list_line_id, null, list_line_id, FND_API.G_MISS_NUM, null, p_list_line_id),
159: arithmetic_operator = DECODE( p_arithmetic_operator, null, arithmetic_operator, FND_API.g_miss_char, null, p_arithmetic_operator),
160: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),

Line 157: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),

153: BEGIN
154: Update ozf_offer_adjustment_lines
155: SET
156: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, null, offer_adjustment_line_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
158: list_line_id = DECODE( p_list_line_id, null, list_line_id, FND_API.G_MISS_NUM, null, p_list_line_id),
159: arithmetic_operator = DECODE( p_arithmetic_operator, null, arithmetic_operator, FND_API.g_miss_char, null, p_arithmetic_operator),
160: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
161: -- modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),

Line 158: list_line_id = DECODE( p_list_line_id, null, list_line_id, FND_API.G_MISS_NUM, null, p_list_line_id),

154: Update ozf_offer_adjustment_lines
155: SET
156: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, null, offer_adjustment_line_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
158: list_line_id = DECODE( p_list_line_id, null, list_line_id, FND_API.G_MISS_NUM, null, p_list_line_id),
159: arithmetic_operator = DECODE( p_arithmetic_operator, null, arithmetic_operator, FND_API.g_miss_char, null, p_arithmetic_operator),
160: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
161: -- modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
162: modified_discount = p_modified_discount,

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

155: SET
156: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, null, offer_adjustment_line_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
158: list_line_id = DECODE( p_list_line_id, null, list_line_id, FND_API.G_MISS_NUM, null, p_list_line_id),
159: arithmetic_operator = DECODE( p_arithmetic_operator, null, arithmetic_operator, FND_API.g_miss_char, null, p_arithmetic_operator),
160: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
161: -- modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
162: modified_discount = p_modified_discount,
163: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),

Line 160: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),

156: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, null, offer_adjustment_line_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
158: list_line_id = DECODE( p_list_line_id, null, list_line_id, FND_API.G_MISS_NUM, null, p_list_line_id),
159: arithmetic_operator = DECODE( p_arithmetic_operator, null, arithmetic_operator, FND_API.g_miss_char, null, p_arithmetic_operator),
160: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
161: -- modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
162: modified_discount = p_modified_discount,
163: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
164: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 161: -- modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),

157: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
158: list_line_id = DECODE( p_list_line_id, null, list_line_id, FND_API.G_MISS_NUM, null, p_list_line_id),
159: arithmetic_operator = DECODE( p_arithmetic_operator, null, arithmetic_operator, FND_API.g_miss_char, null, p_arithmetic_operator),
160: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
161: -- modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
162: modified_discount = p_modified_discount,
163: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
164: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
165: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 163: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),

159: arithmetic_operator = DECODE( p_arithmetic_operator, null, arithmetic_operator, FND_API.g_miss_char, null, p_arithmetic_operator),
160: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
161: -- modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
162: modified_discount = p_modified_discount,
163: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
164: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
165: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
166: object_version_number = object_version_number + 1 ,
167: list_header_id = DECODE( p_list_header_id, null, list_header_id, FND_API.G_MISS_NUM, null, p_list_header_id),

Line 164: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

160: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
161: -- modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
162: modified_discount = p_modified_discount,
163: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
164: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
165: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
166: object_version_number = object_version_number + 1 ,
167: list_header_id = DECODE( p_list_header_id, null, list_header_id, FND_API.G_MISS_NUM, null, p_list_header_id),
168: accrual_flag = DECODE( p_accrual_flag, null, accrual_flag, FND_API.g_miss_char, null, p_accrual_flag),

Line 165: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

161: -- modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
162: modified_discount = p_modified_discount,
163: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
164: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
165: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
166: object_version_number = object_version_number + 1 ,
167: list_header_id = DECODE( p_list_header_id, null, list_header_id, FND_API.G_MISS_NUM, null, p_list_header_id),
168: accrual_flag = DECODE( p_accrual_flag, null, accrual_flag, FND_API.g_miss_char, null, p_accrual_flag),
169: list_line_id_td = DECODE( p_list_line_id_td, null, list_line_id_td, FND_API.G_MISS_NUM, null, p_list_line_id_td),

Line 167: list_header_id = DECODE( p_list_header_id, null, list_header_id, FND_API.G_MISS_NUM, null, p_list_header_id),

163: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
164: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
165: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
166: object_version_number = object_version_number + 1 ,
167: list_header_id = DECODE( p_list_header_id, null, list_header_id, FND_API.G_MISS_NUM, null, p_list_header_id),
168: accrual_flag = DECODE( p_accrual_flag, null, accrual_flag, FND_API.g_miss_char, null, p_accrual_flag),
169: list_line_id_td = DECODE( p_list_line_id_td, null, list_line_id_td, FND_API.G_MISS_NUM, null, p_list_line_id_td),
170: original_discount_td = DECODE( p_original_discount_td, null, original_discount_td, FND_API.G_MISS_NUM, null, p_original_discount_td),
171: -- modified_discount_td = DECODE( p_modified_discount_td, null, modified_discount_td, FND_API.G_MISS_NUM, null, p_modified_discount_td),

Line 168: accrual_flag = DECODE( p_accrual_flag, null, accrual_flag, FND_API.g_miss_char, null, p_accrual_flag),

164: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
165: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
166: object_version_number = object_version_number + 1 ,
167: list_header_id = DECODE( p_list_header_id, null, list_header_id, FND_API.G_MISS_NUM, null, p_list_header_id),
168: accrual_flag = DECODE( p_accrual_flag, null, accrual_flag, FND_API.g_miss_char, null, p_accrual_flag),
169: list_line_id_td = DECODE( p_list_line_id_td, null, list_line_id_td, FND_API.G_MISS_NUM, null, p_list_line_id_td),
170: original_discount_td = DECODE( p_original_discount_td, null, original_discount_td, FND_API.G_MISS_NUM, null, p_original_discount_td),
171: -- modified_discount_td = DECODE( p_modified_discount_td, null, modified_discount_td, FND_API.G_MISS_NUM, null, p_modified_discount_td),
172: modified_discount_td = p_modified_discount_td,

Line 169: list_line_id_td = DECODE( p_list_line_id_td, null, list_line_id_td, FND_API.G_MISS_NUM, null, p_list_line_id_td),

165: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
166: object_version_number = object_version_number + 1 ,
167: list_header_id = DECODE( p_list_header_id, null, list_header_id, FND_API.G_MISS_NUM, null, p_list_header_id),
168: accrual_flag = DECODE( p_accrual_flag, null, accrual_flag, FND_API.g_miss_char, null, p_accrual_flag),
169: list_line_id_td = DECODE( p_list_line_id_td, null, list_line_id_td, FND_API.G_MISS_NUM, null, p_list_line_id_td),
170: original_discount_td = DECODE( p_original_discount_td, null, original_discount_td, FND_API.G_MISS_NUM, null, p_original_discount_td),
171: -- modified_discount_td = DECODE( p_modified_discount_td, null, modified_discount_td, FND_API.G_MISS_NUM, null, p_modified_discount_td),
172: modified_discount_td = p_modified_discount_td,
173: quantity = DECODE( p_quantity, null, quantity, FND_API.G_MISS_NUM, null, p_quantity),

Line 170: original_discount_td = DECODE( p_original_discount_td, null, original_discount_td, FND_API.G_MISS_NUM, null, p_original_discount_td),

166: object_version_number = object_version_number + 1 ,
167: list_header_id = DECODE( p_list_header_id, null, list_header_id, FND_API.G_MISS_NUM, null, p_list_header_id),
168: accrual_flag = DECODE( p_accrual_flag, null, accrual_flag, FND_API.g_miss_char, null, p_accrual_flag),
169: list_line_id_td = DECODE( p_list_line_id_td, null, list_line_id_td, FND_API.G_MISS_NUM, null, p_list_line_id_td),
170: original_discount_td = DECODE( p_original_discount_td, null, original_discount_td, FND_API.G_MISS_NUM, null, p_original_discount_td),
171: -- modified_discount_td = DECODE( p_modified_discount_td, null, modified_discount_td, FND_API.G_MISS_NUM, null, p_modified_discount_td),
172: modified_discount_td = p_modified_discount_td,
173: quantity = DECODE( p_quantity, null, quantity, FND_API.G_MISS_NUM, null, p_quantity),
174: discount_end_date = DECODE(p_discount_end_date, null, discount_end_date, FND_API.G_MISS_DATE, null, p_discount_end_date)

Line 171: -- modified_discount_td = DECODE( p_modified_discount_td, null, modified_discount_td, FND_API.G_MISS_NUM, null, p_modified_discount_td),

167: list_header_id = DECODE( p_list_header_id, null, list_header_id, FND_API.G_MISS_NUM, null, p_list_header_id),
168: accrual_flag = DECODE( p_accrual_flag, null, accrual_flag, FND_API.g_miss_char, null, p_accrual_flag),
169: list_line_id_td = DECODE( p_list_line_id_td, null, list_line_id_td, FND_API.G_MISS_NUM, null, p_list_line_id_td),
170: original_discount_td = DECODE( p_original_discount_td, null, original_discount_td, FND_API.G_MISS_NUM, null, p_original_discount_td),
171: -- modified_discount_td = DECODE( p_modified_discount_td, null, modified_discount_td, FND_API.G_MISS_NUM, null, p_modified_discount_td),
172: modified_discount_td = p_modified_discount_td,
173: quantity = DECODE( p_quantity, null, quantity, FND_API.G_MISS_NUM, null, p_quantity),
174: discount_end_date = DECODE(p_discount_end_date, null, discount_end_date, FND_API.G_MISS_DATE, null, p_discount_end_date)
175: -- created_from_adjustments = DECODE( p_created_from_adjustments, null, created_from_adjustments, FND_API.g_miss_char, null, p_created_from_adjustments)

Line 173: quantity = DECODE( p_quantity, null, quantity, FND_API.G_MISS_NUM, null, p_quantity),

169: list_line_id_td = DECODE( p_list_line_id_td, null, list_line_id_td, FND_API.G_MISS_NUM, null, p_list_line_id_td),
170: original_discount_td = DECODE( p_original_discount_td, null, original_discount_td, FND_API.G_MISS_NUM, null, p_original_discount_td),
171: -- modified_discount_td = DECODE( p_modified_discount_td, null, modified_discount_td, FND_API.G_MISS_NUM, null, p_modified_discount_td),
172: modified_discount_td = p_modified_discount_td,
173: quantity = DECODE( p_quantity, null, quantity, FND_API.G_MISS_NUM, null, p_quantity),
174: discount_end_date = DECODE(p_discount_end_date, null, discount_end_date, FND_API.G_MISS_DATE, null, p_discount_end_date)
175: -- created_from_adjustments = DECODE( p_created_from_adjustments, null, created_from_adjustments, FND_API.g_miss_char, null, p_created_from_adjustments)
176: WHERE offer_adjustment_line_id = p_offer_adjustment_line_id
177: AND object_version_number = px_object_version_number;

Line 174: discount_end_date = DECODE(p_discount_end_date, null, discount_end_date, FND_API.G_MISS_DATE, null, p_discount_end_date)

170: original_discount_td = DECODE( p_original_discount_td, null, original_discount_td, FND_API.G_MISS_NUM, null, p_original_discount_td),
171: -- modified_discount_td = DECODE( p_modified_discount_td, null, modified_discount_td, FND_API.G_MISS_NUM, null, p_modified_discount_td),
172: modified_discount_td = p_modified_discount_td,
173: quantity = DECODE( p_quantity, null, quantity, FND_API.G_MISS_NUM, null, p_quantity),
174: discount_end_date = DECODE(p_discount_end_date, null, discount_end_date, FND_API.G_MISS_DATE, null, p_discount_end_date)
175: -- created_from_adjustments = DECODE( p_created_from_adjustments, null, created_from_adjustments, FND_API.g_miss_char, null, p_created_from_adjustments)
176: WHERE offer_adjustment_line_id = p_offer_adjustment_line_id
177: AND object_version_number = px_object_version_number;
178:

Line 175: -- created_from_adjustments = DECODE( p_created_from_adjustments, null, created_from_adjustments, FND_API.g_miss_char, null, p_created_from_adjustments)

171: -- modified_discount_td = DECODE( p_modified_discount_td, null, modified_discount_td, FND_API.G_MISS_NUM, null, p_modified_discount_td),
172: modified_discount_td = p_modified_discount_td,
173: quantity = DECODE( p_quantity, null, quantity, FND_API.G_MISS_NUM, null, p_quantity),
174: discount_end_date = DECODE(p_discount_end_date, null, discount_end_date, FND_API.G_MISS_DATE, null, p_discount_end_date)
175: -- created_from_adjustments = DECODE( p_created_from_adjustments, null, created_from_adjustments, FND_API.g_miss_char, null, p_created_from_adjustments)
176: WHERE offer_adjustment_line_id = p_offer_adjustment_line_id
177: AND object_version_number = px_object_version_number;
178:
179:

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177: AND object_version_number = px_object_version_number;
178:
179:
180: IF (SQL%NOTFOUND) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183:
184: px_object_version_number := nvl(px_object_version_number,0) + 1;
185:

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208: DELETE FROM ozf_offer_adjustment_lines
209: WHERE offer_adjustment_line_id = p_offer_adjustment_line_id
210: AND object_version_number = p_object_version_number;
211: If (SQL%NOTFOUND) then
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: End If;
214: END Delete_Row ;
215:
216:

Line 250: RAISE FND_API.g_exc_error;

246: FETCH c INTO Recinfo;
247: IF (c%NOTFOUND) THEN
248: CLOSE c;
249: OZF_Utility_PVT.error_message ('OZF_API_RECORD_NOT_FOUND');
250: RAISE FND_API.g_exc_error;
251: END IF;
252: CLOSE c;
253: END Lock_Row;
254: