APPS.PV_ENTITY_ROUTINGS_PKG dependencies on FND_API

Line 62: If (px_ENTITY_ROUTING_ID IS NULL) OR (px_ENTITY_ROUTING_ID = FND_API.G_MISS_NUM) then

58: )
59: IS
60: CURSOR C2 IS SELECT PV_ENTITY_ROUTINGS_S.nextval FROM sys.dual;
61: BEGIN
62: If (px_ENTITY_ROUTING_ID IS NULL) OR (px_ENTITY_ROUTING_ID = FND_API.G_MISS_NUM) then
63: OPEN C2;
64: FETCH C2 INTO px_ENTITY_ROUTING_ID;
65: CLOSE C2;
66: End If;

Line 109: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)

105: ,ATTRIBUTE14
106: ,ATTRIBUTE15
107: ) VALUES (
108: px_ENTITY_ROUTING_ID
109: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
110: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
111: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
112: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
113: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

Line 110: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)

106: ,ATTRIBUTE15
107: ) VALUES (
108: px_ENTITY_ROUTING_ID
109: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
110: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
111: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
112: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
113: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
114: ,1

Line 111: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)

107: ) VALUES (
108: px_ENTITY_ROUTING_ID
109: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
110: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
111: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
112: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
113: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
114: ,1
115: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)

Line 112: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)

108: px_ENTITY_ROUTING_ID
109: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
110: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
111: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
112: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
113: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
114: ,1
115: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
116: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)

Line 113: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)

109: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
110: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
111: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
112: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
113: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
114: ,1
115: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
116: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
117: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)

Line 115: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)

111: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
112: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
113: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
114: ,1
115: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
116: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
117: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
118: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
119: ,decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_RULE_ID)

Line 116: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)

112: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
113: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
114: ,1
115: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
116: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
117: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
118: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
119: ,decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_RULE_ID)
120: ,decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, NULL, p_DISTANCE_FROM_CUSTOMER)

Line 117: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)

113: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
114: ,1
115: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
116: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
117: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
118: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
119: ,decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_RULE_ID)
120: ,decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, NULL, p_DISTANCE_FROM_CUSTOMER)
121: ,decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_DISTANCE_UOM_CODE)

Line 118: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)

114: ,1
115: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
116: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
117: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
118: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
119: ,decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_RULE_ID)
120: ,decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, NULL, p_DISTANCE_FROM_CUSTOMER)
121: ,decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_DISTANCE_UOM_CODE)
122: ,decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, NULL, p_MAX_NEAREST_PARTNER)

Line 119: ,decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_RULE_ID)

115: ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
116: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
117: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
118: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
119: ,decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_RULE_ID)
120: ,decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, NULL, p_DISTANCE_FROM_CUSTOMER)
121: ,decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_DISTANCE_UOM_CODE)
122: ,decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, NULL, p_MAX_NEAREST_PARTNER)
123: ,decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, NULL, p_ROUTING_TYPE)

Line 120: ,decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, NULL, p_DISTANCE_FROM_CUSTOMER)

116: ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
117: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
118: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
119: ,decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_RULE_ID)
120: ,decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, NULL, p_DISTANCE_FROM_CUSTOMER)
121: ,decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_DISTANCE_UOM_CODE)
122: ,decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, NULL, p_MAX_NEAREST_PARTNER)
123: ,decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, NULL, p_ROUTING_TYPE)
124: ,decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, NULL, p_BYPASS_CM_OK_FLAG)

Line 121: ,decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_DISTANCE_UOM_CODE)

117: ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
118: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
119: ,decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_RULE_ID)
120: ,decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, NULL, p_DISTANCE_FROM_CUSTOMER)
121: ,decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_DISTANCE_UOM_CODE)
122: ,decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, NULL, p_MAX_NEAREST_PARTNER)
123: ,decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, NULL, p_ROUTING_TYPE)
124: ,decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, NULL, p_BYPASS_CM_OK_FLAG)
125: ,decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_CM_TIMEOUT)

Line 122: ,decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, NULL, p_MAX_NEAREST_PARTNER)

