PACKAGE: APPS.PO_GEN_DIFF_PKG

Source

1 PACKAGE PO_GEN_DIFF_PKG AUTHID CURRENT_USER AS
2 /* $Header: PO_GEN_DIFF_PKG.pls 120.0.12020000.3 2013/02/13 10:40:40 amalick ship $ */
3 
4 PROCEDURE generate_differences(p_document_type VARCHAR2,
5 				p_entity_name VARCHAR2,
6 				base_doc_source VARCHAR2,
7 				base_pk1_value NUMBER,
8 				base_pk2_value NUMBER,
9 				base_pk3_value NUMBER,
10 				base_pk4_value NUMBER,
11 				base_pk5_value NUMBER,
12 				base_source_alias VARCHAR2,
13 				mod_doc_source VARCHAR2,
14 				mod_pk1_value NUMBER,
15 				mod_pk2_value NUMBER,
16 				mod_pk3_value NUMBER,
17 				mod_pk4_value NUMBER,
18 				mod_pk5_value NUMBER,
19 				mod_source_alias VARCHAR2,
20 				dest_table_name VARCHAR2,
21 				x_return_status OUT NOCOPY VARCHAR2,
22 				x_errormsg OUT NOCOPY VARCHAR2,
23 				filter_predicate1 VARCHAR2 default null,
24 				filter_predicate2 VARCHAR2 default null );
25 
26 
27 PROCEDURE find_differences (p_document_type VARCHAR2,
28 				p_entity_name VARCHAR2,
29 				dest_table_name VARCHAR2,
30 				base_pk1_value NUMBER,
31 				base_pk2_value NUMBER,
32 				base_pk3_value NUMBER,
33 				base_pk4_value NUMBER,
34 				base_pk5_value NUMBER,
35 				mod_pk1_value NUMBER,
36 				mod_pk2_value NUMBER,
37 				mod_pk3_value NUMBER,
38 				mod_pk4_value NUMBER,
39 				mod_pk5_value NUMBER);
40 
41 PROCEDURE delete_differences (p_document_type VARCHAR2,
42 				p_entity_name VARCHAR2,
43 				dest_table_name VARCHAR2,
44 				base_pk1_value NUMBER,
45 				base_pk2_value NUMBER,
46 				base_pk3_value NUMBER,
47 				base_pk4_value NUMBER,
48 				base_pk5_value NUMBER,
49 				mod_pk1_value NUMBER,
50 				mod_pk2_value NUMBER,
51 				mod_pk3_value NUMBER,
52 				mod_pk4_value NUMBER,
53 				mod_pk5_value NUMBER);
54 
55 FUNCTION getBasePK1 RETURN NUMBER;
56 FUNCTION getBasePK2 RETURN NUMBER;
57 FUNCTION getBasePK3 RETURN NUMBER;
58 FUNCTION getBasePK4 RETURN NUMBER;
59 FUNCTION getBasePK5 RETURN NUMBER;
60 FUNCTION getModPK1 RETURN NUMBER;
61 FUNCTION getModPK2 RETURN NUMBER;
62 FUNCTION getModPK3 RETURN NUMBER;
63 FUNCTION getModPK4 RETURN NUMBER;
64 FUNCTION getModPK5 RETURN NUMBER;
65 
66 --<PAR Project>
67 PROCEDURE populate_par_header;
68 PROCEDURE populate_par_lines;
69 PROCEDURE populate_par_line_locs;
70 PROCEDURE populate_par_distributions;
71 PROCEDURE populate_par_elins;
72 
73 --<PAR Approval : generate sgd for PAR>
74 PROCEDURE generate_par_differences_wf(itemtype IN VARCHAR2,
75   itemkey   IN VARCHAR2,
76   actid     IN NUMBER,
77   funcmode  IN VARCHAR2,
78   resultout OUT NOCOPY VARCHAR2);
79 
80 base_pk1 NUMBER;
81 base_pk2 NUMBER;
82 base_pk3 NUMBER;
83 base_pk4 NUMBER;
84 base_pk5 NUMBER;
85 mod_pk1 NUMBER;
86 mod_pk2 NUMBER;
87 mod_pk3 NUMBER;
88 mod_pk4 NUMBER;
89 mod_pk5 NUMBER;
90 
91 g_log_module_name varchar2(30) := 'PO_GEN_DIFF_PKG';
92 G_NULL_CHAR CONSTANT VARCHAR(1) := FND_API.G_NULL_CHAR;
93 G_NULL_NUM  CONSTANT    NUMBER  	:= 9.99E125;
94 
95 END;
96