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

Line 70: DECODE( px_qualifier_market_option_id, FND_API.G_MISS_NUM, NULL, px_qualifier_market_option_id)

66: , last_update_login
67: )
68: VALUES
69: (
70: DECODE( px_qualifier_market_option_id, FND_API.G_MISS_NUM, NULL, px_qualifier_market_option_id)
71: , DECODE( p_offer_market_option_id, FND_API.G_MISS_NUM, NULL, p_offer_market_option_id)
72: , DECODE( p_qp_qualifier_id, FND_API.G_MISS_NUM, NULL, p_qp_qualifier_id)
73: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
74: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)

Line 71: , DECODE( p_offer_market_option_id, FND_API.G_MISS_NUM, NULL, p_offer_market_option_id)

67: )
68: VALUES
69: (
70: DECODE( px_qualifier_market_option_id, FND_API.G_MISS_NUM, NULL, px_qualifier_market_option_id)
71: , DECODE( p_offer_market_option_id, FND_API.G_MISS_NUM, NULL, p_offer_market_option_id)
72: , DECODE( p_qp_qualifier_id, FND_API.G_MISS_NUM, NULL, p_qp_qualifier_id)
73: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
74: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
75: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)

Line 72: , DECODE( p_qp_qualifier_id, FND_API.G_MISS_NUM, NULL, p_qp_qualifier_id)

68: VALUES
69: (
70: DECODE( px_qualifier_market_option_id, FND_API.G_MISS_NUM, NULL, px_qualifier_market_option_id)
71: , DECODE( p_offer_market_option_id, FND_API.G_MISS_NUM, NULL, p_offer_market_option_id)
72: , DECODE( p_qp_qualifier_id, FND_API.G_MISS_NUM, NULL, p_qp_qualifier_id)
73: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
74: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
75: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
76: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)

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

69: (
70: DECODE( px_qualifier_market_option_id, FND_API.G_MISS_NUM, NULL, px_qualifier_market_option_id)
71: , DECODE( p_offer_market_option_id, FND_API.G_MISS_NUM, NULL, p_offer_market_option_id)
72: , DECODE( p_qp_qualifier_id, FND_API.G_MISS_NUM, NULL, p_qp_qualifier_id)
73: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
74: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
75: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
76: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
77: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)

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

70: DECODE( px_qualifier_market_option_id, FND_API.G_MISS_NUM, NULL, px_qualifier_market_option_id)
71: , DECODE( p_offer_market_option_id, FND_API.G_MISS_NUM, NULL, p_offer_market_option_id)
72: , DECODE( p_qp_qualifier_id, FND_API.G_MISS_NUM, NULL, p_qp_qualifier_id)
73: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
74: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
75: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
76: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
77: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
78: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)

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

71: , DECODE( p_offer_market_option_id, FND_API.G_MISS_NUM, NULL, p_offer_market_option_id)
72: , DECODE( p_qp_qualifier_id, FND_API.G_MISS_NUM, NULL, p_qp_qualifier_id)
73: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
74: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
75: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
76: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
77: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
78: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
79: );

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

72: , DECODE( p_qp_qualifier_id, FND_API.G_MISS_NUM, NULL, p_qp_qualifier_id)
73: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
74: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
75: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
76: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
77: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
78: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
79: );
80:

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

73: , DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
74: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
75: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
76: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
77: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
78: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
79: );
80:
81: END Insert_Row;

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

74: , DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date)
75: , DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by)
76: , DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date)
77: , DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by)
78: , DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login)
79: );
80:
81: END Insert_Row;
82:

Line 109: qualifier_market_option_id = DECODE(p_qualifier_market_option_id , null, qualifier_market_option_id , FND_API.G_MISS_NUM, null, p_qualifier_market_option_id),

