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

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

85: last_updated_by,
86: last_update_login,
87: object_version_number
88: ) VALUES (
89: DECODE( px_offer_adj_new_line_id, FND_API.g_miss_num, NULL, px_offer_adj_new_line_id)
90: , DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id)
91: , DECODE( p_volume_from, FND_API.g_miss_num, NULL, p_volume_from)
92: , DECODE( p_volume_to, FND_API.g_miss_num, NULL, p_volume_to)
93: , DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type)

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

86: last_update_login,
87: object_version_number
88: ) VALUES (
89: DECODE( px_offer_adj_new_line_id, FND_API.g_miss_num, NULL, px_offer_adj_new_line_id)
90: , DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id)
91: , DECODE( p_volume_from, FND_API.g_miss_num, NULL, p_volume_from)
92: , DECODE( p_volume_to, FND_API.g_miss_num, NULL, p_volume_to)
93: , DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type)
94: , DECODE( p_discount, FND_API.g_miss_num, NULL, p_discount)

Line 91: , DECODE( p_volume_from, FND_API.g_miss_num, NULL, p_volume_from)

87: object_version_number
88: ) VALUES (
89: DECODE( px_offer_adj_new_line_id, FND_API.g_miss_num, NULL, px_offer_adj_new_line_id)
90: , DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id)
91: , DECODE( p_volume_from, FND_API.g_miss_num, NULL, p_volume_from)
92: , DECODE( p_volume_to, FND_API.g_miss_num, NULL, p_volume_to)
93: , DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type)
94: , DECODE( p_discount, FND_API.g_miss_num, NULL, p_discount)
95: , DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type)

Line 92: , DECODE( p_volume_to, FND_API.g_miss_num, NULL, p_volume_to)

88: ) VALUES (
89: DECODE( px_offer_adj_new_line_id, FND_API.g_miss_num, NULL, px_offer_adj_new_line_id)
90: , DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id)
91: , DECODE( p_volume_from, FND_API.g_miss_num, NULL, p_volume_from)
92: , DECODE( p_volume_to, FND_API.g_miss_num, NULL, p_volume_to)
93: , DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type)
94: , DECODE( p_discount, FND_API.g_miss_num, NULL, p_discount)
95: , DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type)
96: , DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type)

Line 93: , DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type)

89: DECODE( px_offer_adj_new_line_id, FND_API.g_miss_num, NULL, px_offer_adj_new_line_id)
90: , DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id)
91: , DECODE( p_volume_from, FND_API.g_miss_num, NULL, p_volume_from)
92: , DECODE( p_volume_to, FND_API.g_miss_num, NULL, p_volume_to)
93: , DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type)
94: , DECODE( p_discount, FND_API.g_miss_num, NULL, p_discount)
95: , DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type)
96: , DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type)
97: , DECODE( p_td_discount, FND_API.g_miss_num, NULL, p_td_discount)

Line 94: , DECODE( p_discount, FND_API.g_miss_num, NULL, p_discount)

90: , DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id)
91: , DECODE( p_volume_from, FND_API.g_miss_num, NULL, p_volume_from)
92: , DECODE( p_volume_to, FND_API.g_miss_num, NULL, p_volume_to)
93: , DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type)
94: , DECODE( p_discount, FND_API.g_miss_num, NULL, p_discount)
95: , DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type)
96: , DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type)
97: , DECODE( p_td_discount, FND_API.g_miss_num, NULL, p_td_discount)
98: , DECODE( p_td_discount_type, FND_API.g_miss_char, NULL, p_td_discount_type)

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

91: , DECODE( p_volume_from, FND_API.g_miss_num, NULL, p_volume_from)
92: , DECODE( p_volume_to, FND_API.g_miss_num, NULL, p_volume_to)
93: , DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type)
94: , DECODE( p_discount, FND_API.g_miss_num, NULL, p_discount)
95: , DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type)
96: , DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type)
97: , DECODE( p_td_discount, FND_API.g_miss_num, NULL, p_td_discount)
98: , DECODE( p_td_discount_type, FND_API.g_miss_char, NULL, p_td_discount_type)
99: , DECODE( p_quantity, FND_API.G_MISS_NUM, null,p_quantity)

