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

Line 60: DECODE(px_qp_product_id , FND_API.G_MISS_NUM, null, px_qp_product_id)

56: , last_update_login
57: )
58: values
59: (
60: DECODE(px_qp_product_id , FND_API.G_MISS_NUM, null, px_qp_product_id)
61: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
62: , DECODE(p_pricing_attribute_id, FND_API.G_MISS_NUM, NULL, p_pricing_attribute_id)
63: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
64: , DECODE(p_last_update_date, FND_API.G_MISS_DATE,sysdate, p_last_update_date)

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

57: )
58: values
59: (
60: DECODE(px_qp_product_id , FND_API.G_MISS_NUM, null, px_qp_product_id)
61: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
62: , DECODE(p_pricing_attribute_id, FND_API.G_MISS_NUM, NULL, p_pricing_attribute_id)
63: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
64: , DECODE(p_last_update_date, FND_API.G_MISS_DATE,sysdate, p_last_update_date)
65: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)

Line 62: , DECODE(p_pricing_attribute_id, FND_API.G_MISS_NUM, NULL, p_pricing_attribute_id)

58: values
59: (
60: DECODE(px_qp_product_id , FND_API.G_MISS_NUM, null, px_qp_product_id)
61: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
62: , DECODE(p_pricing_attribute_id, FND_API.G_MISS_NUM, NULL, p_pricing_attribute_id)
63: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
64: , DECODE(p_last_update_date, FND_API.G_MISS_DATE,sysdate, p_last_update_date)
65: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
66: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)

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