118: ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
119: ,decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_RULE_ID)
120: ,decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, NULL, p_DISTANCE_FROM_CUSTOMER)
121: ,decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_DISTANCE_UOM_CODE)
122: ,decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, NULL, p_MAX_NEAREST_PARTNER)
123: ,decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, NULL, p_ROUTING_TYPE)
124: ,decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, NULL, p_BYPASS_CM_OK_FLAG)
125: ,decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_CM_TIMEOUT)
126: ,decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_CM_TIMEOUT_UOM_CODE)

Line 123: ,decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, NULL, p_ROUTING_TYPE)

119: ,decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_RULE_ID)
120: ,decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, NULL, p_DISTANCE_FROM_CUSTOMER)
121: ,decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_DISTANCE_UOM_CODE)
122: ,decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, NULL, p_MAX_NEAREST_PARTNER)
123: ,decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, NULL, p_ROUTING_TYPE)
124: ,decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, NULL, p_BYPASS_CM_OK_FLAG)
125: ,decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_CM_TIMEOUT)
126: ,decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_CM_TIMEOUT_UOM_CODE)
127: ,decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_PARTNER_TIMEOUT)

Line 124: ,decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, NULL, p_BYPASS_CM_OK_FLAG)

120: ,decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, NULL, p_DISTANCE_FROM_CUSTOMER)
121: ,decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_DISTANCE_UOM_CODE)
122: ,decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, NULL, p_MAX_NEAREST_PARTNER)
123: ,decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, NULL, p_ROUTING_TYPE)
124: ,decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, NULL, p_BYPASS_CM_OK_FLAG)
125: ,decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_CM_TIMEOUT)
126: ,decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_CM_TIMEOUT_UOM_CODE)
127: ,decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_PARTNER_TIMEOUT)
128: ,decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PARTNER_TIMEOUT_UOM_CODE)

Line 125: ,decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_CM_TIMEOUT)

121: ,decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_DISTANCE_UOM_CODE)
122: ,decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, NULL, p_MAX_NEAREST_PARTNER)
123: ,decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, NULL, p_ROUTING_TYPE)
124: ,decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, NULL, p_BYPASS_CM_OK_FLAG)
125: ,decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_CM_TIMEOUT)
126: ,decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_CM_TIMEOUT_UOM_CODE)
127: ,decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_PARTNER_TIMEOUT)
128: ,decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PARTNER_TIMEOUT_UOM_CODE)
129: ,decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_UNMATCHED_INT_RESOURCE_ID)

Line 126: ,decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_CM_TIMEOUT_UOM_CODE)

122: ,decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, NULL, p_MAX_NEAREST_PARTNER)
123: ,decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, NULL, p_ROUTING_TYPE)
124: ,decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, NULL, p_BYPASS_CM_OK_FLAG)
125: ,decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_CM_TIMEOUT)
126: ,decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_CM_TIMEOUT_UOM_CODE)
127: ,decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_PARTNER_TIMEOUT)
128: ,decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PARTNER_TIMEOUT_UOM_CODE)
129: ,decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_UNMATCHED_INT_RESOURCE_ID)
130: ,decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, NULL, p_UNMATCHED_CALL_TAP_FLAG)

Line 127: ,decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_PARTNER_TIMEOUT)

123: ,decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, NULL, p_ROUTING_TYPE)
124: ,decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, NULL, p_BYPASS_CM_OK_FLAG)
125: ,decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_CM_TIMEOUT)
126: ,decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_CM_TIMEOUT_UOM_CODE)
127: ,decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_PARTNER_TIMEOUT)
128: ,decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PARTNER_TIMEOUT_UOM_CODE)
129: ,decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_UNMATCHED_INT_RESOURCE_ID)
130: ,decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, NULL, p_UNMATCHED_CALL_TAP_FLAG)
131: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)

Line 128: ,decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PARTNER_TIMEOUT_UOM_CODE)

124: ,decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, NULL, p_BYPASS_CM_OK_FLAG)
125: ,decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_CM_TIMEOUT)
126: ,decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_CM_TIMEOUT_UOM_CODE)
127: ,decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_PARTNER_TIMEOUT)
128: ,decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PARTNER_TIMEOUT_UOM_CODE)
129: ,decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_UNMATCHED_INT_RESOURCE_ID)
130: ,decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, NULL, p_UNMATCHED_CALL_TAP_FLAG)
131: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
132: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)

Line 129: ,decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_UNMATCHED_INT_RESOURCE_ID)

