PACKAGE: APPS.QPR_DEAL_ETL

Source

1 PACKAGE QPR_DEAL_ETL AUTHID CURRENT_USER AS
2 /* $Header: QPRUDPRS.pls 120.6 2008/03/31 11:07:28 kdhabali ship $ */
3 /* Public Procedures */
4    TYPE num_type      IS TABLE OF Number         INDEX BY BINARY_INTEGER;
5    TYPE char240_type  IS TABLE OF Varchar2(240)  INDEX BY BINARY_INTEGER;
6    TYPE real_type     IS TABLE OF Number(32,10)  INDEX BY BINARY_INTEGER;
7    TYPE date_type     IS TABLE OF Date           INDEX BY BINARY_INTEGER;
8 
9 g_t_pol_det qpr_policy_eval.POLICY_DET_REC_TYPE;
10 g_t_aw_det qpr_deal_pvt.PN_AW_TBL_TYPE;
11 g_origin number;
12 
13 procedure process_deal(
14                         errbuf              OUT NOCOPY VARCHAR2,
15                         retcode             OUT NOCOPY VARCHAR2,
16                         f_source_ref_id NUMBER,
17 			t_source_ref_id NUMBER,
18 			reprocess varchar2 default 'N',
19 			reload varchar2 default 'N');
20 
21 procedure process_deal_api(
22                       errbuf              OUT NOCOPY VARCHAR2,
23                       retcode             OUT NOCOPY VARCHAR2,
24                       p_instance_id in number,
25                       p_source_id in number,
26                       p_quote_header_id in number,
27                       p_simulation in varchar2 default 'Y',
28                       p_response_id out nocopy number,
29                       p_is_deal_compliant out nocopy varchar2,
30                       p_rules_desc out nocopy varchar2);
31 
32 procedure calculate_score(
33         errbuf out nocopy varchar2,
34         retcode out nocopy varchar2,
35         i_response_header_id number,
36         i_line_id number,
37         i_date date,
38         i_pr_segment_id number,
39 	i_inventory_item_id number,
40         i_is_qty_changed in varchar2 default 'N',
41         i_ordered_qty number,
42         i_list_price number,
43         i_unit_cost number,
44         i_pock_margin number,
45         i_inv_price number,
46         i_recommended_price number,
47         o_line_score out nocopy number);
48 
49 
50 procedure create_deal_version(errbuf out nocopy varchar2,
51                               retcode out nocopy varchar2,
52                               p_response_hdr_id in number,
53                               p_new_resp_hdr_id out nocopy number);
54 
55 END QPR_DEAL_ETL ;