Line 96: , DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type)

92: , DECODE( p_volume_to, FND_API.g_miss_num, NULL, p_volume_to)
93: , DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type)
94: , DECODE( p_discount, FND_API.g_miss_num, NULL, p_discount)
95: , DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type)
96: , DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type)
97: , DECODE( p_td_discount, FND_API.g_miss_num, NULL, p_td_discount)
98: , DECODE( p_td_discount_type, FND_API.g_miss_char, NULL, p_td_discount_type)
99: , DECODE( p_quantity, FND_API.G_MISS_NUM, null,p_quantity)
100: , DECODE( P_benefit_price_list_line_id, FND_API.G_MISS_NUM, null, p_benefit_price_list_line_id)

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

93: , DECODE( p_volume_type, FND_API.g_miss_char, NULL, p_volume_type)
94: , DECODE( p_discount, FND_API.g_miss_num, NULL, p_discount)
95: , DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type)
96: , DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type)
97: , DECODE( p_td_discount, FND_API.g_miss_num, NULL, p_td_discount)
98: , DECODE( p_td_discount_type, FND_API.g_miss_char, NULL, p_td_discount_type)
99: , DECODE( p_quantity, FND_API.G_MISS_NUM, null,p_quantity)
100: , DECODE( P_benefit_price_list_line_id, FND_API.G_MISS_NUM, null, p_benefit_price_list_line_id)
101: , DECODE( p_parent_adj_line_id , FND_API.G_MISS_NUM, null, p_parent_adj_line_id)

Line 98: , DECODE( p_td_discount_type, FND_API.g_miss_char, NULL, p_td_discount_type)

94: , DECODE( p_discount, FND_API.g_miss_num, NULL, p_discount)
95: , DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type)
96: , DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type)
97: , DECODE( p_td_discount, FND_API.g_miss_num, NULL, p_td_discount)
98: , DECODE( p_td_discount_type, FND_API.g_miss_char, NULL, p_td_discount_type)
99: , DECODE( p_quantity, FND_API.G_MISS_NUM, null,p_quantity)
100: , DECODE( P_benefit_price_list_line_id, FND_API.G_MISS_NUM, null, p_benefit_price_list_line_id)
101: , DECODE( p_parent_adj_line_id , FND_API.G_MISS_NUM, null, p_parent_adj_line_id)
102: , DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, p_start_date_active)

Line 99: , DECODE( p_quantity, FND_API.G_MISS_NUM, null,p_quantity)

95: , DECODE( p_discount_type, FND_API.g_miss_char, NULL, p_discount_type)
96: , DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type)
97: , DECODE( p_td_discount, FND_API.g_miss_num, NULL, p_td_discount)
98: , DECODE( p_td_discount_type, FND_API.g_miss_char, NULL, p_td_discount_type)
99: , DECODE( p_quantity, FND_API.G_MISS_NUM, null,p_quantity)
100: , DECODE( P_benefit_price_list_line_id, FND_API.G_MISS_NUM, null, p_benefit_price_list_line_id)
101: , DECODE( p_parent_adj_line_id , FND_API.G_MISS_NUM, null, p_parent_adj_line_id)
102: , DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, p_start_date_active)
103: , DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, p_end_date_active)

Line 100: , DECODE( P_benefit_price_list_line_id, FND_API.G_MISS_NUM, null, p_benefit_price_list_line_id)

96: , DECODE( p_tier_type, FND_API.g_miss_char, NULL, p_tier_type)
97: , DECODE( p_td_discount, FND_API.g_miss_num, NULL, p_td_discount)
98: , DECODE( p_td_discount_type, FND_API.g_miss_char, NULL, p_td_discount_type)
99: , DECODE( p_quantity, FND_API.G_MISS_NUM, null,p_quantity)
100: , DECODE( P_benefit_price_list_line_id, FND_API.G_MISS_NUM, null, p_benefit_price_list_line_id)
101: , DECODE( p_parent_adj_line_id , FND_API.G_MISS_NUM, null, p_parent_adj_line_id)
102: , DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, p_start_date_active)
103: , DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, p_end_date_active)
104: , DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date)

