PACKAGE: APPS.HZ_IMP_LOAD_STAGE2

Source

1 PACKAGE HZ_IMP_LOAD_STAGE2 AUTHID CURRENT_USER AS
2 /*$Header: ARHLS2WS.pls 120.8 2005/10/30 03:53:16 appldev noship $*/
3 
4 /*
5   TYPE DML_RECORD_TYPE IS RECORD (
6    BATCH_ID	              NUMBER(15,0),
7    OS	                      VARCHAR2(30),
8    FROM_OSR                   VARCHAR2(240),
9    TO_OSR                     VARCHAR2(240),
10    ACTUAL_CONTENT_SRC         VARCHAR2(30),
11    RERUN                      VARCHAR2(1),
12    ERROR_LIMIT                NUMBER,
13    BATCH_MODE_FLAG            VARCHAR2(1),
14    USER_ID                    NUMBER(15,0),
15    SYS_DATE                   DATE,
16    LAST_UPDATE_LOGIN          NUMBER(15,0),
17    PROGRAM_ID                 NUMBER(15,0),
18    PROGRAM_APPLICATION_ID     NUMBER(15,0),
19    REQUEST_ID                 NUMBER(15,0),
20    APPLICATION_ID             NUMBER,
21    GMISS_CHAR                 VARCHAR2(1),
22    GMISS_NUM                  NUMBER,
23    GMISS_DATE                 DATE,
24    FLEX_VALIDATION            VARCHAR2(1),
25    DSS_SECURITY               VARCHAR2(1),
26    ALLOW_DISABLED_LOOKUP      VARCHAR2(1),
27    PROFILE_VERSION            VARCHAR2(30)
28   );
29 */
30   -- Stage 1 worker process
31   PROCEDURE WORKER_PROCESS(
32     Errbuf                         OUT NOCOPY VARCHAR2,
33     Retcode                        OUT NOCOPY VARCHAR2,
34     P_BATCH_ID                     IN         NUMBER,
35     P_ACTUAL_CONTENT_SRC           IN         VARCHAR2,
36     P_RERUN                        IN         VARCHAR2,
37     P_ERROR_LIMIT                  IN         NUMBER,
38     P_BATCH_MODE_FLAG              IN         VARCHAR2,
39     P_USER_ID                      IN         NUMBER,
40     --bug 3932987
41     --P_SYSDATE                      IN         DATE,
42     P_SYSDATE                      IN         VARCHAR2,
43     P_LAST_UPDATE_LOGIN            IN         NUMBER,
44     P_PROGRAM_ID                   IN         NUMBER,
45     P_PROGRAM_APPLICATION_ID       IN         NUMBER,
46     P_REQUEST_ID                   IN         NUMBER,
47     P_APPLICATION_ID               IN         NUMBER,
48     P_GMISS_CHAR                   IN         VARCHAR2,
49     P_GMISS_NUM	                   IN         NUMBER,
50     P_GMISS_DATE                   IN         DATE,
51     P_FLEX_VALIDATION              IN         VARCHAR2,
52     P_DSS_SECURITY                 IN         VARCHAR2,
53     P_ALLOW_DISABLED_LOOKUP        IN         VARCHAR2,
54     P_PROFILE_VERSION              IN         VARCHAR2,
55     P_WHAT_IF_ANALYSIS             IN         VARCHAR2,
56     P_REGISTRY_DEDUP               IN         VARCHAR2,
57     P_REGISTRY_DEDUP_MATCH_RULE_ID IN         VARCHAR2
58   );
59 
60   PROCEDURE ERROR_LIMIT_HANDLING(
61     P_BATCH_ID                 IN             NUMBER,
62     P_BATCH_MODE_FLAG          IN             VARCHAR2
63   );
64 
65 END HZ_IMP_LOAD_STAGE2;