[Home] [Help]
PACKAGE: APPS.JL_BR_AR_BORDEROS_PKG
Source
1 PACKAGE JL_BR_AR_BORDEROS_PKG as
2 /* $Header: jlbrrbds.pls 120.5 2003/09/18 20:24:36 vsidhart ship $ */
3
4 PROCEDURE Insert_Row( X_Rowid IN OUT NOCOPY VARCHAR2,
5
6 X_BORDERO_ID NUMBER,
7 X_SELECTION_CONTROL_ID NUMBER,
8 X_BANK_ACCT_USE_ID NUMBER,
9 X_BORDERO_STATUS VARCHAR2,
10 X_SEQUENTIAL_NUMBER_GENERATION NUMBER DEFAULT NULL,
11 X_BORDERO_TYPE VARCHAR2 DEFAULT NULL,
12 X_TOTAL_COUNT NUMBER DEFAULT NULL,
13 X_TOTAL_AMOUNT NUMBER DEFAULT NULL,
14 X_SELECTION_DATE DATE DEFAULT NULL,
15 X_REMITTANCE_DATE DATE DEFAULT NULL,
16 X_REFUSED_DATE DATE DEFAULT NULL,
17 X_CANCELLATION_DATE DATE DEFAULT NULL,
18 X_COLLECTION_DATE DATE DEFAULT NULL,
19 X_WRITE_OFF_DATE DATE DEFAULT NULL,
20 X_DATE_IN_RECEIPT DATE DEFAULT NULL,
21 X_RECEIVED_DATE DATE DEFAULT NULL,
22 X_OUTPUT_PROGRAM_ID NUMBER DEFAULT NULL,
23 X_SELECT_ACCOUNT_ID NUMBER DEFAULT NULL,
24 X_OUTPUT_FORMAT VARCHAR2 DEFAULT NULL,
25 X_LAST_UPDATE_DATE DATE,
26 X_LAST_UPDATED_BY NUMBER,
27 X_CREATION_DATE DATE,
28 X_CREATED_BY NUMBER,
29 X_LAST_UPDATE_LOGIN NUMBER,
30
31 X_calling_sequence VARCHAR2,
32 X_ORG_ID NUMBER
33 );
34
35 PROCEDURE Lock_Row( X_Rowid VARCHAR2,
36
37 X_BORDERO_ID NUMBER,
38 X_SELECTION_CONTROL_ID NUMBER,
39 X_BANK_ACCT_USE_ID NUMBER,
40 X_BORDERO_STATUS VARCHAR2,
41 X_SEQUENTIAL_NUMBER_GENERATION NUMBER DEFAULT NULL,
42 X_BORDERO_TYPE VARCHAR2 DEFAULT NULL,
43 X_TOTAL_COUNT NUMBER DEFAULT NULL,
44 X_TOTAL_AMOUNT NUMBER DEFAULT NULL,
45 X_SELECTION_DATE DATE DEFAULT NULL,
46 X_REMITTANCE_DATE DATE DEFAULT NULL,
47 X_REFUSED_DATE DATE DEFAULT NULL,
48 X_CANCELLATION_DATE DATE DEFAULT NULL,
49 X_COLLECTION_DATE DATE DEFAULT NULL,
50 X_WRITE_OFF_DATE DATE DEFAULT NULL,
51 X_DATE_IN_RECEIPT DATE DEFAULT NULL,
52 X_RECEIVED_DATE DATE DEFAULT NULL,
53 X_OUTPUT_PROGRAM_ID NUMBER DEFAULT NULL,
54 X_SELECT_ACCOUNT_ID NUMBER DEFAULT NULL,
55 X_OUTPUT_FORMAT VARCHAR2 DEFAULT NULL,
56 X_LAST_UPDATE_DATE DATE,
57 X_LAST_UPDATED_BY NUMBER,
58 X_CREATION_DATE DATE,
59 X_CREATED_BY NUMBER,
60 X_LAST_UPDATE_LOGIN NUMBER,
61
62 X_calling_sequence VARCHAR2
63 );
64
65
66 PROCEDURE Update_Row( X_Rowid VARCHAR2,
67
68 X_BORDERO_ID NUMBER,
69 X_SELECTION_CONTROL_ID NUMBER,
70 X_BANK_ACCT_USE_ID NUMBER,
71 X_BORDERO_STATUS VARCHAR2,
72 X_SEQUENTIAL_NUMBER_GENERATION NUMBER DEFAULT NULL,
73 X_BORDERO_TYPE VARCHAR2 DEFAULT NULL,
74 X_TOTAL_COUNT NUMBER DEFAULT NULL,
75 X_TOTAL_AMOUNT NUMBER DEFAULT NULL,
76 X_SELECTION_DATE DATE DEFAULT NULL,
77 X_REMITTANCE_DATE DATE DEFAULT NULL,
78 X_REFUSED_DATE DATE DEFAULT NULL,
79 X_CANCELLATION_DATE DATE DEFAULT NULL,
80 X_COLLECTION_DATE DATE DEFAULT NULL,
81 X_WRITE_OFF_DATE DATE DEFAULT NULL,
82 X_DATE_IN_RECEIPT DATE DEFAULT NULL,
83 X_RECEIVED_DATE DATE DEFAULT NULL,
84 X_OUTPUT_PROGRAM_ID NUMBER DEFAULT NULL,
85 X_SELECT_ACCOUNT_ID NUMBER DEFAULT NULL,
86 X_OUTPUT_FORMAT VARCHAR2 DEFAULT NULL,
87 X_LAST_UPDATE_DATE DATE,
88 X_LAST_UPDATED_BY NUMBER,
89 X_CREATION_DATE DATE,
90 X_CREATED_BY NUMBER,
91 X_LAST_UPDATE_LOGIN NUMBER,
92
93 X_calling_sequence VARCHAR2
94 );
95
96
97 PROCEDURE Delete_Row( X_Rowid VARCHAR2,
98 X_calling_sequence VARCHAR2
99 );
100
101 END JL_BR_AR_BORDEROS_PKG;