Line 101: , DECODE( p_parent_adj_line_id , FND_API.G_MISS_NUM, null, p_parent_adj_line_id)

97: , DECODE( p_td_discount, FND_API.g_miss_num, NULL, p_td_discount)
98: , DECODE( p_td_discount_type, FND_API.g_miss_char, NULL, p_td_discount_type)
99: , DECODE( p_quantity, FND_API.G_MISS_NUM, null,p_quantity)
100: , DECODE( P_benefit_price_list_line_id, FND_API.G_MISS_NUM, null, p_benefit_price_list_line_id)
101: , DECODE( p_parent_adj_line_id , FND_API.G_MISS_NUM, null, p_parent_adj_line_id)
102: , DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, p_start_date_active)
103: , DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, p_end_date_active)
104: , DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date)
105: , DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by)

Line 102: , DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, p_start_date_active)

98: , DECODE( p_td_discount_type, FND_API.g_miss_char, NULL, p_td_discount_type)
99: , DECODE( p_quantity, FND_API.G_MISS_NUM, null,p_quantity)
100: , DECODE( P_benefit_price_list_line_id, FND_API.G_MISS_NUM, null, p_benefit_price_list_line_id)
101: , DECODE( p_parent_adj_line_id , FND_API.G_MISS_NUM, null, p_parent_adj_line_id)
102: , DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, p_start_date_active)
103: , DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, p_end_date_active)
104: , DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date)
105: , DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by)
106: , DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date)

Line 103: , DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, p_end_date_active)

99: , DECODE( p_quantity, FND_API.G_MISS_NUM, null,p_quantity)
100: , DECODE( P_benefit_price_list_line_id, FND_API.G_MISS_NUM, null, p_benefit_price_list_line_id)
101: , DECODE( p_parent_adj_line_id , FND_API.G_MISS_NUM, null, p_parent_adj_line_id)
102: , DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, p_start_date_active)
103: , DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, p_end_date_active)
104: , DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date)
105: , DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by)
106: , DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date)
107: , DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by)

Line 104: , DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date)

100: , DECODE( P_benefit_price_list_line_id, FND_API.G_MISS_NUM, null, p_benefit_price_list_line_id)
101: , DECODE( p_parent_adj_line_id , FND_API.G_MISS_NUM, null, p_parent_adj_line_id)
102: , DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, p_start_date_active)
103: , DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, p_end_date_active)
104: , DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date)
105: , DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by)
106: , DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date)
107: , DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by)
108: , DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)

Line 105: , DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by)

101: , DECODE( p_parent_adj_line_id , FND_API.G_MISS_NUM, null, p_parent_adj_line_id)
102: , DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, p_start_date_active)
103: , DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, p_end_date_active)
104: , DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date)
105: , DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by)
106: , DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date)
107: , DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by)
108: , DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
109: , DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number)

Line 106: , DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date)

102: , DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, p_start_date_active)
103: , DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, p_end_date_active)
104: , DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date)
105: , DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by)
106: , DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date)
107: , DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by)
108: , DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
109: , DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number)
110: );

Line 107: , DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by)

103: , DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, p_end_date_active)
104: , DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date)
105: , DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by)
106: , DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date)
107: , DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by)
108: , DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
109: , DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number)
110: );
111:

Line 108: , DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)

104: , DECODE( p_creation_date, FND_API.g_miss_date, SYSDATE, p_creation_date)
105: , DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by)
106: , DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date)
107: , DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by)
108: , DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
109: , DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number)
110: );
111:
112: END Insert_Row;

Line 109: , DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number)

