APPS.CSP_USAGE_HISTORIES_PVT dependencies on CSP_USAGE_HISTORIES

Line 1: PACKAGE BODY CSP_USAGE_HISTORIES_PVT AS

1: PACKAGE BODY CSP_USAGE_HISTORIES_PVT AS
2: /* $Header: cspvpuhb.pls 115.26 2004/04/07 22:49:19 hhaugeru ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):='CSP_USAGE_HISTORIES_PVT';
4:
5:

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30):='CSP_USAGE_HISTORIES_PVT';

1: PACKAGE BODY CSP_USAGE_HISTORIES_PVT AS
2: /* $Header: cspvpuhb.pls 115.26 2004/04/07 22:49:19 hhaugeru ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):='CSP_USAGE_HISTORIES_PVT';
4:
5:
6: PROCEDURE create_usage_history
7: ( errbuf OUT NOCOPY VARCHAR2,

Line 64: from csp_usage_histories cuh

60: cuh.transaction_type_id,
61: cuh.parts_loop_id,
62: cuh.organization_id,
63: sum(cuh.quantity) quantity
64: from csp_usage_histories cuh
65: where nvl(cuh.history_data_type,0) = 0
66: group by cuh.inventory_item_id,
67: cuh.period_start_date,
68: cuh.transaction_type_id,

Line 73: -- Delete from Csp_Usage_Histories

69: cuh.parts_loop_id,
70: cuh.organization_id;
71:
72: BEGIN
73: -- Delete from Csp_Usage_Histories
74: EXECUTE IMMEDIATE 'DELETE FROM CSP_USAGE_HISTORIES WHERE HISTORY_DATA_TYPE = 0' ;
75:
76: -- Standard Start of API savepoint
77: SAVEPOINT create_usage_history_pvt;

Line 74: EXECUTE IMMEDIATE 'DELETE FROM CSP_USAGE_HISTORIES WHERE HISTORY_DATA_TYPE = 0' ;

70: cuh.organization_id;
71:
72: BEGIN
73: -- Delete from Csp_Usage_Histories
74: EXECUTE IMMEDIATE 'DELETE FROM CSP_USAGE_HISTORIES WHERE HISTORY_DATA_TYPE = 0' ;
75:
76: -- Standard Start of API savepoint
77: SAVEPOINT create_usage_history_pvt;
78: -- Standard call to check for call compatibility.

Line 97: csp_usage_histories_pkg.insert_row(

93: for ct in c_transactions loop
94: -- insert using table handler
95:
96: l_usage_id := null;
97: csp_usage_histories_pkg.insert_row(
98: px_usage_id => l_usage_id,
99: p_created_by => fnd_global.user_id,
100: p_creation_date => sysdate,
101: p_last_updated_by => fnd_global.user_id,

Line 142: csp_usage_histories_pkg.insert_row(

138: -- Insert records for Part Loop level
139: for cr in c_sum_parts_loop loop
140: -- insert using table handler
141: l_usage_id := null;
142: csp_usage_histories_pkg.insert_row(
143: px_usage_id => l_usage_id,
144: p_created_by => fnd_global.user_id,
145: p_creation_date => sysdate,
146: p_last_updated_by => fnd_global.user_id,

Line 217: END csp_usage_histories_pvt;

213: p_data => errbuf
214: );
215: END create_usage_history;
216:
217: END csp_usage_histories_pvt;