APPS.CN_CREDIT_TYPE_CONV_PVT dependencies on CN_CREDIT_CONV_FCTS

Line 60: FROM cn_credit_conv_fcts

56: l_conv_id number;
57: l_loading_status varchar2(80);
58: CURSOR l_similar_conv_csr IS
59: SELECT from_credit_type_id, to_credit_type_id, start_date, end_date
60: FROM cn_credit_conv_fcts
61: WHERE from_credit_type_id = p_from_credit_type
62: AND to_credit_type_id = p_to_credit_type;
63: BEGIN
64: -- Standard Start of API savepoint

Line 109: SELECT cn_credit_conv_fcts_s.nextval

105: fnd_msg_pub.ADD;
106: RAISE fnd_api.g_exc_error;
107: END IF;
108:
109: SELECT cn_credit_conv_fcts_s.nextval
110: INTO l_conv_id
111: FROM dual;
112:
113: CN_CREDIT_CONV_FCTS_PKG.Insert_Row(

Line 113: CN_CREDIT_CONV_FCTS_PKG.Insert_Row(

109: SELECT cn_credit_conv_fcts_s.nextval
110: INTO l_conv_id
111: FROM dual;
112:
113: CN_CREDIT_CONV_FCTS_PKG.Insert_Row(
114: x_credit_conv_fct_id => l_conv_id,
115: x_from_credit_type_id => p_from_credit_type,
116: x_to_credit_type_id => p_to_credit_type,
117: x_conversion_factor => p_conv_factor,

Line 235: FROM cn_credit_conv_fcts

231: l_loading_status varchar2(80);
232:
233: CURSOR l_ovn_csr IS
234: SELECT object_version_number
235: FROM cn_credit_conv_fcts
236: WHERE credit_conv_fct_id = p_conv_id;
237:
238: CURSOR l_similar_conv_csr IS
239: SELECT from_credit_type_id, to_credit_type_id, start_date, end_date

Line 240: FROM cn_credit_conv_fcts

236: WHERE credit_conv_fct_id = p_conv_id;
237:
238: CURSOR l_similar_conv_csr IS
239: SELECT from_credit_type_id, to_credit_type_id, start_date, end_date
240: FROM cn_credit_conv_fcts
241: WHERE from_credit_type_id = p_from_credit_type
242: AND to_credit_type_id = p_to_credit_type
243: AND credit_conv_fct_id <> p_conv_id;
244: BEGIN

Line 300: CN_CREDIT_CONV_FCTS_PKG.Update_Row(

296: fnd_msg_pub.ADD;
297: RAISE fnd_api.g_exc_error;
298: END IF;
299:
300: CN_CREDIT_CONV_FCTS_PKG.Update_Row(
301: x_credit_conv_fct_id => p_conv_id,
302: x_object_version => p_object_version,
303: x_from_credit_type_id => p_from_credit_type,
304: x_to_credit_type_id => p_to_credit_type,

Line 410: FROM cn_credit_conv_fcts

406: l_api_version CONSTANT NUMBER := 1.0;
407: l_object_version number := 0;
408: CURSOR l_ovn_csr IS
409: SELECT object_version_number
410: FROM cn_credit_conv_fcts
411: WHERE credit_conv_fct_id = p_conv_id;
412: BEGIN
413: -- Standard Start of API savepoint
414: SAVEPOINT delete_conversion_pvt;

Line 441: CN_CREDIT_CONV_FCTS_PKG.Delete_Row(x_credit_conv_fct_id => p_conv_id);

437: fnd_msg_pub.ADD;
438: RAISE fnd_api.g_exc_error;
439: END IF;
440:
441: CN_CREDIT_CONV_FCTS_PKG.Delete_Row(x_credit_conv_fct_id => p_conv_id);
442:
443: -- End of API body.
444: -- Standard check of p_commit.
445: IF FND_API.To_Boolean( p_commit ) THEN