105: , DECODE( p_created_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_created_by)
106: , DECODE( p_last_update_date, FND_API.g_miss_date, SYSDATE, p_last_update_date)
107: , DECODE( p_last_updated_by, FND_API.g_miss_num, FND_GLOBAL.USER_ID, p_last_updated_by)
108: , DECODE( p_last_update_login, FND_API.g_miss_num, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
109: , DECODE( px_object_version_number, FND_API.g_miss_num, 1, px_object_version_number)
110: );
111:
112: END Insert_Row;
113:

Line 156: offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, NULL, offer_adj_new_line_id, p_offer_adj_new_line_id),

152: IS
153: BEGIN
154: Update OZF_OFFER_ADJ_NEW_LINES
155: SET
156: offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, NULL, offer_adj_new_line_id, p_offer_adj_new_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, NULL, offer_adjustment_id, p_offer_adjustment_id),
158: volume_from = DECODE( p_volume_from, FND_API.g_miss_num, NULL, NULL,volume_from, p_volume_from),
159: volume_to = DECODE( p_volume_to, FND_API.g_miss_num, NULL, NULL, volume_to, p_volume_to),
160: volume_type = DECODE( p_volume_type, FND_API.g_miss_char, NULL, NULL, volume_type, p_volume_type),

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

153: BEGIN
154: Update OZF_OFFER_ADJ_NEW_LINES
155: SET
156: offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, NULL, offer_adj_new_line_id, p_offer_adj_new_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, NULL, offer_adjustment_id, p_offer_adjustment_id),
158: volume_from = DECODE( p_volume_from, FND_API.g_miss_num, NULL, NULL,volume_from, p_volume_from),
159: volume_to = DECODE( p_volume_to, FND_API.g_miss_num, NULL, NULL, volume_to, p_volume_to),
160: volume_type = DECODE( p_volume_type, FND_API.g_miss_char, NULL, NULL, volume_type, p_volume_type),
161: discount = DECODE( p_discount, FND_API.g_miss_num, NULL, NULL, discount, p_discount),

Line 158: volume_from = DECODE( p_volume_from, FND_API.g_miss_num, NULL, NULL,volume_from, p_volume_from),

154: Update OZF_OFFER_ADJ_NEW_LINES
155: SET
156: offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, NULL, offer_adj_new_line_id, p_offer_adj_new_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, NULL, offer_adjustment_id, p_offer_adjustment_id),
158: volume_from = DECODE( p_volume_from, FND_API.g_miss_num, NULL, NULL,volume_from, p_volume_from),
159: volume_to = DECODE( p_volume_to, FND_API.g_miss_num, NULL, NULL, volume_to, p_volume_to),
160: volume_type = DECODE( p_volume_type, FND_API.g_miss_char, NULL, NULL, volume_type, p_volume_type),
161: discount = DECODE( p_discount, FND_API.g_miss_num, NULL, NULL, discount, p_discount),
162: discount_type = DECODE( p_discount_type, FND_API.g_miss_char, NULL, NULL, discount_type, p_discount_type),

Line 159: volume_to = DECODE( p_volume_to, FND_API.g_miss_num, NULL, NULL, volume_to, p_volume_to),

155: SET
156: offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, NULL, offer_adj_new_line_id, p_offer_adj_new_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, NULL, offer_adjustment_id, p_offer_adjustment_id),
158: volume_from = DECODE( p_volume_from, FND_API.g_miss_num, NULL, NULL,volume_from, p_volume_from),
159: volume_to = DECODE( p_volume_to, FND_API.g_miss_num, NULL, NULL, volume_to, p_volume_to),
160: volume_type = DECODE( p_volume_type, FND_API.g_miss_char, NULL, NULL, volume_type, p_volume_type),
161: discount = DECODE( p_discount, FND_API.g_miss_num, NULL, NULL, discount, p_discount),
162: discount_type = DECODE( p_discount_type, FND_API.g_miss_char, NULL, NULL, discount_type, p_discount_type),
163: tier_type = DECODE( p_tier_type, FND_API.g_miss_char, NULL, NULL, tier_type, p_tier_type),

