DBA Data[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;