105: IS
106: BEGIN
107: Update ozf_qualifier_market_option
108: SET
109: qualifier_market_option_id = DECODE(p_qualifier_market_option_id , null, qualifier_market_option_id , FND_API.G_MISS_NUM, null, p_qualifier_market_option_id),
110: 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),
111: qp_qualifier_id = DECODE( p_qp_qualifier_id , null, qp_qualifier_id , FND_API.G_MISS_NUM, null, p_qp_qualifier_id),
112: 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),
113: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

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

106: BEGIN
107: Update ozf_qualifier_market_option
108: SET
109: qualifier_market_option_id = DECODE(p_qualifier_market_option_id , null, qualifier_market_option_id , FND_API.G_MISS_NUM, null, p_qualifier_market_option_id),
110: 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),
111: qp_qualifier_id = DECODE( p_qp_qualifier_id , null, qp_qualifier_id , FND_API.G_MISS_NUM, null, p_qp_qualifier_id),
112: 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),
113: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
114: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 111: qp_qualifier_id = DECODE( p_qp_qualifier_id , null, qp_qualifier_id , FND_API.G_MISS_NUM, null, p_qp_qualifier_id),

107: Update ozf_qualifier_market_option
108: SET
109: qualifier_market_option_id = DECODE(p_qualifier_market_option_id , null, qualifier_market_option_id , FND_API.G_MISS_NUM, null, p_qualifier_market_option_id),
110: 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),
111: qp_qualifier_id = DECODE( p_qp_qualifier_id , null, qp_qualifier_id , FND_API.G_MISS_NUM, null, p_qp_qualifier_id),
112: 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),
113: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
114: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
115: object_version_number = nvl(p_object_version_number,0) + 1

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

108: SET
109: qualifier_market_option_id = DECODE(p_qualifier_market_option_id , null, qualifier_market_option_id , FND_API.G_MISS_NUM, null, p_qualifier_market_option_id),
110: 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),
111: qp_qualifier_id = DECODE( p_qp_qualifier_id , null, qp_qualifier_id , FND_API.G_MISS_NUM, null, p_qp_qualifier_id),
112: 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),
113: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
114: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
115: object_version_number = nvl(p_object_version_number,0) + 1
116: WHERE qualifier_market_option_id = p_qualifier_market_option_id

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

109: qualifier_market_option_id = DECODE(p_qualifier_market_option_id , null, qualifier_market_option_id , FND_API.G_MISS_NUM, null, p_qualifier_market_option_id),
110: 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),
111: qp_qualifier_id = DECODE( p_qp_qualifier_id , null, qp_qualifier_id , FND_API.G_MISS_NUM, null, p_qp_qualifier_id),
112: 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),
113: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
114: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
115: object_version_number = nvl(p_object_version_number,0) + 1
116: WHERE qualifier_market_option_id = p_qualifier_market_option_id
117: AND object_version_number = p_object_version_number;

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

110: 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),
111: qp_qualifier_id = DECODE( p_qp_qualifier_id , null, qp_qualifier_id , FND_API.G_MISS_NUM, null, p_qp_qualifier_id),
112: 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),
113: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
114: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
115: object_version_number = nvl(p_object_version_number,0) + 1
116: WHERE qualifier_market_option_id = p_qualifier_market_option_id
117: AND object_version_number = p_object_version_number;
118:

Line 121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

117: AND object_version_number = p_object_version_number;
118:
119:
120: IF (SQL%NOTFOUND) THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124:
125: END Update_Row;

Line 148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

144: DELETE FROM ozf_qualifier_market_option
145: WHERE qualifier_market_option_id = p_qualifier_market_option_id
146: AND object_version_number = p_object_version_number;
147: If (SQL%NOTFOUND) then
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: End If;
150: END Delete_Row ;
151:
152:

Line 183: RAISE FND_API.g_exc_error;

179: FETCH c INTO Recinfo;
180: IF (c%NOTFOUND) THEN
181: CLOSE c;
182: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
183: RAISE FND_API.g_exc_error;
184: END IF;
185: CLOSE c;
186: END Lock_Row;
187: