1 PACKAGE PA_PERIOD_MASKS_PKG AS
2 --$Header: PAFPPMTS.pls 120.0 2005/05/29 23:18:47 appldev noship $
3 PROCEDURE INSERT_ROW(
4 X_ROWID IN OUT NOCOPY rowid,
5 X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
6 X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
7 X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
8 X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
9 X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
10 X_CREATED_BY IN pa_period_masks_b.created_by%type,
11 X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
12 X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
13 X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
14 X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
15 X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
16 X_NAME IN pa_period_masks_tl.name%type,
17 X_DESCRIPTION IN pa_period_masks_tl.description%type);
18
19 PROCEDURE LOCK_ROW(
20 X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type
21 );
22
23 PROCEDURE UPDATE_ROW(
24 X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
25 X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
26 X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
27 X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
28 X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
29 X_CREATED_BY IN pa_period_masks_b.created_by%type,
30 X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
31 X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
32 X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
33 X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
34 X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
35 X_NAME IN pa_period_masks_tl.name%type,
36 X_DESCRIPTION IN pa_period_masks_tl.description%type);
37
38
39 PROCEDURE DELETE_ROW(
40 X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type
41 );
42
43 PROCEDURE ADD_LANGUAGE;
44
45 PROCEDURE TRANSLATE_ROW(
46 X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
47 X_OWNER IN VARCHAR2,
48 X_NAME IN pa_period_masks_tl.name%type,
49 X_DESCRIPTION IN pa_period_masks_tl.description%type
50 );
51
52
53 PROCEDURE LOAD_ROW(
54 X_PERIOD_MASK_ID IN pa_period_masks_b.period_mask_id%type,
55 X_EFFECTIVE_START_DATE IN pa_period_masks_b.effective_start_date%type,
56 X_EFFECTIVE_END_DATE IN pa_period_masks_b.effective_end_date%type,
57 X_TIME_PHASE_CODE IN pa_period_masks_b.time_phase_code%type,
58 X_CREATION_DATE IN pa_period_masks_b.creation_date%type,
59 X_CREATED_BY IN pa_period_masks_b.created_by%type,
60 X_LAST_UPDATE_LOGIN IN pa_period_masks_b.last_update_login%type,
61 X_LAST_UPDATED_BY IN pa_period_masks_b.last_updated_by%type,
62 X_LAST_UPDATE_DATE IN pa_period_masks_b.last_update_date%type,
63 X_RECORD_VERSION_NUMBER IN pa_period_masks_b.record_version_number%type,
64 X_PRE_DEFINED_FLAG IN pa_period_masks_b.pre_defined_flag%type,
65 X_NAME IN pa_period_masks_tl.name%type,
66 X_DESCRIPTION IN pa_period_masks_tl.description%type,
67 X_OWNER IN VARCHAR2 );
68
69 END PA_PERIOD_MASKS_PKG;