59: (
60: DECODE(px_qp_product_id , FND_API.G_MISS_NUM, null, px_qp_product_id)
61: , DECODE(p_off_discount_product_id , FND_API.G_MISS_NUM , NULL, p_off_discount_product_id)
62: , DECODE(p_pricing_attribute_id, FND_API.G_MISS_NUM, NULL, p_pricing_attribute_id)
63: , DECODE(px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number)
64: , DECODE(p_last_update_date, FND_API.G_MISS_DATE,sysdate, p_last_update_date)
65: , DECODE(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id, p_last_updated_by)
66: , DECODE(p_creation_date, FND_API.G_MISS_DATE, sysdate, p_creation_date)
67: , DECODE(p_created_by , FND_API.G_MISS_NUM,FND_GLOBAL.user_id, p_created_by)

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

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

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

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

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

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

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

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

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

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

Line 98: qp_product_id = DECODE(p_qp_product_id , NULL, qp_product_id, FND_API.G_MISS_NUM, null, p_qp_product_id)

94: IS
95: BEGIN
96: UPDATE ozf_qp_products
97: SET
98: qp_product_id = DECODE(p_qp_product_id , NULL, qp_product_id, FND_API.G_MISS_NUM, null, p_qp_product_id)
99: , off_discount_product_id = DECODE(p_off_discount_product_id, NULL , off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
100: , pricing_attribute_id = DECODE(p_pricing_attribute_id, NULL, pricing_attribute_id, FND_API.G_MISS_NUM,NULL, p_pricing_attribute_id)
101: , object_version_number = nvl(p_object_version_number,0)+1
102: , 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 99: , off_discount_product_id = DECODE(p_off_discount_product_id, NULL , off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)

95: BEGIN
96: UPDATE ozf_qp_products
97: SET
98: qp_product_id = DECODE(p_qp_product_id , NULL, qp_product_id, FND_API.G_MISS_NUM, null, p_qp_product_id)
99: , off_discount_product_id = DECODE(p_off_discount_product_id, NULL , off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
100: , pricing_attribute_id = DECODE(p_pricing_attribute_id, NULL, pricing_attribute_id, FND_API.G_MISS_NUM,NULL, p_pricing_attribute_id)
101: , object_version_number = nvl(p_object_version_number,0)+1
102: , 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)
103: , last_updated_by = DECODE(p_last_updated_by, NULL, last_updated_by, FND_API.G_MISS_NUM,null, p_last_updated_by)

Line 100: , pricing_attribute_id = DECODE(p_pricing_attribute_id, NULL, pricing_attribute_id, FND_API.G_MISS_NUM,NULL, p_pricing_attribute_id)

96: UPDATE ozf_qp_products
97: SET
98: qp_product_id = DECODE(p_qp_product_id , NULL, qp_product_id, FND_API.G_MISS_NUM, null, p_qp_product_id)
99: , off_discount_product_id = DECODE(p_off_discount_product_id, NULL , off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
100: , pricing_attribute_id = DECODE(p_pricing_attribute_id, NULL, pricing_attribute_id, FND_API.G_MISS_NUM,NULL, p_pricing_attribute_id)
101: , object_version_number = nvl(p_object_version_number,0)+1
102: , 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)
103: , last_updated_by = DECODE(p_last_updated_by, NULL, last_updated_by, FND_API.G_MISS_NUM,null, p_last_updated_by)
104: , last_update_login = DECODE(p_last_update_login, NULL, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

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

98: qp_product_id = DECODE(p_qp_product_id , NULL, qp_product_id, FND_API.G_MISS_NUM, null, p_qp_product_id)
99: , off_discount_product_id = DECODE(p_off_discount_product_id, NULL , off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
100: , pricing_attribute_id = DECODE(p_pricing_attribute_id, NULL, pricing_attribute_id, FND_API.G_MISS_NUM,NULL, p_pricing_attribute_id)
101: , object_version_number = nvl(p_object_version_number,0)+1
102: , 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)
103: , last_updated_by = DECODE(p_last_updated_by, NULL, last_updated_by, FND_API.G_MISS_NUM,null, p_last_updated_by)
104: , last_update_login = DECODE(p_last_update_login, NULL, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
105: WHERE qp_product_id = p_qp_product_id
106: AND object_version_number = p_object_version_number;

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

99: , off_discount_product_id = DECODE(p_off_discount_product_id, NULL , off_discount_product_id, FND_API.G_MISS_NUM, NULL, p_off_discount_product_id)
100: , pricing_attribute_id = DECODE(p_pricing_attribute_id, NULL, pricing_attribute_id, FND_API.G_MISS_NUM,NULL, p_pricing_attribute_id)
101: , object_version_number = nvl(p_object_version_number,0)+1
102: , 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)
103: , last_updated_by = DECODE(p_last_updated_by, NULL, last_updated_by, FND_API.G_MISS_NUM,null, p_last_updated_by)
104: , last_update_login = DECODE(p_last_update_login, NULL, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
105: WHERE qp_product_id = p_qp_product_id
106: AND object_version_number = p_object_version_number;
107:

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

100: , pricing_attribute_id = DECODE(p_pricing_attribute_id, NULL, pricing_attribute_id, FND_API.G_MISS_NUM,NULL, p_pricing_attribute_id)
101: , object_version_number = nvl(p_object_version_number,0)+1
102: , 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)
103: , last_updated_by = DECODE(p_last_updated_by, NULL, last_updated_by, FND_API.G_MISS_NUM,null, p_last_updated_by)
104: , last_update_login = DECODE(p_last_update_login, NULL, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
105: WHERE qp_product_id = p_qp_product_id
106: AND object_version_number = p_object_version_number;
107:
108: IF (SQL%NOTFOUND) THEN

Line 109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

105: WHERE qp_product_id = p_qp_product_id
106: AND object_version_number = p_object_version_number;
107:
108: IF (SQL%NOTFOUND) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111:
112: END Update_Row;
113:

Line 136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

132: DELETE FROM ozf_qp_products
133: WHERE qp_product_id = p_qp_product_id
134: AND object_version_number = p_object_version_number;
135: If (SQL%NOTFOUND) then
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: End If;
138: END Delete_Row;
139:
140:

Line 173: RAISE FND_API.g_exc_error;

169: FETCH c INTO Recinfo;
170: IF (c%NOTFOUND) THEN
171: CLOSE c;
172: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
173: RAISE FND_API.g_exc_error;
174: END IF;
175: CLOSE c;
176: END Lock_Row;
177: