1 PACKAGE OE_CREDIT_SUMMARIES_PKG AUTHID CURRENT_USER AS
2 -- $Header: OEXCRSMS.pls 120.0 2005/06/01 22:46:17 appldev noship $
3 --------------------
4 -- TYPE DECLARATIONS
5 --------------------
6
7 ------------
8 -- CONSTANTS
9 ------------
10
11 -------------------
12 -- PUBLIC VARIABLES
13 -------------------
14
15 ---------------------------
16 -- PROCEDURES AND FUNCTIONS
17 ---------------------------
18
19 --=====================================================================
20 --NAME: Insert_Row
21 --TYPE: PRIVATE
22 --COMMENTS: Insert a row into the OE_CREDIT_SUMMARIES table.
23 --Parameters:
24 --IN
25 --OUT
26 --=====================================================================
27
28 PROCEDURE Insert_Row
29 ( p_cust_account_id IN NUMBER
30 , p_org_id IN NUMBER
31 , p_site_use_id IN NUMBER
32 , p_currency_code IN VARCHAR2
33 , p_balance_type IN NUMBER
34 , p_balance IN NUMBER
35 , p_creation_date IN DATE
36 , p_created_by IN NUMBER
37 , p_last_update_date IN DATE
38 , p_last_updated_by IN NUMBER
39 , p_last_update_login IN NUMBER
40 , p_program_application_id IN NUMBER
41 , p_program_id IN NUMBER
42 , p_program_update_date IN DATE
43 , p_request_id IN NUMBER
44 , p_exposure_source_code IN VARCHAR2
45 );
46
47 --=====================================================================
48 --NAME: Update_Row
49 --TYPE: PRIVATE
50 --COMMENTS: Update a row in the OE_CREDIT_SUMMARIES table.
51 --Parameters:
52 --IN
53 --OUT
54 --=====================================================================
55
56 PROCEDURE Update_Row
57 ( p_row_id IN VARCHAR2
58 , p_balance IN NUMBER
59 , p_last_update_date IN DATE
60 , p_last_updated_by IN NUMBER
61 , p_last_update_login IN NUMBER
62 , p_program_application_id IN NUMBER
63 , p_program_id IN NUMBER
64 , p_program_update_date IN DATE
65 , p_request_id IN NUMBER
66 );
67
68 --=====================================================================
69 --NAME: Delete_Row
70 --TYPE: PRIVATE
71 --COMMENTS: Delete a row in the OE_CREDIT_SUMMARIES table.
72 --Parameters:
73 --IN
74 --OUT
75 --=====================================================================
76
77 PROCEDURE Delete_Row
78 ( p_row_id IN VARCHAR2
79 );
80
81 END OE_CREDIT_SUMMARIES_PKG;
[Home] [Help]