Line 160: volume_type = DECODE( p_volume_type, FND_API.g_miss_char, NULL, NULL, volume_type, p_volume_type),

156: offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, NULL, offer_adj_new_line_id, p_offer_adj_new_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, NULL, offer_adjustment_id, p_offer_adjustment_id),
158: volume_from = DECODE( p_volume_from, FND_API.g_miss_num, NULL, NULL,volume_from, p_volume_from),
159: volume_to = DECODE( p_volume_to, FND_API.g_miss_num, NULL, NULL, volume_to, p_volume_to),
160: volume_type = DECODE( p_volume_type, FND_API.g_miss_char, NULL, NULL, volume_type, p_volume_type),
161: discount = DECODE( p_discount, FND_API.g_miss_num, NULL, NULL, discount, p_discount),
162: discount_type = DECODE( p_discount_type, FND_API.g_miss_char, NULL, NULL, discount_type, p_discount_type),
163: tier_type = DECODE( p_tier_type, FND_API.g_miss_char, NULL, NULL, tier_type, p_tier_type),
164: td_discount = DECODE(p_td_discount , FND_API.g_miss_num, NULL, NULL, td_discount, p_td_discount),

Line 161: discount = DECODE( p_discount, FND_API.g_miss_num, NULL, NULL, discount, p_discount),

157: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, NULL, offer_adjustment_id, p_offer_adjustment_id),
158: volume_from = DECODE( p_volume_from, FND_API.g_miss_num, NULL, NULL,volume_from, p_volume_from),
159: volume_to = DECODE( p_volume_to, FND_API.g_miss_num, NULL, NULL, volume_to, p_volume_to),
160: volume_type = DECODE( p_volume_type, FND_API.g_miss_char, NULL, NULL, volume_type, p_volume_type),
161: discount = DECODE( p_discount, FND_API.g_miss_num, NULL, NULL, discount, p_discount),
162: discount_type = DECODE( p_discount_type, FND_API.g_miss_char, NULL, NULL, discount_type, p_discount_type),
163: tier_type = DECODE( p_tier_type, FND_API.g_miss_char, NULL, NULL, tier_type, p_tier_type),
164: td_discount = DECODE(p_td_discount , FND_API.g_miss_num, NULL, NULL, td_discount, p_td_discount),
165: td_discount_type = DECODE(p_td_discount_type, FND_API.g_miss_char, NULL, NULL,td_discount_type, p_td_discount_type),

Line 162: discount_type = DECODE( p_discount_type, FND_API.g_miss_char, NULL, NULL, discount_type, p_discount_type),

158: volume_from = DECODE( p_volume_from, FND_API.g_miss_num, NULL, NULL,volume_from, p_volume_from),
159: volume_to = DECODE( p_volume_to, FND_API.g_miss_num, NULL, NULL, volume_to, p_volume_to),
160: volume_type = DECODE( p_volume_type, FND_API.g_miss_char, NULL, NULL, volume_type, p_volume_type),
161: discount = DECODE( p_discount, FND_API.g_miss_num, NULL, NULL, discount, p_discount),
162: discount_type = DECODE( p_discount_type, FND_API.g_miss_char, NULL, NULL, discount_type, p_discount_type),
163: tier_type = DECODE( p_tier_type, FND_API.g_miss_char, NULL, NULL, tier_type, p_tier_type),
164: td_discount = DECODE(p_td_discount , FND_API.g_miss_num, NULL, NULL, td_discount, p_td_discount),
165: td_discount_type = DECODE(p_td_discount_type, FND_API.g_miss_char, NULL, NULL,td_discount_type, p_td_discount_type),
166: quantity = DECODE(p_quantity , FND_API.G_MISS_NUM, NULL,null, quantity, p_quantity),

Line 163: tier_type = DECODE( p_tier_type, FND_API.g_miss_char, NULL, NULL, tier_type, p_tier_type),

