[Home] [Help]
PACKAGE: APPS.PO_ASL_AUTHORIZATIONS_THS
Source
1 PACKAGE PO_ASL_AUTHORIZATIONS_THS AUTHID CURRENT_USER as
2 /* $Header: POXADLSS.pls 115.2 2002/11/23 03:36:31 sbull ship $ */
3
4 /*===========================================================================
5 PROCEDURE NAME: insert_row
6
7
8 DESCRIPTION: Lock table handler for CHV_AUTHORIZATIONS
9
10
11 CHANGE HISTORY: 28-Jun-96 CMOK Created
12
13 =============================================================================*/
14
15 procedure insert_row(
16 x_using_organization_id NUMBER,
17 x_reference_id NUMBER,
18 x_reference_type VARCHAR2,
19 x_authorization_code VARCHAR2,
20 x_authorization_sequence NUMBER,
21 x_last_update_date DATE,
22 x_last_updated_by NUMBER,
23 x_creation_date DATE,
24 x_created_by NUMBER,
25 x_last_update_login NUMBER,
26 x_purchasing_unit_of_measure VARCHAR2,
27 x_timefence_days NUMBER,
28 x_rowid IN OUT NOCOPY VARCHAR2);
29
30
31 /*===========================================================================
32 PROCEDURE NAME: update_row
33
34
35 DESCRIPTION: Table handler for CHV_AUTHORIZATIONS
36
37
38 CHANGE HISTORY: 28-Jun-96 cmok Created
39
40 =============================================================================*/
41
42 procedure update_row(
43 x_using_organization_id NUMBER,
44 x_reference_id NUMBER,
45 x_reference_type VARCHAR2,
46 x_authorization_code VARCHAR2,
47 x_authorization_sequence NUMBER,
48 x_last_update_date DATE,
49 x_last_updated_by NUMBER,
50 x_creation_date DATE,
51 x_created_by NUMBER,
52 x_last_update_login NUMBER,
53 x_purchasing_unit_of_measure VARCHAR2,
54 x_timefence_days NUMBER,
55 x_rowid VARCHAR2);
56
57 /*===========================================================================
58 PROCEDURE NAME: lock_row
59
60
61 DESCRIPTION: Lock table handler for CHV_AUTHORIZATIONS
62
63
64 CHANGE HISTORY: 28-Jun-96 cmok Created
65
66 =============================================================================*/
67
68 procedure lock_row(
69 x_using_organization_id NUMBER,
70 x_reference_id NUMBER,
71 x_reference_type VARCHAR2,
72 x_authorization_code VARCHAR2,
73 x_authorization_sequence NUMBER,
74 x_purchasing_unit_of_measure VARCHAR2,
75 x_timefence_days NUMBER,
76 x_rowid VARCHAR2);
77
78 END PO_ASL_AUTHORIZATIONS_THS;