1 PACKAGE HZ_IMP_LOAD_RELATIONSHIPS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHLRELS.pls 120.6 2005/10/30 03:53:11 appldev noship $*/
3
4 TYPE RefCurType IS REF CURSOR;
5 TYPE BATCH_ID IS TABLE OF HZ_IMP_RELSHIPS_INT.BATCH_ID%TYPE;
6 TYPE PARTY_ID IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE;
7 TYPE RELATIONSHIP_TYPE IS TABLE OF HZ_IMP_RELSHIPS_INT.RELATIONSHIP_TYPE%TYPE;
8 TYPE COMMENTS IS TABLE OF HZ_IMP_RELSHIPS_INT.COMMENTS%TYPE;
9 TYPE ATTRIBUTE_CATEGORY IS TABLE OF HZ_IMP_RELSHIPS_INT.ATTRIBUTE_CATEGORY%TYPE;
10 TYPE ATTRIBUTE IS TABLE OF HZ_IMP_RELSHIPS_INT.ATTRIBUTE1%TYPE;
11 TYPE RELATIONSHIP_ID IS TABLE OF HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
12 TYPE ROWID IS TABLE OF VARCHAR2(50); --UROWID;
13 TYPE NUMBER_COLUMN IS TABLE OF NUMBER;
14 TYPE FLAG_COLUMN IS TABLE OF VARCHAR2(1);
15
16 /* Validation error columns */
17 TYPE FLAG_ERROR IS TABLE OF VARCHAR2(1);
18
19 PROCEDURE load_relationships (
20 P_DML_RECORD IN HZ_IMP_LOAD_WRAPPER.DML_RECORD_TYPE
21 ,x_return_status OUT NOCOPY VARCHAR2
22 ,x_msg_count OUT NOCOPY NUMBER
23 ,x_msg_data OUT NOCOPY VARCHAR2 );
24
25 FUNCTION validate_desc_flexfield_f(
26 p_attr_category IN VARCHAR2,
27 p_attr1 IN VARCHAR2,
28 p_attr2 IN VARCHAR2,
29 p_attr3 IN VARCHAR2,
30 p_attr4 IN VARCHAR2,
31 p_attr5 IN VARCHAR2,
32 p_attr6 IN VARCHAR2,
33 p_attr7 IN VARCHAR2,
34 p_attr8 IN VARCHAR2,
35 p_attr9 IN VARCHAR2,
36 p_attr10 IN VARCHAR2,
37 p_attr11 IN VARCHAR2,
38 p_attr12 IN VARCHAR2,
39 p_attr13 IN VARCHAR2,
40 p_attr14 IN VARCHAR2,
41 p_attr15 IN VARCHAR2,
42 p_attr16 IN VARCHAR2,
43 p_attr17 IN VARCHAR2,
44 p_attr18 IN VARCHAR2,
45 p_attr19 IN VARCHAR2,
46 p_attr20 IN VARCHAR2,
47 p_validation_date IN DATE
48 ) RETURN VARCHAR2;
49
50 END HZ_IMP_LOAD_RELATIONSHIPS_PKG;