159: volume_to = DECODE( p_volume_to, FND_API.g_miss_num, NULL, NULL, volume_to, p_volume_to),
160: volume_type = DECODE( p_volume_type, FND_API.g_miss_char, NULL, NULL, volume_type, p_volume_type),
161: discount = DECODE( p_discount, FND_API.g_miss_num, NULL, NULL, discount, p_discount),
162: discount_type = DECODE( p_discount_type, FND_API.g_miss_char, NULL, NULL, discount_type, p_discount_type),
163: tier_type = DECODE( p_tier_type, FND_API.g_miss_char, NULL, NULL, tier_type, p_tier_type),
164: td_discount = DECODE(p_td_discount , FND_API.g_miss_num, NULL, NULL, td_discount, p_td_discount),
165: td_discount_type = DECODE(p_td_discount_type, FND_API.g_miss_char, NULL, NULL,td_discount_type, p_td_discount_type),
166: quantity = DECODE(p_quantity , FND_API.G_MISS_NUM, NULL,null, quantity, p_quantity),
167: benefit_price_list_line_id = DECODE(p_benefit_price_list_line_id, FND_API.G_MISS_NUM , NULL, null, benefit_price_list_line_id, p_benefit_price_list_line_id),

Line 164: td_discount = DECODE(p_td_discount , FND_API.g_miss_num, NULL, NULL, td_discount, p_td_discount),

160: volume_type = DECODE( p_volume_type, FND_API.g_miss_char, NULL, NULL, volume_type, p_volume_type),
161: discount = DECODE( p_discount, FND_API.g_miss_num, NULL, NULL, discount, p_discount),
162: discount_type = DECODE( p_discount_type, FND_API.g_miss_char, NULL, NULL, discount_type, p_discount_type),
163: tier_type = DECODE( p_tier_type, FND_API.g_miss_char, NULL, NULL, tier_type, p_tier_type),
164: td_discount = DECODE(p_td_discount , FND_API.g_miss_num, NULL, NULL, td_discount, p_td_discount),
165: td_discount_type = DECODE(p_td_discount_type, FND_API.g_miss_char, NULL, NULL,td_discount_type, p_td_discount_type),
166: quantity = DECODE(p_quantity , FND_API.G_MISS_NUM, NULL,null, quantity, p_quantity),
167: benefit_price_list_line_id = DECODE(p_benefit_price_list_line_id, FND_API.G_MISS_NUM , NULL, null, benefit_price_list_line_id, p_benefit_price_list_line_id),
168: parent_adj_line_id = DECODE(p_parent_adj_line_id , fnd_api.g_miss_num, NULL, NULL, parent_adj_line_id , p_parent_adj_line_id),

Line 165: td_discount_type = DECODE(p_td_discount_type, FND_API.g_miss_char, NULL, NULL,td_discount_type, p_td_discount_type),

161: discount = DECODE( p_discount, FND_API.g_miss_num, NULL, NULL, discount, p_discount),
162: discount_type = DECODE( p_discount_type, FND_API.g_miss_char, NULL, NULL, discount_type, p_discount_type),
163: tier_type = DECODE( p_tier_type, FND_API.g_miss_char, NULL, NULL, tier_type, p_tier_type),
164: td_discount = DECODE(p_td_discount , FND_API.g_miss_num, NULL, NULL, td_discount, p_td_discount),
165: td_discount_type = DECODE(p_td_discount_type, FND_API.g_miss_char, NULL, NULL,td_discount_type, p_td_discount_type),
166: quantity = DECODE(p_quantity , FND_API.G_MISS_NUM, NULL,null, quantity, p_quantity),
167: benefit_price_list_line_id = DECODE(p_benefit_price_list_line_id, FND_API.G_MISS_NUM , NULL, null, benefit_price_list_line_id, p_benefit_price_list_line_id),
168: parent_adj_line_id = DECODE(p_parent_adj_line_id , fnd_api.g_miss_num, NULL, NULL, parent_adj_line_id , p_parent_adj_line_id),
169: start_date_active = DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, null, start_date_active, p_start_date_active),

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

