APPS.MTL_CST_TXN_COST_DETAILS_PKG dependencies on MTL_CST_TXN_COST_DETAILS

Line 1: PACKAGE BODY MTL_CST_TXN_COST_DETAILS_PKG as

1: PACKAGE BODY MTL_CST_TXN_COST_DETAILS_PKG as
2: /* $Header: CSTEACUB.pls 115.3 2003/08/25 04:29:46 anjgupta ship $ */
3:
4: PROCEDURE Insert_Row(
5: X_Rowid IN OUT NOCOPY VARCHAR2,

Line 25: INSERT INTO mtl_cst_txn_cost_details(

21: BEGIN
22:
23: X_Rowid := 0;
24:
25: INSERT INTO mtl_cst_txn_cost_details(
26: transaction_id,
27: organization_id,
28: cost_element_id,
29: level_type,

Line 73: UPDATE mtl_cst_txn_cost_details

69: X_Value_Change NUMBER DEFAULT NULL
70:
71: ) IS
72: BEGIN
73: UPDATE mtl_cst_txn_cost_details
74: SET
75: cost_element_id = X_Cost_Element_Id,
76: level_type = X_Level_Type,
77: last_update_date = X_Last_Update_Date,

Line 91: DELETE FROM mtl_cst_txn_cost_details

87: END Update_Row;
88:
89: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
90: BEGIN
91: DELETE FROM mtl_cst_txn_cost_details
92: WHERE rowid = X_Rowid;
93:
94: if (SQL%NOTFOUND) then
95: Raise NO_DATA_FOUND;

Line 101: DELETE FROM mtl_cst_txn_cost_details

97: END Delete_Row;
98:
99: PROCEDURE Delete_Rows(X_Transaction_Id NUMBER)
100: IS BEGIN
101: DELETE FROM mtl_cst_txn_cost_details
102: WHERE transaction_id = X_Transaction_Id;
103: if (SQL%NOTFOUND) then
104: Raise NO_DATA_FOUND;
105: end if;

Line 108: END MTL_CST_TXN_COST_DETAILS_PKG;

104: Raise NO_DATA_FOUND;
105: end if;
106: END Delete_Rows;
107:
108: END MTL_CST_TXN_COST_DETAILS_PKG;