1 package PER_PROPOSAL_TEMPLATES_PKG AUTHID CURRENT_USER as
2 /* $Header: hruptlct.pkh 115.1 1999/11/09 15:05:25 pkm ship $ */
3 procedure INSERT_ROW (
4 X_PROPOSAL_TEMPLATE_ID in NUMBER,
5 X_PROPOSAL_NAME in VARCHAR2,
6 X_DESCRIPTION in VARCHAR2,
7 X_TYPE in VARCHAR2,
8 X_CREATION_DATE in DATE,
9 X_CREATED_BY in VARCHAR2,
10 X_LAST_UPDATE_DATE in DATE,
11 X_LAST_UPDATED_BY in VARCHAR2,
12 X_LAST_UPDATE_LOGIN in NUMBER
13 );
14 procedure LOCK_ROW (
15 X_PROPOSAL_TEMPLATE_ID in NUMBER
16 );
17 procedure UPDATE_ROW (
18 X_PROPOSAL_TEMPLATE_ID in NUMBER,
19 X_PROPOSAL_NAME in VARCHAR2,
20 X_DESCRIPTION in VARCHAR2,
21 X_TYPE in VARCHAR2,
22 X_LAST_UPDATE_DATE in DATE,
23 X_LAST_UPDATED_BY in VARCHAR2,
24 X_LAST_UPDATE_LOGIN in NUMBER
25 );
26 procedure DELETE_ROW (
27 X_PROPOSAL_TEMPLATE_ID in NUMBER
28 );
29 procedure LOAD_ROW (
30 X_PROPOSAL_TEMPLATE_ID in NUMBER,
31 X_PROPOSAL_NAME in VARCHAR2,
32 X_DESCRIPTION in VARCHAR2,
33 X_TYPE in VARCHAR2,
34 X_OWNER in VARCHAR2
35 );
36 procedure TRANSLATE_ROW (
37 X_PROPOSAL_TEMPLATE_ID in NUMBER,
38 X_PROPOSAL_NAME in VARCHAR2,
39 X_DESCRIPTION in VARCHAR2,
40 X_OWNER in VARCHAR2
41 );
42 end PER_PROPOSAL_TEMPLATES_PKG;