[Home] [Help]
PACKAGE: APPS.HZ_FINANCIAL_PROFILE_PKG
Source
1 PACKAGE HZ_FINANCIAL_PROFILE_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHPFPTS.pls 115.2 2002/11/21 19:31:21 sponnamb ship $ */
3
4
5 PROCEDURE Insert_Row(
6 x_Rowid IN OUT NOCOPY VARCHAR2,
7 x_FINANCIAL_PROFILE_ID NUMBER,
8 x_ACCESS_AUTHORITY_DATE DATE,
9 x_ACCESS_AUTHORITY_GRANTED VARCHAR2,
10 x_BALANCE_AMOUNT NUMBER,
11 x_BALANCE_VERIFIED_ON_DATE DATE,
12 x_FINANCIAL_ACCOUNT_NUMBER VARCHAR2,
13 x_FINANCIAL_ACCOUNT_TYPE VARCHAR2,
14 x_FINANCIAL_ORG_TYPE VARCHAR2,
15 x_FINANCIAL_ORGANIZATION_NAME VARCHAR2,
16 x_CREATED_BY NUMBER,
17 x_CREATION_DATE DATE,
18 x_PARTY_ID NUMBER,
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 x_STATUS VARCHAR2);
28
29
30
31 PROCEDURE Lock_Row(
32 x_Rowid VARCHAR2,
33 x_FINANCIAL_PROFILE_ID NUMBER,
34 x_ACCESS_AUTHORITY_DATE DATE,
35 x_ACCESS_AUTHORITY_GRANTED VARCHAR2,
36 x_BALANCE_AMOUNT NUMBER,
37 x_BALANCE_VERIFIED_ON_DATE DATE,
38 x_FINANCIAL_ACCOUNT_NUMBER VARCHAR2,
39 x_FINANCIAL_ACCOUNT_TYPE VARCHAR2,
40 x_FINANCIAL_ORG_TYPE VARCHAR2,
41 x_FINANCIAL_ORGANIZATION_NAME VARCHAR2,
42 x_CREATED_BY NUMBER,
43 x_CREATION_DATE DATE,
44 x_PARTY_ID NUMBER,
45 x_LAST_UPDATE_LOGIN NUMBER,
46 x_LAST_UPDATE_DATE DATE,
47 x_LAST_UPDATED_BY NUMBER,
48 x_REQUEST_ID NUMBER,
49 x_PROGRAM_APPLICATION_ID NUMBER,
50 x_PROGRAM_ID NUMBER,
51 x_PROGRAM_UPDATE_DATE DATE,
52 x_WH_UPDATE_DATE DATE,
53 x_STATUS VARCHAR2);
54
55
56
57 PROCEDURE Update_Row(
58 x_Rowid IN OUT NOCOPY VARCHAR2,
59 x_FINANCIAL_PROFILE_ID NUMBER,
60 x_ACCESS_AUTHORITY_DATE DATE,
61 x_ACCESS_AUTHORITY_GRANTED VARCHAR2,
62 x_BALANCE_AMOUNT NUMBER,
63 x_BALANCE_VERIFIED_ON_DATE DATE,
64 x_FINANCIAL_ACCOUNT_NUMBER VARCHAR2,
65 x_FINANCIAL_ACCOUNT_TYPE VARCHAR2,
66 x_FINANCIAL_ORG_TYPE VARCHAR2,
67 x_FINANCIAL_ORGANIZATION_NAME VARCHAR2,
68 x_CREATED_BY NUMBER,
69 x_CREATION_DATE DATE,
70 x_PARTY_ID NUMBER,
71 x_LAST_UPDATE_LOGIN NUMBER,
72 x_LAST_UPDATE_DATE DATE,
73 x_LAST_UPDATED_BY NUMBER,
74 x_REQUEST_ID NUMBER,
75 x_PROGRAM_APPLICATION_ID NUMBER,
76 x_PROGRAM_ID NUMBER,
77 x_PROGRAM_UPDATE_DATE DATE,
78 x_WH_UPDATE_DATE DATE,
79 x_STATUS VARCHAR2);
80
81
82
83 PROCEDURE Delete_Row( x_FINANCIAL_PROFILE_ID NUMBER);
84
85 END HZ_FINANCIAL_PROFILE_PKG;