DBA Data[Home] [Help]

PACKAGE: APPS.AS_SALES_LEAD_SCORECARDS_PKG

Source


1 PACKAGE as_sales_lead_scorecards_pkg AUTHID CURRENT_USER AS
2 /* $Header: asxtscds.pls 115.6 2002/11/22 08:05:00 ckapoor ship $ */
3      PROCEDURE insert_row(
4           x_rowid                          IN OUT NOCOPY VARCHAR2
5         , x_scorecard_id                     NUMBER
6         , x_last_update_date                 DATE
7         , x_last_updated_by                  NUMBER
8         , x_creation_date                    DATE
9         , x_created_by                       NUMBER
10         , x_last_update_login                NUMBER
11         , x_description                      VARCHAR2
12         , x_enabled_flag                     VARCHAR2
13         , x_start_date_active                DATE
14         , x_end_date_active                  DATE
15      );
16 
17      PROCEDURE delete_row(
18         x_scorecard_id                     NUMBER
19      );
20 
21      PROCEDURE update_row(
22           x_rowid                          VARCHAR2
23         , x_scorecard_id                   NUMBER
24         , x_last_update_date               DATE
25         , x_last_updated_by                NUMBER
26         , x_creation_date                  DATE
27         , x_created_by                     NUMBER
28         , x_last_update_login              NUMBER
29         , x_description                    VARCHAR2
30         , x_enabled_flag                   VARCHAR2
31         , x_start_date_active              DATE
32         , x_end_date_active                DATE
33      );
34 
35 
36      PROCEDURE update_row(
37           x_scorecard_id                   NUMBER
38         , x_last_update_date               DATE
39         , x_last_updated_by                NUMBER
40         , x_last_update_login              NUMBER
41         , x_description                    VARCHAR2
42         , x_start_date_active              DATE
43         , x_end_date_active                DATE
44      );
45 
46      PROCEDURE lock_row(
47           x_rowid                          VARCHAR2
48         , x_scorecard_id                   NUMBER
49         , x_last_update_date               DATE
50         , x_last_updated_by                NUMBER
51         , x_creation_date                  DATE
52         , x_created_by                     NUMBER
53         , x_last_update_login              NUMBER
54         , x_description                    VARCHAR2
55         , x_enabled_flag                   VARCHAR2
56         , x_start_date_active              DATE
57         , x_end_date_active                DATE
58      );
59 
60      PROCEDURE load_row(
61           x_scorecard_id                   NUMBER
62         , x_description                    VARCHAR2
63         , x_start_date_active              DATE
64         , x_end_date_active                DATE
65         , x_owner                          VARCHAR2
66      );
67 
68 END as_sales_lead_scorecards_pkg;