125: ,decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_CM_TIMEOUT)
126: ,decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_CM_TIMEOUT_UOM_CODE)
127: ,decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_PARTNER_TIMEOUT)
128: ,decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PARTNER_TIMEOUT_UOM_CODE)
129: ,decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_UNMATCHED_INT_RESOURCE_ID)
130: ,decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, NULL, p_UNMATCHED_CALL_TAP_FLAG)
131: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
132: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
133: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)

Line 130: ,decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, NULL, p_UNMATCHED_CALL_TAP_FLAG)

126: ,decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_CM_TIMEOUT_UOM_CODE)
127: ,decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_PARTNER_TIMEOUT)
128: ,decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PARTNER_TIMEOUT_UOM_CODE)
129: ,decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_UNMATCHED_INT_RESOURCE_ID)
130: ,decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, NULL, p_UNMATCHED_CALL_TAP_FLAG)
131: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
132: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
133: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
134: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)

Line 131: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)

127: ,decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, NULL, p_PARTNER_TIMEOUT)
128: ,decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PARTNER_TIMEOUT_UOM_CODE)
129: ,decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_UNMATCHED_INT_RESOURCE_ID)
130: ,decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, NULL, p_UNMATCHED_CALL_TAP_FLAG)
131: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
132: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
133: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
134: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
135: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

Line 132: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)

128: ,decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_PARTNER_TIMEOUT_UOM_CODE)
129: ,decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_UNMATCHED_INT_RESOURCE_ID)
130: ,decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, NULL, p_UNMATCHED_CALL_TAP_FLAG)
131: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
132: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
133: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
134: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
135: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
136: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)

Line 133: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)

129: ,decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_UNMATCHED_INT_RESOURCE_ID)
130: ,decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, NULL, p_UNMATCHED_CALL_TAP_FLAG)
131: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
132: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
133: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
134: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
135: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
136: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
137: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)

Line 134: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)

130: ,decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, NULL, p_UNMATCHED_CALL_TAP_FLAG)
131: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
132: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
133: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
134: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
135: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
136: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
137: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
138: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)

Line 135: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)

131: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
132: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
133: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
134: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
135: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
136: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
137: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
138: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
139: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)

Line 136: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)

132: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
133: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
134: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
135: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
136: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
137: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
138: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
139: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
140: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)

Line 137: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)

133: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
134: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
135: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
136: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
137: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
138: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
139: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
140: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
141: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)

Line 138: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)

134: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
135: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
136: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
137: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
138: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
139: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
140: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
141: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
142: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)

Line 139: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)

135: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
136: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
137: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
138: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
139: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
140: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
141: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
142: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
143: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)

Line 140: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)

136: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
137: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
138: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
139: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
140: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
141: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
142: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
143: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
144: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)

Line 141: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)

137: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
138: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
139: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
140: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
141: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
142: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
143: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
144: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
145: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)

Line 142: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)

138: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
139: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
140: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
141: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
142: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
143: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
144: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
145: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
146: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

Line 143: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)

139: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
140: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
141: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
142: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
143: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
144: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
145: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
146: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
147: );

Line 144: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)

140: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
141: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
142: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
143: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
144: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
145: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
146: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
147: );
148: End Insert_Row;

Line 145: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)

141: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
142: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
143: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
144: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
145: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
146: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
147: );
148: End Insert_Row;
149:

Line 146: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

142: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
143: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
144: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
145: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
146: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
147: );
148: End Insert_Row;
149:
150: PROCEDURE Update_Row(

Line 195: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)

191: IS
192: BEGIN
193: Update PV_ENTITY_ROUTINGS
194: SET
195: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
196: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
197: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
198: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
199: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

Line 196: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)

192: BEGIN
193: Update PV_ENTITY_ROUTINGS
194: SET
195: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
196: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
197: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
198: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
199: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
200: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1)

Line 197: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)

193: Update PV_ENTITY_ROUTINGS
194: SET
195: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
196: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
197: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
198: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
199: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
200: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1)
201: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)

Line 198: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)

194: SET
195: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
196: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
197: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
198: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
199: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
200: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1)
201: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
202: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)

Line 199: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)

195: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
196: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
197: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
198: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
199: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
200: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1)
201: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
202: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
203: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)

Line 200: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1)

196: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
197: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
198: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
199: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
200: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1)
201: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
202: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
203: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
204: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)

