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

Line 80: DECODE(px_offer_adjst_tier_id, FND_API.G_MISS_NUM,NULL, px_offer_adjst_tier_id),

76: created_by,
77: last_update_login,
78: object_version_number
79: ) VALUES (
80: DECODE(px_offer_adjst_tier_id, FND_API.G_MISS_NUM,NULL, px_offer_adjst_tier_id),
81: DECODE(p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
82: decode(p_volume_offer_tiers_id, fnd_api.g_miss_num, null, p_volume_offer_tiers_id),
83: DECODE(p_qp_list_header_id, fnd_api.g_miss_num, null, p_qp_list_header_id),
84: DECODE(p_discount_type_code, FND_API.G_MISS_CHAR, NULL, p_discount_type_code),

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

77: last_update_login,
78: object_version_number
79: ) VALUES (
80: DECODE(px_offer_adjst_tier_id, FND_API.G_MISS_NUM,NULL, px_offer_adjst_tier_id),
81: DECODE(p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
82: decode(p_volume_offer_tiers_id, fnd_api.g_miss_num, null, p_volume_offer_tiers_id),
83: DECODE(p_qp_list_header_id, fnd_api.g_miss_num, null, p_qp_list_header_id),
84: DECODE(p_discount_type_code, FND_API.G_MISS_CHAR, NULL, p_discount_type_code),
85: decode(p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),

Line 82: decode(p_volume_offer_tiers_id, fnd_api.g_miss_num, null, p_volume_offer_tiers_id),

78: object_version_number
79: ) VALUES (
80: DECODE(px_offer_adjst_tier_id, FND_API.G_MISS_NUM,NULL, px_offer_adjst_tier_id),
81: DECODE(p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
82: decode(p_volume_offer_tiers_id, fnd_api.g_miss_num, null, p_volume_offer_tiers_id),
83: DECODE(p_qp_list_header_id, fnd_api.g_miss_num, null, p_qp_list_header_id),
84: DECODE(p_discount_type_code, FND_API.G_MISS_CHAR, NULL, p_discount_type_code),
85: decode(p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
86: DECODE(p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),

Line 83: DECODE(p_qp_list_header_id, fnd_api.g_miss_num, null, p_qp_list_header_id),

79: ) VALUES (
80: DECODE(px_offer_adjst_tier_id, FND_API.G_MISS_NUM,NULL, px_offer_adjst_tier_id),
81: DECODE(p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
82: decode(p_volume_offer_tiers_id, fnd_api.g_miss_num, null, p_volume_offer_tiers_id),
83: DECODE(p_qp_list_header_id, fnd_api.g_miss_num, null, p_qp_list_header_id),
84: DECODE(p_discount_type_code, FND_API.G_MISS_CHAR, NULL, p_discount_type_code),
85: decode(p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
86: DECODE(p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
87: decode(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),

Line 84: DECODE(p_discount_type_code, FND_API.G_MISS_CHAR, NULL, p_discount_type_code),

80: DECODE(px_offer_adjst_tier_id, FND_API.G_MISS_NUM,NULL, px_offer_adjst_tier_id),
81: DECODE(p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
82: decode(p_volume_offer_tiers_id, fnd_api.g_miss_num, null, p_volume_offer_tiers_id),
83: DECODE(p_qp_list_header_id, fnd_api.g_miss_num, null, p_qp_list_header_id),
84: DECODE(p_discount_type_code, FND_API.G_MISS_CHAR, NULL, p_discount_type_code),
85: decode(p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
86: DECODE(p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
87: decode(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 85: decode(p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),

81: DECODE(p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
82: decode(p_volume_offer_tiers_id, fnd_api.g_miss_num, null, p_volume_offer_tiers_id),
83: DECODE(p_qp_list_header_id, fnd_api.g_miss_num, null, p_qp_list_header_id),
84: DECODE(p_discount_type_code, FND_API.G_MISS_CHAR, NULL, p_discount_type_code),
85: decode(p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
86: DECODE(p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
87: decode(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

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

82: decode(p_volume_offer_tiers_id, fnd_api.g_miss_num, null, p_volume_offer_tiers_id),
83: DECODE(p_qp_list_header_id, fnd_api.g_miss_num, null, p_qp_list_header_id),
84: DECODE(p_discount_type_code, FND_API.G_MISS_CHAR, NULL, p_discount_type_code),
85: decode(p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
86: DECODE(p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
87: decode(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 87: decode(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),

83: DECODE(p_qp_list_header_id, fnd_api.g_miss_num, null, p_qp_list_header_id),
84: DECODE(p_discount_type_code, FND_API.G_MISS_CHAR, NULL, p_discount_type_code),
85: decode(p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
86: DECODE(p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
87: decode(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

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

84: DECODE(p_discount_type_code, FND_API.G_MISS_CHAR, NULL, p_discount_type_code),
85: decode(p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
86: DECODE(p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
87: decode(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

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

85: decode(p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
86: DECODE(p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
87: decode(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));

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

86: DECODE(p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
87: decode(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
94:

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

87: decode(p_offer_discount_line_id , FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
94:
95: END Insert_Row;

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

88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
94:
95: END Insert_Row;
96:

Line 93: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));

89: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
91: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
92: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
93: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
94:
95: END Insert_Row;
96:
97:

Line 130: offer_adjst_tier_id = DECODE( p_offer_adjst_tier_id, null, offer_adjst_tier_id, FND_API.G_MISS_NUM, null, p_offer_adjst_tier_id),

126: IS
127: BEGIN
128: Update ozf_offer_adjustment_tiers
129: SET
130: offer_adjst_tier_id = DECODE( p_offer_adjst_tier_id, null, offer_adjst_tier_id, FND_API.G_MISS_NUM, null, p_offer_adjst_tier_id),
131: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
132: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
133: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
134: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),

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

127: BEGIN
128: Update ozf_offer_adjustment_tiers
129: SET
130: offer_adjst_tier_id = DECODE( p_offer_adjst_tier_id, null, offer_adjst_tier_id, FND_API.G_MISS_NUM, null, p_offer_adjst_tier_id),
131: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
132: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
133: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
134: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
135: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),

Line 132: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),

128: Update ozf_offer_adjustment_tiers
129: SET
130: offer_adjst_tier_id = DECODE( p_offer_adjst_tier_id, null, offer_adjst_tier_id, FND_API.G_MISS_NUM, null, p_offer_adjst_tier_id),
131: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
132: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
133: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
134: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
135: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
136: modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),

Line 133: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),

129: SET
130: offer_adjst_tier_id = DECODE( p_offer_adjst_tier_id, null, offer_adjst_tier_id, FND_API.G_MISS_NUM, null, p_offer_adjst_tier_id),
131: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
132: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
133: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
134: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
135: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
136: modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
137: offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID , NULL, offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),

Line 134: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),

130: offer_adjst_tier_id = DECODE( p_offer_adjst_tier_id, null, offer_adjst_tier_id, FND_API.G_MISS_NUM, null, p_offer_adjst_tier_id),
131: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
132: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
133: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
134: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
135: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
136: modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
137: offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID , NULL, offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
138: 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 135: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),

131: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
132: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
133: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
134: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
135: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
136: modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
137: offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID , NULL, offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
138: 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),
139: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

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

132: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),
133: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
134: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
135: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
136: modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
137: offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID , NULL, offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
138: 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),
139: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 137: offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID , NULL, offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),

133: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
134: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
135: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
136: modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
137: offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID , NULL, offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
138: 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),
139: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
141: object_version_number = object_version_number + 1

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

134: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),
135: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
136: modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
137: offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID , NULL, offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
138: 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),
139: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
141: object_version_number = object_version_number + 1
142: WHERE offer_adjst_tier_id = p_offer_adjst_tier_id

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

135: original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
136: modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
137: offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID , NULL, offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
138: 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),
139: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
141: object_version_number = object_version_number + 1
142: WHERE offer_adjst_tier_id = p_offer_adjst_tier_id
143: AND object_version_number = px_object_version_number;

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

136: modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
137: offer_discount_line_id = DECODE(P_OFFER_DISCOUNT_LINE_ID , NULL, offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id),
138: 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),
139: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
140: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
141: object_version_number = object_version_number + 1
142: WHERE offer_adjst_tier_id = p_offer_adjst_tier_id
143: AND object_version_number = px_object_version_number;
144:

Line 147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

143: AND object_version_number = px_object_version_number;
144:
145:
146: IF (SQL%NOTFOUND) THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149:
150: px_object_version_number := nvl(px_object_version_number,0) + 1;
151:

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174: DELETE FROM ozf_offer_adjustment_tiers
175: WHERE offer_adjst_tier_id = p_offer_adjst_tier_id
176: AND object_version_number = p_object_version_number;
177: If (SQL%NOTFOUND) then
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: End If;
180: END Delete_Row ;
181:
182:

Line 216: RAISE FND_API.g_exc_error;

212: FETCH c INTO Recinfo;
213: IF (c%NOTFOUND) THEN
214: CLOSE c;
215: OZF_Utility_PVT.error_message ('OZF_API_RECORD_NOT_FOUND');
216: RAISE FND_API.g_exc_error;
217: END IF;
218: CLOSE c;
219: END Lock_Row;
220: