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

Line 59: DECODE(px_qp_discount_id, FND_API.G_MISS_NUM, NULL,px_qp_discount_id)

55: , last_update_login
56: )
57: VALUES
58: (
59: DECODE(px_qp_discount_id, FND_API.G_MISS_NUM, NULL,px_qp_discount_id)
60: , DECODE(p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
61: , DECODE(p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
62: , DECODE(px_object_version_number,FND_API.G_MISS_NUM, 1, px_object_version_number)
63: , DECODE(p_creation_date, FND_API.G_MISS_DATE,sysdate, p_creation_date)

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

56: )
57: VALUES
58: (
59: DECODE(px_qp_discount_id, FND_API.G_MISS_NUM, NULL,px_qp_discount_id)
60: , DECODE(p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
61: , DECODE(p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
62: , DECODE(px_object_version_number,FND_API.G_MISS_NUM, 1, px_object_version_number)
63: , DECODE(p_creation_date, FND_API.G_MISS_DATE,sysdate, p_creation_date)
64: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,p_created_by)

Line 61: , DECODE(p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)

57: VALUES
58: (
59: DECODE(px_qp_discount_id, FND_API.G_MISS_NUM, NULL,px_qp_discount_id)
60: , DECODE(p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
61: , DECODE(p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
62: , DECODE(px_object_version_number,FND_API.G_MISS_NUM, 1, px_object_version_number)
63: , DECODE(p_creation_date, FND_API.G_MISS_DATE,sysdate, p_creation_date)
64: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,p_created_by)
65: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)

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

58: (
59: DECODE(px_qp_discount_id, FND_API.G_MISS_NUM, NULL,px_qp_discount_id)
60: , DECODE(p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
61: , DECODE(p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
62: , DECODE(px_object_version_number,FND_API.G_MISS_NUM, 1, px_object_version_number)
63: , DECODE(p_creation_date, FND_API.G_MISS_DATE,sysdate, p_creation_date)
64: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,p_created_by)
65: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
66: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)

Line 63: , DECODE(p_creation_date, FND_API.G_MISS_DATE,sysdate, p_creation_date)

59: DECODE(px_qp_discount_id, FND_API.G_MISS_NUM, NULL,px_qp_discount_id)
60: , DECODE(p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
61: , DECODE(p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
62: , DECODE(px_object_version_number,FND_API.G_MISS_NUM, 1, px_object_version_number)
63: , DECODE(p_creation_date, FND_API.G_MISS_DATE,sysdate, p_creation_date)
64: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,p_created_by)
65: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
66: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
67: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id,p_last_update_login)

Line 64: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,p_created_by)

60: , DECODE(p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
61: , DECODE(p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
62: , DECODE(px_object_version_number,FND_API.G_MISS_NUM, 1, px_object_version_number)
63: , DECODE(p_creation_date, FND_API.G_MISS_DATE,sysdate, p_creation_date)
64: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,p_created_by)
65: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
66: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
67: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id,p_last_update_login)
68: );

Line 65: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)

61: , DECODE(p_offer_discount_line_id, FND_API.G_MISS_NUM, NULL, p_offer_discount_line_id)
62: , DECODE(px_object_version_number,FND_API.G_MISS_NUM, 1, px_object_version_number)
63: , DECODE(p_creation_date, FND_API.G_MISS_DATE,sysdate, p_creation_date)
64: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,p_created_by)
65: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
66: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
67: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id,p_last_update_login)
68: );
69: END Insert_Row;

Line 66: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)

62: , DECODE(px_object_version_number,FND_API.G_MISS_NUM, 1, px_object_version_number)
63: , DECODE(p_creation_date, FND_API.G_MISS_DATE,sysdate, p_creation_date)
64: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,p_created_by)
65: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
66: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
67: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id,p_last_update_login)
68: );
69: END Insert_Row;
70:

Line 67: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id,p_last_update_login)

63: , DECODE(p_creation_date, FND_API.G_MISS_DATE,sysdate, p_creation_date)
64: , DECODE(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,p_created_by)
65: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
66: , DECODE(p_last_update_date, FND_API.G_MISS_DATE, sysdate, p_last_update_date)
67: , DECODE(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.conc_login_id,p_last_update_login)
68: );
69: END Insert_Row;
70:
71: -- ========================================================

Line 96: ozf_qp_discount_id = DECODE(p_qp_discount_id, NULL, ozf_qp_discount_id, FND_API.G_MISS_NUM, NULL, p_qp_discount_id)