Line 201: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)

197: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
198: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
199: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
200: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1)
201: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
202: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
203: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
204: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
205: ,PROCESS_RULE_ID = decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, PROCESS_RULE_ID, p_PROCESS_RULE_ID)

Line 202: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)

198: ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
199: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
200: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1)
201: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
202: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
203: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
204: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
205: ,PROCESS_RULE_ID = decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, PROCESS_RULE_ID, p_PROCESS_RULE_ID)
206: ,DISTANCE_FROM_CUSTOMER = decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, DISTANCE_FROM_CUSTOMER, p_DISTANCE_FROM_CUSTOMER)

Line 203: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)

199: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
200: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1)
201: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
202: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
203: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
204: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
205: ,PROCESS_RULE_ID = decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, PROCESS_RULE_ID, p_PROCESS_RULE_ID)
206: ,DISTANCE_FROM_CUSTOMER = decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, DISTANCE_FROM_CUSTOMER, p_DISTANCE_FROM_CUSTOMER)
207: ,DISTANCE_UOM_CODE = decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, DISTANCE_UOM_CODE, p_DISTANCE_UOM_CODE)

Line 204: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)

200: ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER+1)
201: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
202: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
203: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
204: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
205: ,PROCESS_RULE_ID = decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, PROCESS_RULE_ID, p_PROCESS_RULE_ID)
206: ,DISTANCE_FROM_CUSTOMER = decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, DISTANCE_FROM_CUSTOMER, p_DISTANCE_FROM_CUSTOMER)
207: ,DISTANCE_UOM_CODE = decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, DISTANCE_UOM_CODE, p_DISTANCE_UOM_CODE)
208: ,MAX_NEAREST_PARTNER = decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, MAX_NEAREST_PARTNER, p_MAX_NEAREST_PARTNER)

Line 205: ,PROCESS_RULE_ID = decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, PROCESS_RULE_ID, p_PROCESS_RULE_ID)

201: ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
202: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
203: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
204: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
205: ,PROCESS_RULE_ID = decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, PROCESS_RULE_ID, p_PROCESS_RULE_ID)
206: ,DISTANCE_FROM_CUSTOMER = decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, DISTANCE_FROM_CUSTOMER, p_DISTANCE_FROM_CUSTOMER)
207: ,DISTANCE_UOM_CODE = decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, DISTANCE_UOM_CODE, p_DISTANCE_UOM_CODE)
208: ,MAX_NEAREST_PARTNER = decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, MAX_NEAREST_PARTNER, p_MAX_NEAREST_PARTNER)
209: ,ROUTING_TYPE = decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, ROUTING_TYPE, p_ROUTING_TYPE)

Line 206: ,DISTANCE_FROM_CUSTOMER = decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, DISTANCE_FROM_CUSTOMER, p_DISTANCE_FROM_CUSTOMER)

202: ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
203: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
204: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
205: ,PROCESS_RULE_ID = decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, PROCESS_RULE_ID, p_PROCESS_RULE_ID)
206: ,DISTANCE_FROM_CUSTOMER = decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, DISTANCE_FROM_CUSTOMER, p_DISTANCE_FROM_CUSTOMER)
207: ,DISTANCE_UOM_CODE = decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, DISTANCE_UOM_CODE, p_DISTANCE_UOM_CODE)
208: ,MAX_NEAREST_PARTNER = decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, MAX_NEAREST_PARTNER, p_MAX_NEAREST_PARTNER)
209: ,ROUTING_TYPE = decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, ROUTING_TYPE, p_ROUTING_TYPE)
210: ,BYPASS_CM_OK_FLAG = decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, BYPASS_CM_OK_FLAG, p_BYPASS_CM_OK_FLAG)

Line 207: ,DISTANCE_UOM_CODE = decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, DISTANCE_UOM_CODE, p_DISTANCE_UOM_CODE)

