PACKAGE: APPS.POR_CHANGE_REQUEST_PKG

Source

1 PACKAGE por_change_request_pkg AUTHID CURRENT_USER AS
2 /* $Header: PORRCHOS.pls 120.1.12010000.3 2008/11/25 06:18:49 rojain ship $ */
3 
4   FUNCTION is_order_values_differ (reqlineid NUMBER) RETURN VARCHAR2;
5 
6   FUNCTION get_changed_req_total(reqheaderid IN NUMBER) RETURN NUMBER;
7 
8   FUNCTION get_changed_nonrec_tax_total(reqheaderid IN NUMBER) RETURN NUMBER;
9 
10   FUNCTION get_changed_line_total(reqlineid IN NUMBER) RETURN NUMBER;
11 
12   FUNCTION get_int_changed_line_total(reqlineid IN NUMBER) RETURN NUMBER;
13 
14   FUNCTION get_changed_cur_line_total(reqlineid IN NUMBER) RETURN NUMBER;
15 
16   FUNCTION get_chn_line_nonrec_tax_total(reqlineid IN NUMBER) RETURN NUMBER;
17 
18   FUNCTION get_changed_line_rec_tax_total(reqlineid IN NUMBER) RETURN NUMBER;
19 
20   FUNCTION get_intchnline_nonrectax_total(reqlineid IN NUMBER) RETURN NUMBER;
21 
22   FUNCTION get_intchnline_rectax_total(reqlineid IN NUMBER) RETURN NUMBER;
23 
24 
25   FUNCTION get_change_hist_overall_status(requestgroupid IN NUMBER, reqlineid NUMBER)
26   RETURN VARCHAR2;
27 
28   FUNCTION get_multiple_distributions(req_line_id NUMBER) RETURN VARCHAR2;
29 
30   FUNCTION get_changed_line_quantity(reqlineid IN NUMBER) RETURN NUMBER;
31 
32   FUNCTION get_unit_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
33 
34   FUNCTION get_currency_unit_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
35 
36   FUNCTION get_hist_cur_line_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
37 
38   FUNCTION get_hist_line_qty(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
39 
40   FUNCTION get_hist_chng_cur_line_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
41 
42   FUNCTION get_hist_changed_line_qty(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
43 
44   FUNCTION get_hist_line_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
45 
46   FUNCTION get_hist_changed_line_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
47 
48   FUNCTION get_hist_line_total(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
49 
50   FUNCTION get_hist_changed_line_total(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
51 
52   FUNCTION get_price_break_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
53 
54   FUNCTION get_price_break_cur_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
55 
56   FUNCTION get_price_break_trx_price(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
57 
58   FUNCTION get_dist_changed_line_qty(reqheaderid NUMBER, reqlineid NUMBER) RETURN NUMBER;
59 
60   FUNCTION get_dist_changed_line_amt(reqheaderid NUMBER, reqlineid NUMBER) RETURN NUMBER;
61 
62   FUNCTION get_hist_changed_line_amount(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
63 
64   FUNCTION get_hist_line_amount(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
65 
66   FUNCTION get_hist_cur_line_total(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
67 
68   FUNCTION get_hist_cur_line_amount(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
69 
70   FUNCTION get_hist_chng_cur_line_total(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
71 
72   FUNCTION get_hist_chng_cur_line_amount(reqlineid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
73 
74   FUNCTION get_chng_hist_req_status_notfn(requestgroupid IN NUMBER, reqlineid NUMBER) RETURN VARCHAR2;
75 
76   FUNCTION get_hist_cur_dist_amount(reqdistid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
77 
78   FUNCTION get_chng_hist_cur_dist_amount(reqdistid IN NUMBER, chgreqgrpid IN NUMBER) RETURN NUMBER;
79 
80 END por_change_request_pkg;