[Home] [Help]
PACKAGE: APPS.OKS_SUBSCRIPTION_PVT
Source
1 PACKAGE OKS_SUBSCRIPTION_PVT As
2 /* $Header: OKSRSUBS.pls 120.1 2005/06/28 05:30:32 jvorugan noship $*/
3
4 -- Constants used for Message Logging
5 G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6 G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7 G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8 G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9 G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10 G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11 G_LEVEL_CURRENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12 G_MODULE_CURRENT CONSTANT VARCHAR2(255) := 'oks.plsql.oks_subscription_pvt';
13 -- Added global constants
14 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
17
18 TYPE rangerec is RECORD
19 (low NUMBER,
20 high NUMBER);
21 TYPE rangetab is TABLE of rangerec INDEX BY BINARY_INTEGER;
22
23 Procedure create_default_schedule
24 ( p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY Number,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_cle_id IN NUMBER,
30 p_intent IN VARCHAR2
31 );
32
33 Procedure recreate_schedule
34 ( p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY Number,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_cle_id IN NUMBER,
40 p_intent IN VARCHAR2,
41 x_quantity OUT NOCOPY NUMBER
42 );
43
44 Procedure recreate_instance
45 ( p_api_version IN NUMBER,
46 p_init_msg_list IN VARCHAR2,
47 x_return_status OUT NOCOPY VARCHAR2,
48 x_msg_count OUT NOCOPY Number,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 p_cle_id IN NUMBER,
51 p_custacct_id IN NUMBER
52 );
53
54 Procedure copy_subscription
55 ( p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY Number,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_source_cle_id IN NUMBER,
61 p_target_cle_id IN NUMBER,
62 p_intent IN VARCHAR2
63 );
64
65 Procedure undo_subscription
66 ( p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY Number,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_cle_id IN NUMBER
72 );
73
74 Procedure validate_pattern
75 ( p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY Number,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_instring IN VARCHAR2,
81 p_lowval IN NUMBER,
82 p_highval IN NUMBER,
83 x_outstring OUT NOCOPY VARCHAR2,
84 x_outtab OUT NOCOPY rangetab
85 );
86
87 Procedure get_subs_qty
88 ( p_cle_id IN NUMBER,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_quantity OUT NOCOPY NUMBER,
91 x_uom_code OUT NOCOPY VARCHAR2
92 );
93
94 Procedure stretch_effectivity
95 ( p_start_date IN DATE,
96 p_end_date IN DATE,
97 p_frequency IN VARCHAR2,
98 x_new_start_dt OUT NOCOPY DATE,
99 x_new_end_dt OUT NOCOPY DATE
100 );
101
102 Function subs_termn_amount
103 ( p_cle_id IN NUMBER,
104 p_termn_date IN DATE
105 ) Return NUMBER;
106
107 Function is_subs_tangible
108 ( p_cle_id IN NUMBER
109 ) Return BOOLEAN;
110
111 Function map_freq_uom
112 ( p_frequency IN VARCHAR2
113 ) Return VARCHAR2;
114
115 Procedure db_commit;
116
117 END OKS_SUBSCRIPTION_PVT;
118