1 PACKAGE po_compare_revisions AUTHID CURRENT_USER AS
2 /* $Header: POXPOCMS.pls 115.4 2002/11/23 02:49:36 sbull ship $ */
3
4 PROCEDURE purge ( errbuf OUT NOCOPY VARCHAR2,
5 retcode OUT NOCOPY NUMBER,
6 p_date IN VARCHAR2);
7
8 FUNCTION get_un_number ( p_un_number_id IN NUMBER )
9 RETURN VARCHAR2;
10
11 FUNCTION get_item_number (p_item_id IN NUMBER)
12 RETURN VARCHAR2;
13
14 FUNCTION get_hazard_class ( p_hazard_class_id IN NUMBER )
15 RETURN VARCHAR2;
16
17 FUNCTION get_ap_terms ( p_term_id IN NUMBER )
18 RETURN VARCHAR2;
19
20 FUNCTION get_buyer ( p_agent_id IN NUMBER )
21 RETURN VARCHAR2;
22
23 FUNCTION get_vendor_contact ( p_vendor_contact_id IN NUMBER )
24 RETURN VARCHAR2;
25
26 FUNCTION get_location ( p_location_id IN number )
27 RETURN VARCHAR2;
28
29 FUNCTION get_source_quotation_header ( p_header_id IN NUMBER )
30 RETURN VARCHAR2;
31
32 FUNCTION get_source_quotation_line ( p_line_id IN NUMBER )
33 RETURN VARCHAR2;
34
35 FUNCTION get_po_lookup (
36 p_lookup_type IN VARCHAR2,
37 p_lookup_code IN VARCHAR2 )
38 RETURN VARCHAR2;
39
40 PROCEDURE insert_changes (
41 p_line_seq IN NUMBER,
42 p_header_id IN NUMBER,
43 p_release_id IN NUMBER,
44 p_line_id IN NUMBER,
45 p_location_id IN NUMBER,
46 p_distribution_id IN NUMBER,
47 p_item_id IN NUMBER,
48 p_po_num IN VARCHAR2,
49 p_revision_num IN NUMBER,
50 p_line_num IN NUMBER,
51 p_location_num IN NUMBER,
52 p_distribution_num IN NUMBER,
53 p_level_altered IN VARCHAR2,
54 p_field_altered IN VARCHAR2,
55 p_changes_from IN VARCHAR2,
56 p_changes_to IN VARCHAR2
57 );
58
59 PROCEDURE verify_no_differences( p_line_seq IN NUMBER );
60
61 PROCEDURE compare_headers(
62 p_po_from IN po_headers_archive%ROWTYPE,
63 p_po_to IN po_headers_archive%ROWTYPE,
64 p_sequence IN NUMBER
65 );
66
67 PROCEDURE compare_releases(
68 p_release_from IN po_releases_archive%ROWTYPE,
69 p_release_to IN po_releases_archive%ROWTYPE,
70 p_sequence IN NUMBER
71 );
72
73 PROCEDURE compare_lines(
74 p_line_from IN po_lines_archive%ROWTYPE,
75 p_line_to IN po_lines_archive%ROWTYPE,
76 p_sequence IN NUMBER
77 );
78
79 PROCEDURE compare_locations(
80 p_loc_from IN po_line_locations_archive%ROWTYPE,
81 p_loc_to IN po_line_locations_archive%ROWTYPE,
82 p_sequence IN NUMBER
83 );
84
85 PROCEDURE compare_distributions(
86 p_dist_from IN po_distributions_archive%ROWTYPE,
87 p_dist_to IN po_distributions_archive%ROWTYPE,
88 p_sequence IN NUMBER
89 );
90
91 /*Bug 1181007
92 A new function added to fetch the charge account with the ccid from
93 the table gl_code_combinations_kfv
94 */
95 FUNCTION get_charge_account (p_code_combination_id IN NUMBER)
96 RETURN VARCHAR2;
97
98 END po_compare_revisions;