PACKAGE: APPS.HZ_BILLING_PREFERENCES_PKG

Source

1 PACKAGE HZ_BILLING_PREFERENCES_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHABFTS.pls 115.1 2002/11/21 19:13:05 sponnamb ship $: */
3 
4 
5 PROCEDURE Insert_Row(
6                   x_Rowid             IN OUT NOCOPY      VARCHAR2,
7                   x_BILLING_PREFERENCES_ID        NUMBER,
8                   x_BILL_LANGUAGE                 VARCHAR2,
9                   x_BILL_ROUND_NUMBER             VARCHAR2,
10                   x_BILL_TYPE                     VARCHAR2,
11                   x_MEDIA_FORMAT                  VARCHAR2,
12                   x_SITE_USE_ID                   NUMBER,
13                   x_MEDIA_TYPE                    VARCHAR2,
14                   x_CUST_ACCOUNT_ID               NUMBER,
15                   x_NUMBER_OF_COPIES              NUMBER,
16                   x_CURRENCY_CODE                 VARCHAR2,
17                   x_CREATED_BY                    NUMBER,
18                   x_CREATION_DATE                 DATE,
19                   x_LAST_UPDATE_LOGIN             NUMBER,
20                   x_LAST_UPDATE_DATE              DATE,
21                   x_LAST_UPDATED_BY               NUMBER,
22                   x_REQUEST_ID                    NUMBER,
23                   x_PROGRAM_APPLICATION_ID        NUMBER,
24                   x_PROGRAM_ID                    NUMBER,
25                   x_PROGRAM_UPDATE_DATE           DATE,
26                   x_WH_UPDATE_DATE                DATE);
27 
28 
29 
30 PROCEDURE Lock_Row(
31                   x_Rowid                         VARCHAR2,
32                   x_BILLING_PREFERENCES_ID        NUMBER,
33                   x_BILL_LANGUAGE                 VARCHAR2,
34                   x_BILL_ROUND_NUMBER             VARCHAR2,
35                   x_BILL_TYPE                     VARCHAR2,
36                   x_MEDIA_FORMAT                  VARCHAR2,
37                   x_SITE_USE_ID                   NUMBER,
38                   x_MEDIA_TYPE                    VARCHAR2,
39                   x_CUST_ACCOUNT_ID               NUMBER,
40                   x_NUMBER_OF_COPIES              NUMBER,
41                   x_CURRENCY_CODE                 VARCHAR2,
42                   x_CREATED_BY                    NUMBER,
43                   x_CREATION_DATE                 DATE,
44                   x_LAST_UPDATE_LOGIN             NUMBER,
45                   x_LAST_UPDATE_DATE              DATE,
46                   x_LAST_UPDATED_BY               NUMBER,
47                   x_REQUEST_ID                    NUMBER,
48                   x_PROGRAM_APPLICATION_ID        NUMBER,
49                   x_PROGRAM_ID                    NUMBER,
50                   x_PROGRAM_UPDATE_DATE           DATE,
51                   x_WH_UPDATE_DATE                DATE);
52 
53 
54 
55 PROCEDURE Update_Row(
56                   x_Rowid              IN OUT NOCOPY     VARCHAR2,
57                   x_BILLING_PREFERENCES_ID        NUMBER,
58                   x_BILL_LANGUAGE                 VARCHAR2,
59                   x_BILL_ROUND_NUMBER             VARCHAR2,
60                   x_BILL_TYPE                     VARCHAR2,
61                   x_MEDIA_FORMAT                  VARCHAR2,
62                   x_SITE_USE_ID                   NUMBER,
63                   x_MEDIA_TYPE                    VARCHAR2,
64                   x_CUST_ACCOUNT_ID               NUMBER,
65                   x_NUMBER_OF_COPIES              NUMBER,
66                   x_CURRENCY_CODE                 VARCHAR2,
67                   x_CREATED_BY                    NUMBER,
68                   x_CREATION_DATE                 DATE,
69                   x_LAST_UPDATE_LOGIN             NUMBER,
70                   x_LAST_UPDATE_DATE              DATE,
71                   x_LAST_UPDATED_BY               NUMBER,
72                   x_REQUEST_ID                    NUMBER,
73                   x_PROGRAM_APPLICATION_ID        NUMBER,
74                   x_PROGRAM_ID                    NUMBER,
75                   x_PROGRAM_UPDATE_DATE           DATE,
76                   x_WH_UPDATE_DATE                DATE);
77 
78 
79 
80 PROCEDURE Delete_Row(                  x_BILLING_PREFERENCES_ID        NUMBER);
81 
82 END HZ_BILLING_PREFERENCES_PKG;