PACKAGE: APPS.QPR_DEAL_PVT

Source

1 PACKAGE QPR_DEAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPRPDPRS.pls 120.11 2008/06/19 11:05:35 vinnaray ship $ */
3 /* Public Procedures */
4    TYPE num_type IS TABLE OF Number;
5 
6 --g_origin number;
7 
8 TYPE TERM_DATA_REC is record
9 (
10   TERM_TYPE	varchar2(30),
11   DIM_CODE	varchar2(30),
12   LEVEL_CODE	varchar2(30)
13 );
14 
15 type TERM_SETUP_TBL_TYPE is table of TERM_DATA_REC;
16 
17 
18 type PN_AW_DATA_REC is record
19 (
20   PN_LINE_ID		number,
21   CUSTOMER_SK		varchar2(240),
22   PRODUCT_DIM_SK	varchar2(240),
23   PR_SEGMENT_SK         varchar2(240),
24   DEAL_CREATION_DATE    date,
25   DEAL_CURRENCY		varchar2(240),
26   PAYMENT_TERM_CODE	varchar2(240),
27   SHIP_METHOD_CODE	varchar2(240),
28   REBATE_CODE		varchar2(240),
29   GROSS_REVENUE		number,
30   PAYMENT_TERM_OAD_VAL	number,
31   SHIP_METHOD_OAD_VAL	number,
32   REBATE_OAD_VAL	number,
33 	GET_COST_FLAG varchar2(1),
34 	UNIT_COST	number
35 );
36 
37 type PN_AW_TBL_TYPE is table of PN_AW_DATA_REC ;
38 
39 procedure debug_ext_log(text in varchar2, source_id in number);
40 
41 procedure get_line_aw_details(
42 			errbuf out nocopy varchar2,
43 			retcode out nocopy varchar2,
44 			p_price_plan_id IN NUMBER,
45                         p_instance_id in number,
46 		p_t_line_det IN OUT nocopy QPR_DEAL_PVT.PN_AW_TBL_TYPE);
47 
48 function assign_aw(errbuf out nocopy varchar2,
49                    retcode out nocopy varchar2,
50                    p_instance_id in number,
51                    p_inventory_item_id in number,
52                    p_org_id in number,
53                    p_sales_rep_id in number,
54                    p_customer_id in number,
55                    p_geography_id in number,
56                    p_sales_channel_code in varchar2,
57                    p_pr_segment_id in number,
58                    p_aw_name out nocopy varchar2) return number;
59 
60 function get_volume_band(errbuf out nocopy varchar2,
61                          retcode out nocopy varchar2,
62                          p_inventory_item_id number,
63 			 p_ordered_qty number,
64 			 p_transf_group_id number) return varchar2;
65 
66 function get_number(p_char varchar2) return number;
67 
68 procedure handle_request_event(p_quote_origin in number,
69 			p_quote_header_id in number,
70 			p_request_header_id number,
71 			p_response_header_id number,
72 			p_instance_id number default null,
73 			callback_status varchar2,
74 			return_status out nocopy varchar2,
75                         p_err_msg out nocopy varchar2);
76 
77 procedure cancel_pn_request(p_quote_origin in number,
78 			    p_quote_header_id in number,
79 			    p_instance_id in number,
80 			    return_status out nocopy varchar2);
81 
82 procedure update_request(p_request_header_id number,
83 			status varchar2);
84 
85 function get_redirect_function(
86 			p_quote_origin in number,
87 			p_quote_header_id in number,
88 			p_instance_id in number,
89 			skip_search in boolean default true) return varchar2;
90 
91 function user_allowed( p_response_hdr_id in number,
92 			p_fnd_user in varchar2) return varchar2;
93 function actions_enable( p_response_hdr_id in number) return varchar2;
94 
95 function has_active_requests(p_quote_origin number, p_quote_header_id number,
96 			p_instance_id in number)
97 return boolean;
98 
99 function has_saved_requests(p_quote_origin number, p_quote_header_id number,
100 			p_instance_id in number)
101 return boolean;
102 
103 END QPR_DEAL_PVT ;