DBA Data[Home] [Help]

PACKAGE: APPS.GMF_CUSTOMER_SYNC

Source


1 PACKAGE GMF_CUSTOMER_SYNC AUTHID CURRENT_USER AS
2 /* $Header: gmfcsyns.pls 115.6 2002/11/11 00:36:08 rseshadr ship $ */
3 
4 PROCEDURE RUN(
5 	errbuf 			OUT	NOCOPY VARCHAR2,
6 	retcode			OUT	NOCOPY VARCHAR2,
7 	pco_code		IN 	VARCHAR2,
8 	pcustomer_number	IN	VARCHAR2,
9 	psync_all		IN 	VARCHAR2,
10 	phot_sync		IN	VARCHAR2);
11 
12 PROCEDURE INSERT_UPDATE_CUSTOMER(
13 	r			IN OUT	NOCOPY opm_customers%ROWTYPE);
14 
15 PROCEDURE INSERT_CUSTOMER_SHIPPER(
16 	r			IN OUT	NOCOPY opm_customers%ROWTYPE);
17 
18 PROCEDURE INSERT_CUSTOMER_ASSOCIATIONS(
19 	r			IN OUT	NOCOPY opm_customers%ROWTYPE);
20 
21 PROCEDURE INSERT_INTERFACE_ROW(
22 	r			IN OUT	NOCOPY opm_customers%ROWTYPE);
23 
24 PROCEDURE DELETE_INTERFACE_ROW(
25 	r			IN OUT	NOCOPY opm_customers%ROWTYPE);
26 
27 PROCEDURE INSERT_CUSTOMER_CONTACTS(
28 	pco_code	IN VARCHAR2,
29 	psync_all	IN VARCHAR2,
30 	pcustomer_id	IN NUMBER);
31 
32 PROCEDURE DISPLAY_CUSTOMER_DATA(
33 	r			IN OUT	NOCOPY opm_customers%ROWTYPE);
34 
35 PROCEDURE DISPLAY_CONTACT_DATA;
36 
37 PROCEDURE PRINT_LINE(
38 	line_text		IN	VARCHAR2);
39 
40 PROCEDURE PRINT(
41 	line_text		IN	VARCHAR2);
42 
43 PROCEDURE INITIALIZE_LABELS;
44 
45 L_START_PROGRAM	VARCHAR2(2000);
46 L_COMPANY	VARCHAR2(2000);
47 L_CUSTOMER	VARCHAR2(2000);
48 L_SYNCHRONIZE	VARCHAR2(2000);
49 L_FAILURE	VARCHAR2(2000);
50 L_SUCCESS	VARCHAR2(2000);
51 L_INSERT	VARCHAR2(2000);
52 L_UPDATE	VARCHAR2(2000);
53 L_CONTACTS	VARCHAR2(2000);
54 L_RINSERT	VARCHAR2(2000);
55 L_RUPDATE	VARCHAR2(2000);
56 L_TOTAL		VARCHAR2(2000);
57 
58 PROCEDURE HOT_SYNCHRONIZE(
59 	porg_id			IN	NUMBER,
60 	pcustomer_number	IN	VARCHAR2);
61 
62 END;