162: discount_type = DECODE( p_discount_type, FND_API.g_miss_char, NULL, NULL, discount_type, p_discount_type),
163: tier_type = DECODE( p_tier_type, FND_API.g_miss_char, NULL, NULL, tier_type, p_tier_type),
164: td_discount = DECODE(p_td_discount , FND_API.g_miss_num, NULL, NULL, td_discount, p_td_discount),
165: td_discount_type = DECODE(p_td_discount_type, FND_API.g_miss_char, NULL, NULL,td_discount_type, p_td_discount_type),
166: quantity = DECODE(p_quantity , FND_API.G_MISS_NUM, NULL,null, quantity, p_quantity),
167: benefit_price_list_line_id = DECODE(p_benefit_price_list_line_id, FND_API.G_MISS_NUM , NULL, null, benefit_price_list_line_id, p_benefit_price_list_line_id),
168: parent_adj_line_id = DECODE(p_parent_adj_line_id , fnd_api.g_miss_num, NULL, NULL, parent_adj_line_id , p_parent_adj_line_id),
169: start_date_active = DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, null, start_date_active, p_start_date_active),
170: end_date_active = DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, null , end_date_active, p_end_date_active),

Line 167: benefit_price_list_line_id = DECODE(p_benefit_price_list_line_id, FND_API.G_MISS_NUM , NULL, null, benefit_price_list_line_id, p_benefit_price_list_line_id),

163: tier_type = DECODE( p_tier_type, FND_API.g_miss_char, NULL, NULL, tier_type, p_tier_type),
164: td_discount = DECODE(p_td_discount , FND_API.g_miss_num, NULL, NULL, td_discount, p_td_discount),
165: td_discount_type = DECODE(p_td_discount_type, FND_API.g_miss_char, NULL, NULL,td_discount_type, p_td_discount_type),
166: quantity = DECODE(p_quantity , FND_API.G_MISS_NUM, NULL,null, quantity, p_quantity),
167: benefit_price_list_line_id = DECODE(p_benefit_price_list_line_id, FND_API.G_MISS_NUM , NULL, null, benefit_price_list_line_id, p_benefit_price_list_line_id),
168: parent_adj_line_id = DECODE(p_parent_adj_line_id , fnd_api.g_miss_num, NULL, NULL, parent_adj_line_id , p_parent_adj_line_id),
169: start_date_active = DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, null, start_date_active, p_start_date_active),
170: end_date_active = DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, null , end_date_active, p_end_date_active),
171: 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 168: parent_adj_line_id = DECODE(p_parent_adj_line_id , fnd_api.g_miss_num, NULL, NULL, parent_adj_line_id , p_parent_adj_line_id),

164: td_discount = DECODE(p_td_discount , FND_API.g_miss_num, NULL, NULL, td_discount, p_td_discount),
165: td_discount_type = DECODE(p_td_discount_type, FND_API.g_miss_char, NULL, NULL,td_discount_type, p_td_discount_type),
166: quantity = DECODE(p_quantity , FND_API.G_MISS_NUM, NULL,null, quantity, p_quantity),
167: benefit_price_list_line_id = DECODE(p_benefit_price_list_line_id, FND_API.G_MISS_NUM , NULL, null, benefit_price_list_line_id, p_benefit_price_list_line_id),
168: parent_adj_line_id = DECODE(p_parent_adj_line_id , fnd_api.g_miss_num, NULL, NULL, parent_adj_line_id , p_parent_adj_line_id),
169: start_date_active = DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, null, start_date_active, p_start_date_active),
170: end_date_active = DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, null , end_date_active, p_end_date_active),
171: 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),
172: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 169: start_date_active = DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, null, start_date_active, p_start_date_active),

