[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;