[Home] [Help]
PACKAGE: APPS.HZ_CREDIT_PROFILES_PKG
Source
1 PACKAGE HZ_CREDIT_PROFILES_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARHCRPRS.pls 115.3 2003/08/18 17:45:30 rajkrish ship $ */
3
4 --======================================================================
5 --CONSTANTS
6 --======================================================================
7 G_PKG_NAME CONSTANT VARCHAR2(30) :='HZ_CREDIT_PROFILES_PKG';
8
9
10 ---------------------------
11 -- PROCEDURES AND FUNCTIONS
12 ---------------------------
13
14 --========================================================================
15 -- PROCEDURE : Insert_row PUBLIC
16 -- PARAMETERS: p_row_id ROWID of the current record in
17 -- table HZ_CREDIT_PROFILES
18 -- p_credit_profile_id primary key
19 -- p_organization_id operating unit id
20 -- p_item_category_id item_category_id
21 -- p_enable_flag YES/NO enable flag
22 -- p_effective_date_from effective_date_from
23 -- p_effective_date_to effective_date_to
24 -- p_credit_checking credit_checking
25 -- p_next_credit_review_date next_credit_review_date
26 -- p_tolerance tolerance
27 -- p_credit_hold credit_hold
28 -- p_credit_rating credit_rating
29 -- p_creation_date date, when a record was inserted
30 -- p_created_by userid of the person,who inserted
31 -- a record
32 --
33 -- COMMENT : Procedure inserts record into the table HZ_CREDIT_PROFILES
34 --
35 --========================================================================
36 PROCEDURE Insert_row
37 ( p_row_id OUT NOCOPY VARCHAR2
38 , p_credit_profile_id NUMBER
39 , p_organization_id NUMBER
40 , p_item_category_id NUMBER
41 , p_enable_flag VARCHAR2
42 , p_effective_date_from DATE
43 , p_effective_date_to DATE
44 , p_credit_checking VARCHAR2
45 , p_next_credit_review_date DATE
46 , p_tolerance NUMBER
47 , p_credit_hold VARCHAR2
48 , p_credit_rating VARCHAR2
49 , p_creation_date DATE
50 , p_created_by NUMBER
51 , p_last_update_date DATE
52 , p_last_updated_by NUMBER
53 , p_last_update_login NUMBER
54 );
55
56
57 --========================================================================
58 -- PROCEDURE : Lock_row PUBLIC
59 -- PARAMETERS: p_credit_profile_id credit_profile_id
60 -- p_last_update_date
61 -- COMMENT : Procedure locks record in the table HZ_CREDIT_PROFILES
62 --
63 --========================================================================
64 PROCEDURE Lock_row
65 ( p_credit_profile_id NUMBER
66 , p_last_update_date DATE
67 );
68
69
70
71 --========================================================================
72 -- PROCEDURE : Update_row PUBLIC
73 -- PARAMETERS: p_credit_profile_id credit_profile_id
74 -- p_organization_id operating unit id
75 -- p_item_category_id item_category_id
76 -- p_enable_flag YES/NO enable flag
77 -- p_effective_date_from effective_date_from
78 -- p_effective_date_to effective_date_to
79 -- p_credit_checking credit_checking
80 -- p_next_credit_review_date next_credit_review_date
81 -- p_tolerance tolerance
82 -- p_credit_hold credit_hold
83 -- p_credit_rating credit_rating
84 -- p_last_update_date date, when record was updated
85 -- p_last_updated_by userid of the person,who updated the record
86 -- COMMENT : Procedure updates record in the table HZ_CREDIT_PROFILES
87 --
88 --========================================================================
89 PROCEDURE Update_row
90 ( p_credit_profile_id NUMBER
91 , p_organization_id NUMBER
92 , p_item_category_id NUMBER
93 , p_enable_flag VARCHAR2
94 , p_effective_date_from DATE
95 , p_effective_date_to DATE
96 , p_credit_checking VARCHAR2
97 , p_next_credit_review_date DATE
98 , p_tolerance NUMBER
99 , p_credit_hold VARCHAR2
100 , p_credit_rating VARCHAR2
101 , p_last_update_date DATE
102 , p_last_updated_by NUMBER
103 );
104
105
106 --========================================================================
107 -- PROCEDURE : Delete_row PUBLIC
108 -- PARAMETERS: p_credit_profile_id credit_profile_id
109 --
110 -- COMMENT : Procedure deletes record from the table HZ_CREDIT_PROFILES
111 --
112 --========================================================================
113 PROCEDURE Delete_row
114 ( p_credit_profile_id NUMBER
115 );
116
117
118 END HZ_CREDIT_PROFILES_PKG;