165: td_discount_type = DECODE(p_td_discount_type, FND_API.g_miss_char, NULL, NULL,td_discount_type, p_td_discount_type),
166: quantity = DECODE(p_quantity , FND_API.G_MISS_NUM, NULL,null, quantity, p_quantity),
167: benefit_price_list_line_id = DECODE(p_benefit_price_list_line_id, FND_API.G_MISS_NUM , NULL, null, benefit_price_list_line_id, p_benefit_price_list_line_id),
168: parent_adj_line_id = DECODE(p_parent_adj_line_id , fnd_api.g_miss_num, NULL, NULL, parent_adj_line_id , p_parent_adj_line_id),
169: start_date_active = DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, null, start_date_active, p_start_date_active),
170: end_date_active = DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, null , end_date_active, p_end_date_active),
171: 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),
172: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
173: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 170: end_date_active = DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, null , end_date_active, p_end_date_active),

166: quantity = DECODE(p_quantity , FND_API.G_MISS_NUM, NULL,null, quantity, p_quantity),
167: benefit_price_list_line_id = DECODE(p_benefit_price_list_line_id, FND_API.G_MISS_NUM , NULL, null, benefit_price_list_line_id, p_benefit_price_list_line_id),
168: parent_adj_line_id = DECODE(p_parent_adj_line_id , fnd_api.g_miss_num, NULL, NULL, parent_adj_line_id , p_parent_adj_line_id),
169: start_date_active = DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, null, start_date_active, p_start_date_active),
170: end_date_active = DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, null , end_date_active, p_end_date_active),
171: 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),
172: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
173: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
174: object_version_number = nvl(p_object_version_number,0) + 1

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

167: benefit_price_list_line_id = DECODE(p_benefit_price_list_line_id, FND_API.G_MISS_NUM , NULL, null, benefit_price_list_line_id, p_benefit_price_list_line_id),
168: parent_adj_line_id = DECODE(p_parent_adj_line_id , fnd_api.g_miss_num, NULL, NULL, parent_adj_line_id , p_parent_adj_line_id),
169: start_date_active = DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, null, start_date_active, p_start_date_active),
170: end_date_active = DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, null , end_date_active, p_end_date_active),
171: 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),
172: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
173: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
174: object_version_number = nvl(p_object_version_number,0) + 1
175: WHERE OFFER_ADJ_NEW_LINE_ID = p_OFFER_ADJ_NEW_LINE_ID

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

168: parent_adj_line_id = DECODE(p_parent_adj_line_id , fnd_api.g_miss_num, NULL, NULL, parent_adj_line_id , p_parent_adj_line_id),
169: start_date_active = DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, null, start_date_active, p_start_date_active),
170: end_date_active = DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, null , end_date_active, p_end_date_active),
171: 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),
172: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
173: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
174: object_version_number = nvl(p_object_version_number,0) + 1
175: WHERE OFFER_ADJ_NEW_LINE_ID = p_OFFER_ADJ_NEW_LINE_ID
176: AND object_version_number = p_object_version_number;

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

169: start_date_active = DECODE( p_start_date_active, FND_API.G_MISS_DATE , null, null, start_date_active, p_start_date_active),
170: end_date_active = DECODE( p_end_date_active, FND_API.G_MISS_DATE , null, null , end_date_active, p_end_date_active),
171: 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),
172: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
173: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
174: object_version_number = nvl(p_object_version_number,0) + 1
175: WHERE OFFER_ADJ_NEW_LINE_ID = p_OFFER_ADJ_NEW_LINE_ID
176: AND object_version_number = p_object_version_number;
177:

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

175: WHERE OFFER_ADJ_NEW_LINE_ID = p_OFFER_ADJ_NEW_LINE_ID
176: AND object_version_number = p_object_version_number;
177:
178: IF (SQL%NOTFOUND) THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181: END Update_Row;
182:
183:

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

203: BEGIN
204: DELETE FROM OZF_OFFER_ADJ_NEW_LINES
205: WHERE OFFER_ADJ_NEW_LINE_ID = p_OFFER_ADJ_NEW_LINE_ID;
206: If (SQL%NOTFOUND) then
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: End If;
209: END Delete_Row ;
210:
211: