[Home] [Help]
PACKAGE: APPS.OKL_DEAL_TERMS_PVT
Source
1 Package OKL_DEAL_TERMS_PVT AUTHID CURRENT_USER as
2 /* $Header: OKLRDTRS.pls 120.2 2008/06/08 01:53:06 avsingh noship $ */
3
4 -------------------------------------------------------------------------------------------------
5 -- COMPOSITE VARIABLES
6 -------------------------------------------------------------------------------------------------
7 TYPE billing_setup_rec_type IS RECORD (
8 chr_id OKC_K_HEADERS_B.id%TYPE,
9 cle_id OKC_K_LINES_B.id%TYPE,
10 asset_number OKC_K_LINES_TL.name%TYPE,
11 item_description OKC_K_LINES_TL.item_description%TYPE,
12 rgp_id OKC_rule_groups_b.id%TYPE,
13 bill_to_site_use_id OKC_K_LINES_B.bill_to_site_use_id%TYPE,
14 bill_to_site_name HZ_CUST_SITE_USES_ALL.location%TYPE,
15 rgp_labill_lapmth_id OKC_RULE_GROUPS_B.id%TYPE,
16 rgp_labill_labacc_id OKC_RULE_GROUPS_B.id%TYPE,
17 rgp_labill_lainvd_id OKC_RULE_GROUPS_B.id%TYPE,
18 rgp_labill_lainpr_id OKC_RULE_GROUPS_B.id%TYPE,
19 rul_lapmth_id OKC_RULES_B.ID%TYPE,
20 rul_labacc_id OKC_RULES_B.ID%TYPE,
21 rul_lainvd_id OKC_RULES_B.ID%TYPE,
22 rul_lainpr_id OKC_RULES_B.ID%TYPE,
23 rul_lapmth_object1_id1 OKC_RULES_B.object1_id1%TYPE,
24 rul_lapmth_object1_id2 OKC_RULES_B.object1_id2%TYPE,
25 rul_lapmth_name AR_RECEIPT_METHODS.name%TYPE,
26 rul_labacc_object1_id1 OKC_RULES_B.object1_id1%TYPE,
27 rul_labacc_object1_id2 OKC_RULES_B.object1_id2%TYPE,
28 rul_labacc_name OKX_RCPT_METHOD_ACCOUNTS_V.name%TYPE,
29 rul_labacc_bank_name AP_BANK_BRANCHES.bank_name%TYPE,
30 lainvd_invoice_format_meaning VARCHAR2(200),
31 lainvd_rule_information1 VARCHAR2(200),
32 lainvd_rule_information3 VARCHAR2(200),
33 lainvd_rule_information4 VARCHAR2(200),
34 rul_lainvd_object1_id1 OKC_RULES_B.object1_id1%TYPE,
35 rul_lainvd_object1_id2 OKC_RULES_B.object1_id2%TYPE,
36 rul_lainvd_name VARCHAR2(200),
37 lainpr_rule_information1 VARCHAR2(200),
38 lainpr_rule_information2 VARCHAR2(200));
39
40 TYPE rvi_rec_type IS RECORD (
41 line_id OKC_K_LINES_B.id%type,
42 chr_id OKC_K_HEADERS_B.id%TYPE,
43 fee_type VARCHAR2(250),
44 rgp_id OKC_RULE_GROUPS_b.id%TYPE,
45 rgd_code OKC_RULE_GROUPS_B.rgd_code%TYPE,
46 rgp_larvin_larvau_id OKC_RULE_GROUPS_B.id%TYPE,
47 rgp_larvin_larvam_id OKC_RULE_GROUPS_B.id%TYPE,
48 rul_larvau_id OKC_RULES_B.ID%TYPE,
49 larvau_rule_info_cat OKC_RULES_B.rule_information_category%TYPE,
50 rul_larvam_id OKC_RULES_B.ID%TYPE,
51 larvam_rule_info_cat OKC_RULES_B.rule_information_category%TYPE,
52 larvau_rule_information1 OKC_RULES_B.rule_information1%TYPE,
53 larvam_rule_information4 OKC_RULES_B.rule_information4%TYPE,
54 item_id1 OKL_STRM_TYPE_B.id%TYPE,
55 item_name OKL_STRM_TYPE_TL.name%TYPE);
56
57 PROCEDURE delete_terms(
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_chr_id IN NUMBER,
64 p_rgp_id IN NUMBER,
65 p_page_name IN VARCHAR2);
66
67 PROCEDURE process_billing_setup(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_rgpv_rec IN billing_setup_rec_type,
74 x_rgpv_rec OUT NOCOPY billing_setup_rec_type);
75
76 PROCEDURE process_rvi(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_rgpv_rec IN rvi_rec_type,
83 x_rgpv_rec OUT NOCOPY rvi_rec_type);
84
85 PROCEDURE load_billing_setup(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_chr_id IN NUMBER,
92 x_billing_setup_rec OUT NOCOPY billing_setup_rec_type);
93
94 PROCEDURE load_rvi(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_chr_id IN NUMBER,
101 x_rvi_rec OUT NOCOPY rvi_rec_type);
102
103 -- Start of comments
104 -- API name : delete_tnc_group
105 -- Pre-reqs : None
106 -- Function : This procedure deletes the tnc group
107 -- Parameters :
108 -- IN : p_api_version - Standard input parameter
109 -- p_init_msg_list - Standard input parameter
110 -- p_tnc_id - terms and conditions record id
111 -- Version : 1.0
112 -- History : 03-Jun-08 avsingh Created
113 -- End of comments
114
115 PROCEDURE delete_tnc_group(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_tnc_id IN NUMBER
122 );
123
124 End OKL_DEAL_TERMS_PVT;