203: ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
204: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
205: ,PROCESS_RULE_ID = decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, PROCESS_RULE_ID, p_PROCESS_RULE_ID)
206: ,DISTANCE_FROM_CUSTOMER = decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, DISTANCE_FROM_CUSTOMER, p_DISTANCE_FROM_CUSTOMER)
207: ,DISTANCE_UOM_CODE = decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, DISTANCE_UOM_CODE, p_DISTANCE_UOM_CODE)
208: ,MAX_NEAREST_PARTNER = decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, MAX_NEAREST_PARTNER, p_MAX_NEAREST_PARTNER)
209: ,ROUTING_TYPE = decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, ROUTING_TYPE, p_ROUTING_TYPE)
210: ,BYPASS_CM_OK_FLAG = decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, BYPASS_CM_OK_FLAG, p_BYPASS_CM_OK_FLAG)
211: ,CM_TIMEOUT = decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, CM_TIMEOUT, p_CM_TIMEOUT)

Line 208: ,MAX_NEAREST_PARTNER = decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, MAX_NEAREST_PARTNER, p_MAX_NEAREST_PARTNER)

204: ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
205: ,PROCESS_RULE_ID = decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, PROCESS_RULE_ID, p_PROCESS_RULE_ID)
206: ,DISTANCE_FROM_CUSTOMER = decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, DISTANCE_FROM_CUSTOMER, p_DISTANCE_FROM_CUSTOMER)
207: ,DISTANCE_UOM_CODE = decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, DISTANCE_UOM_CODE, p_DISTANCE_UOM_CODE)
208: ,MAX_NEAREST_PARTNER = decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, MAX_NEAREST_PARTNER, p_MAX_NEAREST_PARTNER)
209: ,ROUTING_TYPE = decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, ROUTING_TYPE, p_ROUTING_TYPE)
210: ,BYPASS_CM_OK_FLAG = decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, BYPASS_CM_OK_FLAG, p_BYPASS_CM_OK_FLAG)
211: ,CM_TIMEOUT = decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, CM_TIMEOUT, p_CM_TIMEOUT)
212: ,CM_TIMEOUT_UOM_CODE = decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, CM_TIMEOUT_UOM_CODE, p_CM_TIMEOUT_UOM_CODE)

Line 209: ,ROUTING_TYPE = decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, ROUTING_TYPE, p_ROUTING_TYPE)

205: ,PROCESS_RULE_ID = decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, PROCESS_RULE_ID, p_PROCESS_RULE_ID)
206: ,DISTANCE_FROM_CUSTOMER = decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, DISTANCE_FROM_CUSTOMER, p_DISTANCE_FROM_CUSTOMER)
207: ,DISTANCE_UOM_CODE = decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, DISTANCE_UOM_CODE, p_DISTANCE_UOM_CODE)
208: ,MAX_NEAREST_PARTNER = decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, MAX_NEAREST_PARTNER, p_MAX_NEAREST_PARTNER)
209: ,ROUTING_TYPE = decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, ROUTING_TYPE, p_ROUTING_TYPE)
210: ,BYPASS_CM_OK_FLAG = decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, BYPASS_CM_OK_FLAG, p_BYPASS_CM_OK_FLAG)
211: ,CM_TIMEOUT = decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, CM_TIMEOUT, p_CM_TIMEOUT)
212: ,CM_TIMEOUT_UOM_CODE = decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, CM_TIMEOUT_UOM_CODE, p_CM_TIMEOUT_UOM_CODE)
213: ,PARTNER_TIMEOUT = decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, PARTNER_TIMEOUT, p_PARTNER_TIMEOUT)

Line 210: ,BYPASS_CM_OK_FLAG = decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, BYPASS_CM_OK_FLAG, p_BYPASS_CM_OK_FLAG)

206: ,DISTANCE_FROM_CUSTOMER = decode( p_DISTANCE_FROM_CUSTOMER, FND_API.G_MISS_NUM, DISTANCE_FROM_CUSTOMER, p_DISTANCE_FROM_CUSTOMER)
207: ,DISTANCE_UOM_CODE = decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, DISTANCE_UOM_CODE, p_DISTANCE_UOM_CODE)
208: ,MAX_NEAREST_PARTNER = decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, MAX_NEAREST_PARTNER, p_MAX_NEAREST_PARTNER)
209: ,ROUTING_TYPE = decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, ROUTING_TYPE, p_ROUTING_TYPE)
210: ,BYPASS_CM_OK_FLAG = decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, BYPASS_CM_OK_FLAG, p_BYPASS_CM_OK_FLAG)
211: ,CM_TIMEOUT = decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, CM_TIMEOUT, p_CM_TIMEOUT)
212: ,CM_TIMEOUT_UOM_CODE = decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, CM_TIMEOUT_UOM_CODE, p_CM_TIMEOUT_UOM_CODE)
213: ,PARTNER_TIMEOUT = decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, PARTNER_TIMEOUT, p_PARTNER_TIMEOUT)
214: ,PARTNER_TIMEOUT_UOM_CODE = decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, PARTNER_TIMEOUT_UOM_CODE, p_PARTNER_TIMEOUT_UOM_CODE)

Line 211: ,CM_TIMEOUT = decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, CM_TIMEOUT, p_CM_TIMEOUT)

207: ,DISTANCE_UOM_CODE = decode( p_DISTANCE_UOM_CODE, FND_API.G_MISS_CHAR, DISTANCE_UOM_CODE, p_DISTANCE_UOM_CODE)
208: ,MAX_NEAREST_PARTNER = decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, MAX_NEAREST_PARTNER, p_MAX_NEAREST_PARTNER)
209: ,ROUTING_TYPE = decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, ROUTING_TYPE, p_ROUTING_TYPE)
210: ,BYPASS_CM_OK_FLAG = decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, BYPASS_CM_OK_FLAG, p_BYPASS_CM_OK_FLAG)
211: ,CM_TIMEOUT = decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, CM_TIMEOUT, p_CM_TIMEOUT)
212: ,CM_TIMEOUT_UOM_CODE = decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, CM_TIMEOUT_UOM_CODE, p_CM_TIMEOUT_UOM_CODE)
213: ,PARTNER_TIMEOUT = decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, PARTNER_TIMEOUT, p_PARTNER_TIMEOUT)
214: ,PARTNER_TIMEOUT_UOM_CODE = decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, PARTNER_TIMEOUT_UOM_CODE, p_PARTNER_TIMEOUT_UOM_CODE)
215: ,UNMATCHED_INT_RESOURCE_ID = decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, UNMATCHED_INT_RESOURCE_ID, p_UNMATCHED_INT_RESOURCE_ID)

Line 212: ,CM_TIMEOUT_UOM_CODE = decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, CM_TIMEOUT_UOM_CODE, p_CM_TIMEOUT_UOM_CODE)

208: ,MAX_NEAREST_PARTNER = decode( p_MAX_NEAREST_PARTNER, FND_API.G_MISS_NUM, MAX_NEAREST_PARTNER, p_MAX_NEAREST_PARTNER)
209: ,ROUTING_TYPE = decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, ROUTING_TYPE, p_ROUTING_TYPE)
210: ,BYPASS_CM_OK_FLAG = decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, BYPASS_CM_OK_FLAG, p_BYPASS_CM_OK_FLAG)
211: ,CM_TIMEOUT = decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, CM_TIMEOUT, p_CM_TIMEOUT)
212: ,CM_TIMEOUT_UOM_CODE = decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, CM_TIMEOUT_UOM_CODE, p_CM_TIMEOUT_UOM_CODE)
213: ,PARTNER_TIMEOUT = decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, PARTNER_TIMEOUT, p_PARTNER_TIMEOUT)
214: ,PARTNER_TIMEOUT_UOM_CODE = decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, PARTNER_TIMEOUT_UOM_CODE, p_PARTNER_TIMEOUT_UOM_CODE)
215: ,UNMATCHED_INT_RESOURCE_ID = decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, UNMATCHED_INT_RESOURCE_ID, p_UNMATCHED_INT_RESOURCE_ID)
216: ,UNMATCHED_CALL_TAP_FLAG = decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, UNMATCHED_CALL_TAP_FLAG, p_UNMATCHED_CALL_TAP_FLAG)

Line 213: ,PARTNER_TIMEOUT = decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, PARTNER_TIMEOUT, p_PARTNER_TIMEOUT)

209: ,ROUTING_TYPE = decode( p_ROUTING_TYPE, FND_API.G_MISS_CHAR, ROUTING_TYPE, p_ROUTING_TYPE)
210: ,BYPASS_CM_OK_FLAG = decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, BYPASS_CM_OK_FLAG, p_BYPASS_CM_OK_FLAG)
211: ,CM_TIMEOUT = decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, CM_TIMEOUT, p_CM_TIMEOUT)
212: ,CM_TIMEOUT_UOM_CODE = decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, CM_TIMEOUT_UOM_CODE, p_CM_TIMEOUT_UOM_CODE)
213: ,PARTNER_TIMEOUT = decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, PARTNER_TIMEOUT, p_PARTNER_TIMEOUT)
214: ,PARTNER_TIMEOUT_UOM_CODE = decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, PARTNER_TIMEOUT_UOM_CODE, p_PARTNER_TIMEOUT_UOM_CODE)
215: ,UNMATCHED_INT_RESOURCE_ID = decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, UNMATCHED_INT_RESOURCE_ID, p_UNMATCHED_INT_RESOURCE_ID)
216: ,UNMATCHED_CALL_TAP_FLAG = decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, UNMATCHED_CALL_TAP_FLAG, p_UNMATCHED_CALL_TAP_FLAG)
217: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)

