[Home] [Help]
PACKAGE: APPS.QPR_PRICE_NEGOTIATION_PUB
Source
1 PACKAGE QPR_PRICE_NEGOTIATION_PUB AS
2 /* $Header: QPRADEAPS.pls 120.11 2008/05/30 09:15:00 vinnaray ship $ */
3
4 G_PRODUCT_STATUS VARCHAR2(1);
5 G_ORIGIN number;
6 exe_severe_error exception;
7
8 FUNCTION Get_QPR_Status RETURN VARCHAR2;
9
10 /*---------------------------------------------------------------
11 | Usage:
12 | errbuf - contains error message
13 | retcode - returns 2 in case of error
14 | p_quote_origin - takes origin application id
15 | p_quote_number - Quote number
16 | p_quote_version - Quote version
17 | p_order_type_name - needed in case of 'OM', takes the order type name
18 | p_quote_header_id - Quote header_id
19 | p_instance_id - identification of transaction instance - default null
20 | p_simulation - A flag ('Y'/'N') to indicate if the values are
21 | simulated/actual so that the price request status is set appropriately
22 | p_response_id - Price negotiation response id created
23 | p_is_deal_compliant - flag ('Y'/'N') indicating if the quote price is
24 | compliant or not.
25 | p_rules_desc - lists the lines that are not compliant
26 |--------------------------------------------------------------*/
27
28 procedure create_pn_request(
29 errbuf out nocopy varchar2,
30 retcode out nocopy varchar2,
31 p_quote_origin in number,
32 p_quote_number in number,
33 p_quote_version in number,
34 p_order_type_name in varchar2,
35 p_quote_header_id in number,
36 p_instance_id in number default null,
37 p_simulation in varchar2 default 'Y',
38 p_response_id out nocopy number,
39 p_is_deal_compliant out nocopy varchar2,
40 p_rules_desc out nocopy varchar2);
41
42 procedure get_pn_approval_status(
43 errbuf out nocopy varchar2,
44 retcode out nocopy varchar2,
45 p_quote_origin in number,
46 p_quote_header_id in number,
47 o_deal_id out nocopy number,
48 o_status out nocopy varchar2);
49
50 procedure debug_log(text varchar2);
51
52 -- New Integration APIs.
53
54 function has_active_requests(
55 p_quote_origin number,
56 p_quote_header_id number,
57 p_instance_id number) return varchar2;
58
59 function has_saved_requests(
60 p_quote_origin number,
61 p_quote_header_id number,
62 p_instance_id number) return varchar2;
63
64 procedure cancel_active_requests(p_quote_origin in number,
65 p_quote_header_id in number,
66 instance_id number,
67 suppress_event in boolean default false,
68 x_return_status out nocopy varchar2,
69 x_mesg_data out nocopy varchar2);
70
71 procedure create_request(p_quote_origin in number,
72 p_quote_header_id in number,
73 p_instance_id number,
74 suppress_event in boolean default false,
75 p_is_deal_compliant out nocopy varchar2,
76 p_rules_desc out nocopy varchar2,
77 x_return_status out nocopy varchar2,
78 x_mesg_data out nocopy varchar2);
79
80 function get_redirect_function(
81 p_quote_origin in number,
82 p_quote_header_id in number,
83 instance_id number,
84 skip_search in boolean default true) return varchar2;
85
86 procedure initiate_deal(source_id in number,
87 source_ref_id in number,
88 instance_id number,
89 updatable varchar2,
90 redirect_function out nocopy varchar2,
91 p_is_deal_compliant out nocopy varchar2,
92 p_rules_desc out nocopy varchar2,
93 x_return_status out nocopy varchar2,
94 x_mesg_data out nocopy varchar2);
95 END;
96
97