[Home] [Help]
PACKAGE: APPS.CN_TRX_FACTORS_PKG
Source
1 PACKAGE cn_trx_factors_pkg AS
2 /* $Header: cnplitfs.pls 120.0 2005/07/11 19:42:48 fmburu noship $ */
3
4 /*
5 Date Name Description
6 ----------------------------------------------------------------------------+
7 15-FEB-95 P Cook Unit tested
8 18-APR-95 P Cook Removed trx_type_id paramater due to replacement of
9 cn_trx_types with cn_lookup_codes
10
11 Name
12
13 Purpose
14
15 Notes
16
17
18 */
19
20 -- Name
21 --
22 -- Purpose
23 --
24 -- Notes
25 --
26 --
27 PROCEDURE begin_record(
28 x_operation VARCHAR2,
29 x_rowid IN OUT NOCOPY VARCHAR2,
30 x_trx_factor_id IN OUT NOCOPY NUMBER,
31 x_object_version_number IN OUT NOCOPY NUMBER,
32 x_event_factor NUMBER,
33 x_event_factor_old NUMBER,
34 x_revenue_class_id NUMBER,
35 x_last_update_date DATE,
36 x_last_updated_by NUMBER,
37 x_creation_date DATE,
38 x_created_by NUMBER,
39 x_last_update_login NUMBER,
40 x_quota_id NUMBER,
41 x_quota_rule_id NUMBER,
42 x_trx_type VARCHAR2,
43 x_trx_type_name VARCHAR2,
44 x_program_type VARCHAR2,
45 x_status_code VARCHAR2,
46 x_org_id NUMBER
47 );
48
49 -- Name
50 --
51 -- Purpose
52 --
53 -- Notes
54 --
55 --
56 PROCEDURE end_record(
57 x_rowid VARCHAR2,
58 x_trx_factor_id NUMBER,
59 x_event_factor NUMBER,
60 x_revenue_class_id NUMBER,
61 x_quota_id NUMBER,
62 x_quota_rule_id NUMBER,
63 x_trx_type_name VARCHAR2,
64 x_program_type VARCHAR2);
65
66 PROCEDURE INSERT_RECORD(x_quota_id NUMBER, x_quota_rule_id NUMBER, x_revenue_class_id NUMBER);
67
68 -- Name
69 --
70 -- Purpose
71 --
72 -- Notes
73 -- Called on rev class deletion
74 --
75 PROCEDURE DELETE_RECORD(x_trx_factor_id NUMBER, x_quota_rule_id NUMBER, x_quota_id NUMBER);
76 END cn_trx_factors_pkg;