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

Line 63: DECODE(px_market_preset_tier_id, FND_API.G_MISS_NUM, null, px_market_preset_tier_id)

59: , last_update_login
60: )
61: VALUES
62: (
63: DECODE(px_market_preset_tier_id, FND_API.G_MISS_NUM, null, px_market_preset_tier_id)
64: , DECODE(p_offer_market_option_id , FND_API.G_MISS_NUM, null, p_offer_market_option_id)
65: , DECODE(p_pbh_offer_discount_id , FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
66: , DECODE(p_dis_offer_discount_id , FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
67: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)

Line 64: , DECODE(p_offer_market_option_id , FND_API.G_MISS_NUM, null, p_offer_market_option_id)

60: )
61: VALUES
62: (
63: DECODE(px_market_preset_tier_id, FND_API.G_MISS_NUM, null, px_market_preset_tier_id)
64: , DECODE(p_offer_market_option_id , FND_API.G_MISS_NUM, null, p_offer_market_option_id)
65: , DECODE(p_pbh_offer_discount_id , FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
66: , DECODE(p_dis_offer_discount_id , FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
67: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
68: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)

Line 65: , DECODE(p_pbh_offer_discount_id , FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)

61: VALUES
62: (
63: DECODE(px_market_preset_tier_id, FND_API.G_MISS_NUM, null, px_market_preset_tier_id)
64: , DECODE(p_offer_market_option_id , FND_API.G_MISS_NUM, null, p_offer_market_option_id)
65: , DECODE(p_pbh_offer_discount_id , FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
66: , DECODE(p_dis_offer_discount_id , FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
67: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
68: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
69: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)

Line 66: , DECODE(p_dis_offer_discount_id , FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)

62: (
63: DECODE(px_market_preset_tier_id, FND_API.G_MISS_NUM, null, px_market_preset_tier_id)
64: , DECODE(p_offer_market_option_id , FND_API.G_MISS_NUM, null, p_offer_market_option_id)
65: , DECODE(p_pbh_offer_discount_id , FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
66: , DECODE(p_dis_offer_discount_id , FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
67: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
68: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
69: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
70: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)

Line 67: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)

63: DECODE(px_market_preset_tier_id, FND_API.G_MISS_NUM, null, px_market_preset_tier_id)
64: , DECODE(p_offer_market_option_id , FND_API.G_MISS_NUM, null, p_offer_market_option_id)
65: , DECODE(p_pbh_offer_discount_id , FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
66: , DECODE(p_dis_offer_discount_id , FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
67: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
68: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
69: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
70: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
71: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)

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

64: , DECODE(p_offer_market_option_id , FND_API.G_MISS_NUM, null, p_offer_market_option_id)
65: , DECODE(p_pbh_offer_discount_id , FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
66: , DECODE(p_dis_offer_discount_id , FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
67: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
68: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
69: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
70: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
71: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
72: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)

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

65: , DECODE(p_pbh_offer_discount_id , FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
66: , DECODE(p_dis_offer_discount_id , FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
67: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
68: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
69: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
70: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
71: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
72: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
73: );

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

66: , DECODE(p_dis_offer_discount_id , FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
67: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
68: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
69: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
70: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
71: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
72: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
73: );
74: END Insert_Row;

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

67: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, null, px_object_version_number)
68: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
69: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
70: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
71: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
72: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
73: );
74: END Insert_Row;
75:

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

68: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
69: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
70: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
71: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
72: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
73: );
74: END Insert_Row;
75:
76: -- ========================================================

Line 101: set market_preset_tier_id = DECODE(p_market_preset_tier_id, null, market_preset_tier_id, FND_API.G_MISS_NUM, null, p_market_preset_tier_id)

97: )
98: IS
99: BEGIN
100: UPDATE ozf_market_preset_tiers
101: set market_preset_tier_id = DECODE(p_market_preset_tier_id, null, market_preset_tier_id, FND_API.G_MISS_NUM, null, p_market_preset_tier_id)
102: , offer_market_option_id = DECODE(p_offer_market_option_id , null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id)
103: , pbh_offer_discount_id = DECODE(p_pbh_offer_discount_id, null, pbh_offer_discount_id, FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
104: , dis_offer_discount_id =DECODE(p_dis_offer_discount_id, null, dis_offer_discount_id, FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
105: , object_version_number = nvl(p_object_version_number,0) + 1

Line 102: , offer_market_option_id = DECODE(p_offer_market_option_id , null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id)

98: IS
99: BEGIN
100: UPDATE ozf_market_preset_tiers
101: set market_preset_tier_id = DECODE(p_market_preset_tier_id, null, market_preset_tier_id, FND_API.G_MISS_NUM, null, p_market_preset_tier_id)
102: , offer_market_option_id = DECODE(p_offer_market_option_id , null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id)
103: , pbh_offer_discount_id = DECODE(p_pbh_offer_discount_id, null, pbh_offer_discount_id, FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
104: , dis_offer_discount_id =DECODE(p_dis_offer_discount_id, null, dis_offer_discount_id, FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
105: , object_version_number = nvl(p_object_version_number,0) + 1
106: , 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 103: , pbh_offer_discount_id = DECODE(p_pbh_offer_discount_id, null, pbh_offer_discount_id, FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)

99: BEGIN
100: UPDATE ozf_market_preset_tiers
101: set market_preset_tier_id = DECODE(p_market_preset_tier_id, null, market_preset_tier_id, FND_API.G_MISS_NUM, null, p_market_preset_tier_id)
102: , offer_market_option_id = DECODE(p_offer_market_option_id , null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id)
103: , pbh_offer_discount_id = DECODE(p_pbh_offer_discount_id, null, pbh_offer_discount_id, FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
104: , dis_offer_discount_id =DECODE(p_dis_offer_discount_id, null, dis_offer_discount_id, FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
105: , object_version_number = nvl(p_object_version_number,0) + 1
106: , 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)
107: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)

Line 104: , dis_offer_discount_id =DECODE(p_dis_offer_discount_id, null, dis_offer_discount_id, FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)

100: UPDATE ozf_market_preset_tiers
101: set market_preset_tier_id = DECODE(p_market_preset_tier_id, null, market_preset_tier_id, FND_API.G_MISS_NUM, null, p_market_preset_tier_id)
102: , offer_market_option_id = DECODE(p_offer_market_option_id , null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id)
103: , pbh_offer_discount_id = DECODE(p_pbh_offer_discount_id, null, pbh_offer_discount_id, FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
104: , dis_offer_discount_id =DECODE(p_dis_offer_discount_id, null, dis_offer_discount_id, FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
105: , object_version_number = nvl(p_object_version_number,0) + 1
106: , 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)
107: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
108: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

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

102: , offer_market_option_id = DECODE(p_offer_market_option_id , null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id)
103: , pbh_offer_discount_id = DECODE(p_pbh_offer_discount_id, null, pbh_offer_discount_id, FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
104: , dis_offer_discount_id =DECODE(p_dis_offer_discount_id, null, dis_offer_discount_id, FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
105: , object_version_number = nvl(p_object_version_number,0) + 1
106: , 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)
107: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
108: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
109: WHERE market_preset_tier_id = p_market_preset_tier_id
110: AND object_version_number = p_object_version_number;

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

103: , pbh_offer_discount_id = DECODE(p_pbh_offer_discount_id, null, pbh_offer_discount_id, FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
104: , dis_offer_discount_id =DECODE(p_dis_offer_discount_id, null, dis_offer_discount_id, FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
105: , object_version_number = nvl(p_object_version_number,0) + 1
106: , 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)
107: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
108: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
109: WHERE market_preset_tier_id = p_market_preset_tier_id
110: AND object_version_number = p_object_version_number;
111:

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

104: , dis_offer_discount_id =DECODE(p_dis_offer_discount_id, null, dis_offer_discount_id, FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)
105: , object_version_number = nvl(p_object_version_number,0) + 1
106: , 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)
107: , last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by)
108: , last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
109: WHERE market_preset_tier_id = p_market_preset_tier_id
110: AND object_version_number = p_object_version_number;
111:
112: IF (SQL%NOTFOUND) THEN

Line 113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

109: WHERE market_preset_tier_id = p_market_preset_tier_id
110: AND object_version_number = p_object_version_number;
111:
112: IF (SQL%NOTFOUND) THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:
116: END Update_Row;
117:

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

137: WHERE market_preset_tier_id = p_market_preset_tier_id
138: AND object_version_number = p_object_version_number;
139:
140: IF (SQL%NOTFOUND) THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: END Delete_Row;
145:

Line 177: RAISE FND_API.g_exc_error;

173: FETCH C INTO Recinfo;
174: IF (c%NOTFOUND) THEN
175: CLOSE C;
176: Ozf_utility_pvt.Error_message('AMS_API_RECORD_NOT_FOUND');
177: RAISE FND_API.g_exc_error;
178: END IF;
179: CLOSE C;
180: END Lock_Row;
181: