66: x_error_message OUT NOCOPY VARCHAR2
67: );
68:
69: TYPE INST_INTERFACE_REC_TYPE IS RECORD
70: ( INST_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
71: PROCESS_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR
72: );
73: TYPE INST_INTERFACE_TBL_TYPE is TABLE OF INST_INTERFACE_REC_TYPE INDEX BY BINARY_INTEGER;
74:
67: );
68:
69: TYPE INST_INTERFACE_REC_TYPE IS RECORD
70: ( INST_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
71: PROCESS_STATUS VARCHAR2(1) := FND_API.G_MISS_CHAR
72: );
73: TYPE INST_INTERFACE_TBL_TYPE is TABLE OF INST_INTERFACE_REC_TYPE INDEX BY BINARY_INTEGER;
74:
75: TYPE PARTY_CONTACT_REC_TYPE IS RECORD
72: );
73: TYPE INST_INTERFACE_TBL_TYPE is TABLE OF INST_INTERFACE_REC_TYPE INDEX BY BINARY_INTEGER;
74:
75: TYPE PARTY_CONTACT_REC_TYPE IS RECORD
76: ( IP_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
77: INST_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
78: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
79: CONTACT_PARTY_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: CONTACT_PARTY_NAME VARCHAR2(250) := FND_API.G_MISS_CHAR,
73: TYPE INST_INTERFACE_TBL_TYPE is TABLE OF INST_INTERFACE_REC_TYPE INDEX BY BINARY_INTEGER;
74:
75: TYPE PARTY_CONTACT_REC_TYPE IS RECORD
76: ( IP_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
77: INST_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
78: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
79: CONTACT_PARTY_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: CONTACT_PARTY_NAME VARCHAR2(250) := FND_API.G_MISS_CHAR,
81: CONTACT_PARTY_REL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
74:
75: TYPE PARTY_CONTACT_REC_TYPE IS RECORD
76: ( IP_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
77: INST_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
78: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
79: CONTACT_PARTY_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: CONTACT_PARTY_NAME VARCHAR2(250) := FND_API.G_MISS_CHAR,
81: CONTACT_PARTY_REL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: PARENT_TBL_IDX NUMBER := FND_API.G_MISS_NUM,
75: TYPE PARTY_CONTACT_REC_TYPE IS RECORD
76: ( IP_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
77: INST_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
78: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
79: CONTACT_PARTY_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: CONTACT_PARTY_NAME VARCHAR2(250) := FND_API.G_MISS_CHAR,
81: CONTACT_PARTY_REL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: PARENT_TBL_IDX NUMBER := FND_API.G_MISS_NUM,
83: CONTACT_PARENT_TBL_INDEX NUMBER := FND_API.G_MISS_NUM
76: ( IP_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
77: INST_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
78: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
79: CONTACT_PARTY_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: CONTACT_PARTY_NAME VARCHAR2(250) := FND_API.G_MISS_CHAR,
81: CONTACT_PARTY_REL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: PARENT_TBL_IDX NUMBER := FND_API.G_MISS_NUM,
83: CONTACT_PARENT_TBL_INDEX NUMBER := FND_API.G_MISS_NUM
84: );
77: INST_INTERFACE_ID NUMBER := FND_API.G_MISS_NUM,
78: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
79: CONTACT_PARTY_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: CONTACT_PARTY_NAME VARCHAR2(250) := FND_API.G_MISS_CHAR,
81: CONTACT_PARTY_REL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: PARENT_TBL_IDX NUMBER := FND_API.G_MISS_NUM,
83: CONTACT_PARENT_TBL_INDEX NUMBER := FND_API.G_MISS_NUM
84: );
85: TYPE PARTY_CONTACT_TBL_TYPE is TABLE OF PARTY_CONTACT_REC_TYPE INDEX BY BINARY_INTEGER;
78: CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
79: CONTACT_PARTY_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: CONTACT_PARTY_NAME VARCHAR2(250) := FND_API.G_MISS_CHAR,
81: CONTACT_PARTY_REL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: PARENT_TBL_IDX NUMBER := FND_API.G_MISS_NUM,
83: CONTACT_PARENT_TBL_INDEX NUMBER := FND_API.G_MISS_NUM
84: );
85: TYPE PARTY_CONTACT_TBL_TYPE is TABLE OF PARTY_CONTACT_REC_TYPE INDEX BY BINARY_INTEGER;
86:
79: CONTACT_PARTY_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
80: CONTACT_PARTY_NAME VARCHAR2(250) := FND_API.G_MISS_CHAR,
81: CONTACT_PARTY_REL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: PARENT_TBL_IDX NUMBER := FND_API.G_MISS_NUM,
83: CONTACT_PARENT_TBL_INDEX NUMBER := FND_API.G_MISS_NUM
84: );
85: TYPE PARTY_CONTACT_TBL_TYPE is TABLE OF PARTY_CONTACT_REC_TYPE INDEX BY BINARY_INTEGER;
86:
87: -- The following code is added for OI enhacements