PACKAGE: APPS.PA_PERIOD_MASK_DETAILS_PKG

Source

1 PACKAGE PA_PERIOD_MASK_DETAILS_PKG AS
2 --$Header: PAFPPMDS.pls 120.1 2005/08/19 16:28:17 mwasowic noship $
3  PROCEDURE insert_row(
4  x_rowid  IN OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
5  x_period_mask_id        IN pa_period_mask_details.period_mask_id%type,
6  x_num_of_periods        IN pa_period_mask_details.num_of_periods%type,
7  x_anchor_period_flag    IN pa_period_mask_details.anchor_period_flag%type,
8  x_from_anchor_start     IN pa_period_mask_details.from_anchor_start%type,
9  x_from_anchor_end       IN pa_period_mask_details.from_anchor_end%type,
10  x_from_anchor_position  IN pa_period_mask_details.from_anchor_position%type,
11  x_creation_date         IN pa_period_mask_details.creation_date%type,
12  x_created_by            IN pa_period_mask_details.created_by%type,
13  x_last_update_login     IN pa_period_mask_details.last_update_login%type,
14  x_last_updated_by       IN pa_period_mask_details.last_updated_by%type,
15  x_last_update_date      IN pa_period_mask_details.last_update_date%type
16 );
17 
18 
19     -- locks record into PA_PERIOD_MASK_DETAILS table
20 
21 PROCEDURE lock_row(
22           x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
23           x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type);
24 
25     -- updates record into PA_PERIOD_MASK_DETAILS table
26 
27     PROCEDURE update_row(
28     x_period_mask_id       IN pa_period_mask_details.period_mask_id%type,
29     x_num_of_periods       IN pa_period_mask_details.num_of_periods%type,
30     x_anchor_period_flag   IN pa_period_mask_details.anchor_period_flag%type,
31     x_from_anchor_start    IN pa_period_mask_details.from_anchor_start%type,
32     x_from_anchor_end      IN pa_period_mask_details.from_anchor_end%type,
33     x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type,
34     x_creation_date         IN pa_period_mask_details.creation_date%type,
35     x_created_by            IN pa_period_mask_details.created_by%type,
36     x_last_update_login     IN pa_period_mask_details.last_update_login%type,
37     x_last_updated_by       IN pa_period_mask_details.last_updated_by%type,
38     x_last_update_date      IN pa_period_mask_details.last_update_date%type);
39 
40    -- deletes record into PA_PERIOD_MASK_DETAILS table
41 
42  PROCEDURE delete_row(
43           x_period_mask_id IN pa_period_mask_details.period_mask_id%type,
44           x_from_anchor_position IN pa_period_mask_details.from_anchor_position%type);
45 
46    -- load records into PA_PERIOD_MASK_DETAILS table
47 
48 
49    PROCEDURE load_row(
50    x_period_mask_id        IN  pa_period_mask_details.period_mask_id%type,
51    x_num_of_periods        IN  pa_period_mask_details.num_of_periods%type,
52    x_anchor_period_flag    IN pa_period_mask_details.anchor_period_flag%type,
53    x_from_anchor_start     IN pa_period_mask_details.from_anchor_start%type,
54    x_from_anchor_end       IN pa_period_mask_details.from_anchor_end%type,
55    x_from_anchor_position  IN pa_period_mask_details.from_anchor_position%type,
56    x_creation_date         IN pa_period_mask_details.creation_date%type,
57    x_created_by            IN pa_period_mask_details.created_by%type,
58    x_last_update_login     IN pa_period_mask_details.last_update_login%type,
59    x_last_updated_by       IN pa_period_mask_details.last_updated_by%type,
60    x_last_update_date      IN pa_period_mask_details.last_update_date%type,
61    x_owner                 IN VARCHAR2);
62 
63 
64 END PA_PERIOD_MASK_DETAILS_PKG;