Line 214: ,PARTNER_TIMEOUT_UOM_CODE = decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, PARTNER_TIMEOUT_UOM_CODE, p_PARTNER_TIMEOUT_UOM_CODE)

210: ,BYPASS_CM_OK_FLAG = decode( p_BYPASS_CM_OK_FLAG, FND_API.G_MISS_CHAR, BYPASS_CM_OK_FLAG, p_BYPASS_CM_OK_FLAG)
211: ,CM_TIMEOUT = decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, CM_TIMEOUT, p_CM_TIMEOUT)
212: ,CM_TIMEOUT_UOM_CODE = decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, CM_TIMEOUT_UOM_CODE, p_CM_TIMEOUT_UOM_CODE)
213: ,PARTNER_TIMEOUT = decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, PARTNER_TIMEOUT, p_PARTNER_TIMEOUT)
214: ,PARTNER_TIMEOUT_UOM_CODE = decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, PARTNER_TIMEOUT_UOM_CODE, p_PARTNER_TIMEOUT_UOM_CODE)
215: ,UNMATCHED_INT_RESOURCE_ID = decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, UNMATCHED_INT_RESOURCE_ID, p_UNMATCHED_INT_RESOURCE_ID)
216: ,UNMATCHED_CALL_TAP_FLAG = decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, UNMATCHED_CALL_TAP_FLAG, p_UNMATCHED_CALL_TAP_FLAG)
217: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
218: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)

Line 215: ,UNMATCHED_INT_RESOURCE_ID = decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, UNMATCHED_INT_RESOURCE_ID, p_UNMATCHED_INT_RESOURCE_ID)

211: ,CM_TIMEOUT = decode( p_CM_TIMEOUT, FND_API.G_MISS_NUM, CM_TIMEOUT, p_CM_TIMEOUT)
212: ,CM_TIMEOUT_UOM_CODE = decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, CM_TIMEOUT_UOM_CODE, p_CM_TIMEOUT_UOM_CODE)
213: ,PARTNER_TIMEOUT = decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, PARTNER_TIMEOUT, p_PARTNER_TIMEOUT)
214: ,PARTNER_TIMEOUT_UOM_CODE = decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, PARTNER_TIMEOUT_UOM_CODE, p_PARTNER_TIMEOUT_UOM_CODE)
215: ,UNMATCHED_INT_RESOURCE_ID = decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, UNMATCHED_INT_RESOURCE_ID, p_UNMATCHED_INT_RESOURCE_ID)
216: ,UNMATCHED_CALL_TAP_FLAG = decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, UNMATCHED_CALL_TAP_FLAG, p_UNMATCHED_CALL_TAP_FLAG)
217: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
218: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
219: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)

Line 216: ,UNMATCHED_CALL_TAP_FLAG = decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, UNMATCHED_CALL_TAP_FLAG, p_UNMATCHED_CALL_TAP_FLAG)

212: ,CM_TIMEOUT_UOM_CODE = decode( p_CM_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, CM_TIMEOUT_UOM_CODE, p_CM_TIMEOUT_UOM_CODE)
213: ,PARTNER_TIMEOUT = decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, PARTNER_TIMEOUT, p_PARTNER_TIMEOUT)
214: ,PARTNER_TIMEOUT_UOM_CODE = decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, PARTNER_TIMEOUT_UOM_CODE, p_PARTNER_TIMEOUT_UOM_CODE)
215: ,UNMATCHED_INT_RESOURCE_ID = decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, UNMATCHED_INT_RESOURCE_ID, p_UNMATCHED_INT_RESOURCE_ID)
216: ,UNMATCHED_CALL_TAP_FLAG = decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, UNMATCHED_CALL_TAP_FLAG, p_UNMATCHED_CALL_TAP_FLAG)
217: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
218: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
219: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
220: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)

