1 PACKAGE pos_compare_revisions AS
2 /* $Header: POSPOCMS.pls 120.5 2006/05/10 15:04:18 abtrived noship $ */
3
4 PROCEDURE purge ( errbuf OUT NOCOPY VARCHAR2,
5 retcode OUT NOCOPY NUMBER,
6 p_date IN DATE DEFAULT SYSDATE - 1/12 );
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 p_enabled_org_name in VARCHAR2 default null,
58 p_price_diff_num in NUMBER default null,
59 p_change_from_date in DATE default null,
60 p_change_to_date IN DATE DEFAULT NULL,
61 p_item in varchar2 default null,
62 p_job in varchar2 default null
63 );
64
65
66 PROCEDURE verify_no_differences( p_line_seq IN NUMBER );
67
68 PROCEDURE compare_headers(
69 p_po_from IN po_headers_archive_all%ROWTYPE,
70 p_po_to IN po_headers_archive_all%ROWTYPE,
71 p_sequence IN NUMBER,
72 p_comparison_flag IN VARCHAR2
73 );
74
75 PROCEDURE compare_releases(
76 p_release_from IN po_releases_archive_all%ROWTYPE,
77 p_release_to IN po_releases_archive_all%ROWTYPE,
78 p_sequence IN NUMBER
79 );
80 PROCEDURE compare_ga_assignments(
81 p_ga_ass_from in po_ga_org_assignments_archive%ROWTYPE,
82 p_ga_ass_to in po_ga_org_assignments_archive%ROWTYPE,
83 p_sequence IN NUMBER
84 );
85
86 PROCEDURE compare_price_diffs(
87 p_pdiffs_from in po_price_differentials_archive%ROWTYPE,
88 p_pdiffs_to in po_price_differentials_archive%ROWTYPE,
89 p_sequence IN NUMBER
90 );
91
92 PROCEDURE compare_lines(
93 p_line_from IN po_lines_archive_all%ROWTYPE,
94 p_line_to IN po_lines_archive_all%ROWTYPE,
95 p_sequence IN NUMBER
96 );
97
98 PROCEDURE compare_locations(
99 p_loc_from IN po_line_locations_archive_all%ROWTYPE,
100 p_loc_to IN po_line_locations_archive_all%ROWTYPE,
101 p_sequence IN NUMBER
102 );
103
104 PROCEDURE compare_distributions(
105 p_dist_from IN po_distributions_archive_all%ROWTYPE,
106 p_dist_to IN po_distributions_archive_all%ROWTYPE,
107 p_sequence IN NUMBER
108 );
109
110 /*Bug 1181007
111 A new function added to fetch the charge account with the ccid from
112 the table gl_code_combinations_kfv
113 */
114 FUNCTION get_charge_account (p_code_combination_id IN NUMBER)
115 RETURN VARCHAR2;
116
117 /* bug 4261155
118 Adding a new function to get requestor name from per_people_f
119 */
120 FUNCTION get_requestor ( p_agent_id IN NUMBER )
121 RETURN VARCHAR2;
122
123 /* bug 5215207
124 Adding a new function to get owner for a work confirmation
125 */
126 FUNCTION get_owner ( p_work_approver_id IN NUMBER )
127 RETURN VARCHAR2;
128
129 /*
130 bug 5106221
131 */
132 FUNCTION get_shopping_category( p_category_id IN NUMBER )
133 RETURN VARCHAR2;
134
135 /* Bug 4347578
136 */
137 FUNCTION get_nextval
138 RETURN NUMBER;
139
140 FUNCTION get_job ( p_job_id IN NUMBER )
141 RETURN VARCHAR2;
142
143 FUNCTION get_item ( p_item_id IN NUMBER, p_org_id IN NUMBER )
144 RETURN VARCHAR2;
145
146 FUNCTION Get_Line_adv_Amount_revision(
147 p_po_line_id IN NUMBER, p_revision_num IN NUMBER)
148 RETURN NUMBER;
149
150 FUNCTION Get_ship_val_percent_revision (
151 p_po_line_location_id IN NUMBER, p_revision_num IN NUMBER)
152 RETURN NUMBER;
153
154 END pos_compare_revisions;