PACKAGE: APPS.OKS_SUBSCRIPTION_PUB

Source

1 PACKAGE OKS_SUBSCRIPTION_PUB As
2 /* $Header: OKSPSUBS.pls 120.0 2005/05/25 17:44:09 appldev noship $*/
3 
4   Subtype rangetab Is OKS_SUBSCRIPTION_PVT.rangetab;
5 
6   Procedure create_default_schedule
7    ( p_api_version   IN  NUMBER,
8      p_init_msg_list IN  VARCHAR2,
9      x_return_status OUT NOCOPY VARCHAR2,
10      x_msg_count     OUT NOCOPY Number,
11      x_msg_data      OUT NOCOPY VARCHAR2,
12      p_cle_id        IN  NUMBER,
13      p_intent        IN  VARCHAR2
14    );
15 
16   Procedure recreate_schedule
17    ( p_api_version   IN  NUMBER,
18      p_init_msg_list IN  VARCHAR2,
19      x_return_status OUT NOCOPY VARCHAR2,
20      x_msg_count     OUT NOCOPY Number,
21      x_msg_data      OUT NOCOPY VARCHAR2,
22      p_cle_id        IN  NUMBER,
23      p_intent        IN  VARCHAR2,
24      x_quantity      OUT NOCOPY NUMBER
25    );
26 
27   Procedure recreate_instance
28    ( p_api_version   IN  NUMBER,
29      p_init_msg_list IN  VARCHAR2,
30      x_return_status OUT NOCOPY VARCHAR2,
31      x_msg_count     OUT NOCOPY Number,
32      x_msg_data      OUT NOCOPY VARCHAR2,
33      p_cle_id        IN  NUMBER,
34 	p_custacct_id   IN  NUMBER
35    );
36 
37   Procedure copy_subscription
38    ( p_api_version   IN  NUMBER,
39      p_init_msg_list IN  VARCHAR2,
40      x_return_status OUT NOCOPY VARCHAR2,
41      x_msg_count     OUT NOCOPY Number,
42      x_msg_data      OUT NOCOPY VARCHAR2,
43      p_source_cle_id IN  NUMBER,
44      p_target_cle_id IN  NUMBER,
45      p_intent        IN  VARCHAR2
46   );
47 
48   Procedure undo_subscription
49    ( p_api_version   IN  NUMBER,
50      p_init_msg_list IN  VARCHAR2,
51      x_return_status OUT NOCOPY VARCHAR2,
52      x_msg_count     OUT NOCOPY Number,
53      x_msg_data      OUT NOCOPY VARCHAR2,
54      p_cle_id        IN  NUMBER
55   );
56 
57   Procedure validate_pattern
58    ( p_api_version   IN  NUMBER,
59      p_init_msg_list IN  VARCHAR2,
60      x_return_status OUT NOCOPY VARCHAR2,
61      x_msg_count     OUT NOCOPY Number,
62      x_msg_data      OUT NOCOPY VARCHAR2,
63      p_instring      IN  VARCHAR2,
64      p_lowval        IN  NUMBER,
65      p_highval       IN  NUMBER,
66      x_outstring     OUT NOCOPY VARCHAR2,
67      x_outtab        OUT NOCOPY rangetab
68    );
69 
70   Procedure get_subs_qty
71    ( p_cle_id        IN  NUMBER,
72      x_return_status OUT NOCOPY VARCHAR2,
73      x_quantity      OUT NOCOPY NUMBER,
74      x_uom_code      OUT NOCOPY VARCHAR2
75    );
76 
77   Procedure stretch_effectivity
78    ( p_start_date    IN  DATE,
79      p_end_date      IN  DATE,
80      p_frequency     IN  VARCHAR2,
81      x_new_start_dt  OUT NOCOPY DATE,
82      x_new_end_dt    OUT NOCOPY DATE
83    );
84 
85   Function subs_termn_amount
86    ( p_cle_id        IN  NUMBER,
87      p_termn_date    IN  DATE
88    ) Return NUMBER;
89 
90   Function is_subs_tangible
91    ( p_cle_id        IN  NUMBER
92    ) Return BOOLEAN;
93 
94   Function map_freq_uom
95    ( p_frequency     IN  VARCHAR2
96    ) Return VARCHAR2;
97 
98   Procedure db_commit;
99 
100 END OKS_SUBSCRIPTION_PUB;
101