92: IS
93: BEGIN
94: UPDATE ozf_qp_discounts
95: SET
96: ozf_qp_discount_id = DECODE(p_qp_discount_id, NULL, ozf_qp_discount_id, FND_API.G_MISS_NUM, NULL, p_qp_discount_id)
97: , list_line_id = DECODE(p_list_line_id , NULL, list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
98: , 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)
99: , object_version_number = nvl(p_object_version_number,0)+1
100: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), last_update_date)

Line 97: , list_line_id = DECODE(p_list_line_id , NULL, list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)

93: BEGIN
94: UPDATE ozf_qp_discounts
95: SET
96: ozf_qp_discount_id = DECODE(p_qp_discount_id, NULL, ozf_qp_discount_id, FND_API.G_MISS_NUM, NULL, p_qp_discount_id)
97: , list_line_id = DECODE(p_list_line_id , NULL, list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
98: , 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)
99: , object_version_number = nvl(p_object_version_number,0)+1
100: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), last_update_date)
101: , last_updated_by = DECODE(p_last_updated_by, NULL, last_updated_by, FND_API.G_MISS_NUM,null, p_last_updated_by)

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

94: UPDATE ozf_qp_discounts
95: SET
96: ozf_qp_discount_id = DECODE(p_qp_discount_id, NULL, ozf_qp_discount_id, FND_API.G_MISS_NUM, NULL, p_qp_discount_id)
97: , list_line_id = DECODE(p_list_line_id , NULL, list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
98: , 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)
99: , object_version_number = nvl(p_object_version_number,0)+1
100: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), last_update_date)
101: , last_updated_by = DECODE(p_last_updated_by, NULL, last_updated_by, FND_API.G_MISS_NUM,null, p_last_updated_by)
102: , last_update_login = DECODE(p_last_update_login, NULL, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

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

96: ozf_qp_discount_id = DECODE(p_qp_discount_id, NULL, ozf_qp_discount_id, FND_API.G_MISS_NUM, NULL, p_qp_discount_id)
97: , list_line_id = DECODE(p_list_line_id , NULL, list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
98: , 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)
99: , object_version_number = nvl(p_object_version_number,0)+1
100: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), last_update_date)
101: , last_updated_by = DECODE(p_last_updated_by, NULL, last_updated_by, FND_API.G_MISS_NUM,null, p_last_updated_by)
102: , last_update_login = DECODE(p_last_update_login, NULL, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
103: WHERE ozf_qp_discount_id = p_qp_discount_id
104: AND object_version_number = p_object_version_number;

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

97: , list_line_id = DECODE(p_list_line_id , NULL, list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id)
98: , 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)
99: , object_version_number = nvl(p_object_version_number,0)+1
100: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), last_update_date)
101: , last_updated_by = DECODE(p_last_updated_by, NULL, last_updated_by, FND_API.G_MISS_NUM,null, p_last_updated_by)
102: , last_update_login = DECODE(p_last_update_login, NULL, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
103: WHERE ozf_qp_discount_id = p_qp_discount_id
104: AND object_version_number = p_object_version_number;
105:

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

98: , 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)
99: , object_version_number = nvl(p_object_version_number,0)+1
100: , last_update_date = DECODE(p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), last_update_date)
101: , last_updated_by = DECODE(p_last_updated_by, NULL, last_updated_by, FND_API.G_MISS_NUM,null, p_last_updated_by)
102: , last_update_login = DECODE(p_last_update_login, NULL, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
103: WHERE ozf_qp_discount_id = p_qp_discount_id
104: AND object_version_number = p_object_version_number;
105:
106: IF SQL%NOTFOUND THEN

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

103: WHERE ozf_qp_discount_id = p_qp_discount_id
104: AND object_version_number = p_object_version_number;
105:
106: IF SQL%NOTFOUND THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109:
110: END Update_Row;
111:

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: WHERE ozf_qp_discount_id = p_qp_discount_id
132: AND object_version_number = p_object_version_number;
133:
134: IF SQL%NOTFOUND THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137: END Delete_Row;
138:
139:

Line 170: RAISE FND_API.g_exc_error;

166: OPEN c;
167: FETCH c INTO recinfo;
168: IF c%NOTFOUND THEN
169: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
170: RAISE FND_API.g_exc_error;
171: END IF;
172: CLOSE C;
173: END Lock_Row;
174: