[Home] [Help]
PACKAGE: APPS.ARP_CMERGE_MASTER
Source
1 PACKAGE ARP_CMERGE_MASTER AS
2 /* $Header: ARHCMSTS.pls 120.6.12000000.3 2007/10/10 10:39:00 kguggila ship $ */
3
4 PROCEDURE add_request (
5 req_id NUMBER,
6 program_name VARCHAR2 );
7
8 PROCEDURE mark_merge_rows (
9 req_id NUMBER,
10 p_process_flag VARCHAR2,
11 p_merge_rule VARCHAR2 DEFAULT 'OLD',
12 p_priority VARCHAR2 , --3897822
13 p_number_of_merges NUMBER );
14
15
16 PROCEDURE validate_merges (
17 req_id NUMBER,
18 p_process_flag VARCHAR2 DEFAULT 'N' );
19
20 PROCEDURE partiton_merge_data (
21 req_id NUMBER,
22 last_set OUT NOCOPY NUMBER,
23 p_process_flag VARCHAR2 DEFAULT 'N');
24
25 PROCEDURE unpartiton_merge_data (
26 req_id NUMBER,
27 last_set OUT NOCOPY NUMBER,
28 set_num NUMBER );
29
30 PROCEDURE merge_customers (
31 req_id NUMBER,
32 set_num NUMBER,
33 process_mode VARCHAR2,
34 status OUT NOCOPY NUMBER );
35
36 PROCEDURE merge_products (
37 req_id NUMBER,
38 set_num NUMBER,
39 process_mode VARCHAR2,
40 status OUT NOCOPY NUMBER);
41
42 PROCEDURE merge_products (
43 req_id NUMBER,
44 set_num NUMBER,
45 process_mode VARCHAR2,
46 status OUT NOCOPY NUMBER,
47 error_text OUT NOCOPY VARCHAR2 );
48
49 PROCEDURE delete_rows (
50 req_id NUMBER,
51 set_num NUMBER,
52 status OUT NOCOPY NUMBER );
53
54 PROCEDURE done_merge_rows (
55 req_id NUMBER,
56 set_num NUMBER );
57
58 PROCEDURE clear_error_merge_rows (
59 req_id NUMBER );
60
61 PROCEDURE reset_merge_rows (
62 req_id NUMBER,
63 set_num NUMBER,
64 p_process_flag VARCHAR2 DEFAULT 'N');
65
66 PROCEDURE remove_request (
67 req_id NUMBER );
68
69 PROCEDURE veto_delete(req_id NUMBER,
70 set_num NUMBER,
71 from_customer_id NUMBER DEFAULT NULL,
72 veto_reason VARCHAR2,
73 part_delete VARCHAR2 DEFAULT 'N');
74
75 PROCEDURE raise_events(p_req_id NUMBER); --4230396
76
77 FUNCTION operating_unit RETURN VARCHAR2; --5528318
78
79 END ARP_CMERGE_MASTER;