Line 217: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)

213: ,PARTNER_TIMEOUT = decode( p_PARTNER_TIMEOUT, FND_API.G_MISS_NUM, PARTNER_TIMEOUT, p_PARTNER_TIMEOUT)
214: ,PARTNER_TIMEOUT_UOM_CODE = decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, PARTNER_TIMEOUT_UOM_CODE, p_PARTNER_TIMEOUT_UOM_CODE)
215: ,UNMATCHED_INT_RESOURCE_ID = decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, UNMATCHED_INT_RESOURCE_ID, p_UNMATCHED_INT_RESOURCE_ID)
216: ,UNMATCHED_CALL_TAP_FLAG = decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, UNMATCHED_CALL_TAP_FLAG, p_UNMATCHED_CALL_TAP_FLAG)
217: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
218: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
219: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
220: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
221: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)

Line 218: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)

214: ,PARTNER_TIMEOUT_UOM_CODE = decode( p_PARTNER_TIMEOUT_UOM_CODE, FND_API.G_MISS_CHAR, PARTNER_TIMEOUT_UOM_CODE, p_PARTNER_TIMEOUT_UOM_CODE)
215: ,UNMATCHED_INT_RESOURCE_ID = decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, UNMATCHED_INT_RESOURCE_ID, p_UNMATCHED_INT_RESOURCE_ID)
216: ,UNMATCHED_CALL_TAP_FLAG = decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, UNMATCHED_CALL_TAP_FLAG, p_UNMATCHED_CALL_TAP_FLAG)
217: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
218: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
219: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
220: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
221: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
222: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)

Line 219: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)

215: ,UNMATCHED_INT_RESOURCE_ID = decode( p_UNMATCHED_INT_RESOURCE_ID, FND_API.G_MISS_NUM, UNMATCHED_INT_RESOURCE_ID, p_UNMATCHED_INT_RESOURCE_ID)
216: ,UNMATCHED_CALL_TAP_FLAG = decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, UNMATCHED_CALL_TAP_FLAG, p_UNMATCHED_CALL_TAP_FLAG)
217: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
218: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
219: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
220: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
221: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
222: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
223: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)

Line 220: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)

216: ,UNMATCHED_CALL_TAP_FLAG = decode( p_UNMATCHED_CALL_TAP_FLAG, FND_API.G_MISS_CHAR, UNMATCHED_CALL_TAP_FLAG, p_UNMATCHED_CALL_TAP_FLAG)
217: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
218: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
219: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
220: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
221: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
222: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
223: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
224: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)

Line 221: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)

217: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
218: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
219: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
220: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
221: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
222: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
223: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
224: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
225: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)

Line 222: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)

218: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
219: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
220: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
221: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
222: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
223: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
224: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
225: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
226: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)

Line 223: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)

219: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
220: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
221: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
222: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
223: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
224: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
225: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
226: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
227: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)

Line 224: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)

220: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
221: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
222: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
223: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
224: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
225: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
226: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
227: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
228: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)

Line 225: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)

221: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
222: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
223: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
224: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
225: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
226: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
227: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
228: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
229: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)

Line 226: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)

222: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
223: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
224: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
225: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
226: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
227: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
228: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
229: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
230: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)

Line 227: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)

223: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
224: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
225: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
226: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
227: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
228: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
229: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
230: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
231: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)

Line 228: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)

224: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
225: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
226: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
227: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
228: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
229: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
230: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
231: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
232: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)

Line 229: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)

225: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
226: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
227: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
228: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
229: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
230: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
231: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
232: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
233: where ENTITY_ROUTING_ID = p_ENTITY_ROUTING_ID;

Line 230: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)

226: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
227: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
228: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
229: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
230: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
231: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
232: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
233: where ENTITY_ROUTING_ID = p_ENTITY_ROUTING_ID;
234:

Line 231: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)

227: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
228: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
229: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
230: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
231: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
232: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
233: where ENTITY_ROUTING_ID = p_ENTITY_ROUTING_ID;
234:
235: If (SQL%NOTFOUND) then

Line 232: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)

228: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
229: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
230: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
231: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
232: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
233: where ENTITY_ROUTING_ID = p_ENTITY_ROUTING_ID;
234:
235: If (SQL%NOTFOUND) then
236: RAISE NO_DATA_FOUND;