APPS.OE_CREDIT_SUMMARIES_PKG dependencies on OE_CREDIT_SUMMARIES

Line 1: PACKAGE BODY OE_CREDIT_SUMMARIES_PKG AS

1: PACKAGE BODY OE_CREDIT_SUMMARIES_PKG AS
2: -- $Header: OEXCRSMB.pls 115.3 2003/10/20 06:51:36 appldev ship $
3: --------------------
4: -- TYPE DECLARATIONS
5: --------------------

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) :='OE_CREDIT_SUMMARIES_PKG';

6:
7: ------------
8: -- CONSTANTS
9: ------------
10: G_PKG_NAME CONSTANT VARCHAR2(30) :='OE_CREDIT_SUMMARIES_PKG';
11:
12: -------------------
13: -- PUBLIC VARIABLES
14: -------------------

Line 70: --COMMENTS: Insert a row into the OE_CREDIT_SUMMARIES table.

66: END get_party_id ;
67: --=====================================================================
68: --NAME: Insert_Row
69: --TYPE: PRIVATE
70: --COMMENTS: Insert a row into the OE_CREDIT_SUMMARIES table.
71: --Parameters:
72: --IN
73: --OUT
74: --=====================================================================

Line 107: INSERT INTO oe_credit_summaries (

103: l_party_id := NULL ;
104: l_party_id :=
105: get_party_id(p_cust_account_id => p_cust_account_id );
106:
107: INSERT INTO oe_credit_summaries (
108: cust_account_id
109: , org_id
110: , site_use_id
111: , currency_code

Line 164: --COMMENTS: Update a row in the OE_CREDIT_SUMMARIES table.

160:
161: --=====================================================================
162: --NAME: Update_Row
163: --TYPE: PRIVATE
164: --COMMENTS: Update a row in the OE_CREDIT_SUMMARIES table.
165: --Parameters:
166: --IN
167: --OUT
168: --=====================================================================

Line 187: UPDATE oe_credit_summaries

183: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
184: --
185: BEGIN
186: OE_DEBUG_PUB.ADD('OEXCRSMB - IN Update row');
187: UPDATE oe_credit_summaries
188: SET
189: balance = p_balance
190: , last_update_date = p_last_update_date
191: , last_updated_by = p_last_updated_by

Line 214: --COMMENTS: Delete a row in the OE_CREDIT_SUMMARIES table.

210:
211: --=====================================================================
212: --NAME: Delete_Row
213: --TYPE: PRIVATE
214: --COMMENTS: Delete a row in the OE_CREDIT_SUMMARIES table.
215: --Parameters:
216: --IN
217: --OUT
218: --=====================================================================

Line 228: DELETE FROM oe_credit_summaries

224: --
225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
226: --
227: BEGIN
228: DELETE FROM oe_credit_summaries
229: WHERE ROWID = CHARTOROWID(p_row_id);
230: EXCEPTION
231: WHEN OTHERS THEN
232: IF OE_MSG_PUB.Check_msg_level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 239: END OE_CREDIT_SUMMARIES_PKG;

235: END IF;
236: RAISE;
237: END Delete_Row;
238:
239: END OE_CREDIT_SUMMARIES_PKG;