61:
62: IS
63: CURSOR C2 IS SELECT CSI_T_II_RELATIONSHIPS_S.nextval FROM sys.dual;
64: BEGIN
65: If (px_TXN_RELATIONSHIP_ID IS NULL) OR (px_TXN_RELATIONSHIP_ID = FND_API.G_MISS_NUM) then
66: OPEN C2;
67: FETCH C2 INTO px_TXN_RELATIONSHIP_ID;
68: CLOSE C2;
69: End If;
112: CONTEXT,
113: TRANSFER_COMPONENTS_FLAG
114: ) VALUES (
115: px_TXN_RELATIONSHIP_ID,
116: decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_ID),
117: decode( p_OBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_TYPE),
118: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
119: decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE),
120: decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER),
113: TRANSFER_COMPONENTS_FLAG
114: ) VALUES (
115: px_TXN_RELATIONSHIP_ID,
116: decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_ID),
117: decode( p_OBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_TYPE),
118: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
119: decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE),
120: decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER),
121: decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_POSITION_REFERENCE),
114: ) VALUES (
115: px_TXN_RELATIONSHIP_ID,
116: decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_ID),
117: decode( p_OBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_TYPE),
118: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
119: decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE),
120: decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER),
121: decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_POSITION_REFERENCE),
122: decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANDATORY_FLAG),
115: px_TXN_RELATIONSHIP_ID,
116: decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_ID),
117: decode( p_OBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_TYPE),
118: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
119: decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE),
120: decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER),
121: decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_POSITION_REFERENCE),
122: decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANDATORY_FLAG),
123: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
116: decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_LINE_ID),
117: decode( p_OBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_TYPE),
118: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
119: decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE),
120: decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER),
121: decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_POSITION_REFERENCE),
122: decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANDATORY_FLAG),
123: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
124: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
117: decode( p_OBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_TYPE),
118: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
119: decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE),
120: decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER),
121: decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_POSITION_REFERENCE),
122: decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANDATORY_FLAG),
123: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
124: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
125: decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, p_CSI_INST_RELATIONSHIP_ID),
118: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),
119: decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE),
120: decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER),
121: decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_POSITION_REFERENCE),
122: decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANDATORY_FLAG),
123: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
124: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
125: decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, p_CSI_INST_RELATIONSHIP_ID),
126: decode( p_SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_SUBJECT_TYPE),
119: decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE),
120: decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER),
121: decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_POSITION_REFERENCE),
122: decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANDATORY_FLAG),
123: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
124: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
125: decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, p_CSI_INST_RELATIONSHIP_ID),
126: decode( p_SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_SUBJECT_TYPE),
127: decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, p_SUBJECT_ID),
120: decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, NULL, p_DISPLAY_ORDER),
121: decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_POSITION_REFERENCE),
122: decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANDATORY_FLAG),
123: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
124: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
125: decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, p_CSI_INST_RELATIONSHIP_ID),
126: decode( p_SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_SUBJECT_TYPE),
127: decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, p_SUBJECT_ID),
128: decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_HDR_ID),
121: decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_POSITION_REFERENCE),
122: decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANDATORY_FLAG),
123: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
124: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
125: decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, p_CSI_INST_RELATIONSHIP_ID),
126: decode( p_SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_SUBJECT_TYPE),
127: decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, p_SUBJECT_ID),
128: decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_HDR_ID),
129: decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_REV_NUM),
122: decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANDATORY_FLAG),
123: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
124: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
125: decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, p_CSI_INST_RELATIONSHIP_ID),
126: decode( p_SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_SUBJECT_TYPE),
127: decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, p_SUBJECT_ID),
128: decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_HDR_ID),
129: decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_REV_NUM),
130: decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_ITEM_ID),
123: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),
124: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
125: decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, p_CSI_INST_RELATIONSHIP_ID),
126: decode( p_SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_SUBJECT_TYPE),
127: decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, p_SUBJECT_ID),
128: decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_HDR_ID),
129: decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_REV_NUM),
130: decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_ITEM_ID),
131: decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_HDR_ID),
124: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),
125: decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, p_CSI_INST_RELATIONSHIP_ID),
126: decode( p_SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_SUBJECT_TYPE),
127: decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, p_SUBJECT_ID),
128: decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_HDR_ID),
129: decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_REV_NUM),
130: decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_ITEM_ID),
131: decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_HDR_ID),
132: decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_REV_NUM),
125: decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, p_CSI_INST_RELATIONSHIP_ID),
126: decode( p_SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_SUBJECT_TYPE),
127: decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, p_SUBJECT_ID),
128: decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_HDR_ID),
129: decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_REV_NUM),
130: decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_ITEM_ID),
131: decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_HDR_ID),
132: decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_REV_NUM),
133: decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_ITEM_ID),
126: decode( p_SUBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_SUBJECT_TYPE),
127: decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, p_SUBJECT_ID),
128: decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_HDR_ID),
129: decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_REV_NUM),
130: decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_ITEM_ID),
131: decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_HDR_ID),
132: decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_REV_NUM),
133: decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_ITEM_ID),
134: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
127: decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, p_SUBJECT_ID),
128: decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_HDR_ID),
129: decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_REV_NUM),
130: decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_ITEM_ID),
131: decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_HDR_ID),
132: decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_REV_NUM),
133: decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_ITEM_ID),
134: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
135: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
128: decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_HDR_ID),
129: decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_REV_NUM),
130: decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_ITEM_ID),
131: decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_HDR_ID),
132: decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_REV_NUM),
133: decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_ITEM_ID),
134: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
135: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
136: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
129: decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_REV_NUM),
130: decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_ITEM_ID),
131: decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_HDR_ID),
132: decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_REV_NUM),
133: decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_ITEM_ID),
134: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
135: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
136: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
137: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
130: decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_SUB_CONFIG_INST_ITEM_ID),
131: decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_HDR_ID),
132: decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_REV_NUM),
133: decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_ITEM_ID),
134: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
135: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
136: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
137: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
138: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
131: decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_HDR_ID),
132: decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_REV_NUM),
133: decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_ITEM_ID),
134: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
135: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
136: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
137: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
138: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
139: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
132: decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_REV_NUM),
133: decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_ITEM_ID),
134: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
135: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
136: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
137: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
138: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
139: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
140: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
133: decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_ITEM_ID),
134: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
135: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
136: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
137: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
138: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
139: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
140: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
141: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
134: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),
135: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
136: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
137: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
138: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
139: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
140: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
141: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
142: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
135: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
136: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
137: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
138: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
139: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
140: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
141: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
142: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
143: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
136: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
137: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
138: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
139: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
140: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
141: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
142: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
143: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
144: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
137: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
138: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
139: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
140: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
141: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
142: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
143: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
144: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
145: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
138: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
139: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
140: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
141: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
142: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
143: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
144: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
145: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
146: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
139: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
140: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
141: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
142: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
143: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
144: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
145: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
146: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
147: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
140: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
141: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
142: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
143: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
144: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
145: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
146: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
147: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
148: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
141: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
142: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
143: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
144: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
145: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
146: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
147: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
148: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
149: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
142: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
143: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
144: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
145: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
146: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
147: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
148: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
149: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
150: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
143: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
144: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
145: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
146: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
147: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
148: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
149: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
150: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
151: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
144: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
145: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
146: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
147: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
148: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
149: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
150: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
151: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
152: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
145: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
146: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
147: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
148: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
149: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
150: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
151: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
152: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
153: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
146: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
147: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
148: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
149: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
150: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
151: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
152: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
153: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
154: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
147: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
148: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
149: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
150: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
151: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
152: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
153: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
154: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
155: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
148: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
149: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
150: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
151: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
152: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
153: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
154: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
155: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
156: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
149: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
150: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
151: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
152: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
153: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
154: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
155: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
156: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
157: decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_COMPONENTS_FLAG));
150: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
151: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
152: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
153: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
154: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
155: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
156: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
157: decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_COMPONENTS_FLAG));
158: End Insert_Row;
151: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
152: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
153: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
154: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
155: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
156: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
157: decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_COMPONENTS_FLAG));
158: End Insert_Row;
159:
152: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
153: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
154: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
155: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
156: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
157: decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_COMPONENTS_FLAG));
158: End Insert_Row;
159:
160: PROCEDURE Update_Row(
153: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
154: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
155: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),
156: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),
157: decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_COMPONENTS_FLAG));
158: End Insert_Row;
159:
160: PROCEDURE Update_Row(
161: p_TXN_RELATIONSHIP_ID NUMBER,
205: IS
206: BEGIN
207: Update CSI_T_II_RELATIONSHIPS
208: SET
209: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
210: OBJECT_TYPE = decode( OBJECT_TYPE, FND_API.G_MISS_CHAR, OBJECT_TYPE, p_OBJECT_TYPE) ,
211: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
212: RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),
213: DISPLAY_ORDER = decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER),
206: BEGIN
207: Update CSI_T_II_RELATIONSHIPS
208: SET
209: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
210: OBJECT_TYPE = decode( OBJECT_TYPE, FND_API.G_MISS_CHAR, OBJECT_TYPE, p_OBJECT_TYPE) ,
211: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
212: RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),
213: DISPLAY_ORDER = decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER),
214: POSITION_REFERENCE = decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, POSITION_REFERENCE, p_POSITION_REFERENCE),
207: Update CSI_T_II_RELATIONSHIPS
208: SET
209: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
210: OBJECT_TYPE = decode( OBJECT_TYPE, FND_API.G_MISS_CHAR, OBJECT_TYPE, p_OBJECT_TYPE) ,
211: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
212: RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),
213: DISPLAY_ORDER = decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER),
214: POSITION_REFERENCE = decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, POSITION_REFERENCE, p_POSITION_REFERENCE),
215: MANDATORY_FLAG = decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, MANDATORY_FLAG, p_MANDATORY_FLAG),
208: SET
209: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
210: OBJECT_TYPE = decode( OBJECT_TYPE, FND_API.G_MISS_CHAR, OBJECT_TYPE, p_OBJECT_TYPE) ,
211: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
212: RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),
213: DISPLAY_ORDER = decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER),
214: POSITION_REFERENCE = decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, POSITION_REFERENCE, p_POSITION_REFERENCE),
215: MANDATORY_FLAG = decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, MANDATORY_FLAG, p_MANDATORY_FLAG),
216: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
209: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),
210: OBJECT_TYPE = decode( OBJECT_TYPE, FND_API.G_MISS_CHAR, OBJECT_TYPE, p_OBJECT_TYPE) ,
211: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
212: RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),
213: DISPLAY_ORDER = decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER),
214: POSITION_REFERENCE = decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, POSITION_REFERENCE, p_POSITION_REFERENCE),
215: MANDATORY_FLAG = decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, MANDATORY_FLAG, p_MANDATORY_FLAG),
216: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
217: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
210: OBJECT_TYPE = decode( OBJECT_TYPE, FND_API.G_MISS_CHAR, OBJECT_TYPE, p_OBJECT_TYPE) ,
211: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
212: RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),
213: DISPLAY_ORDER = decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER),
214: POSITION_REFERENCE = decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, POSITION_REFERENCE, p_POSITION_REFERENCE),
215: MANDATORY_FLAG = decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, MANDATORY_FLAG, p_MANDATORY_FLAG),
216: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
217: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
218: CSI_INST_RELATIONSHIP_ID = decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, CSI_INST_RELATIONSHIP_ID, p_CSI_INST_RELATIONSHIP_ID),
211: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),
212: RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),
213: DISPLAY_ORDER = decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER),
214: POSITION_REFERENCE = decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, POSITION_REFERENCE, p_POSITION_REFERENCE),
215: MANDATORY_FLAG = decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, MANDATORY_FLAG, p_MANDATORY_FLAG),
216: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
217: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
218: CSI_INST_RELATIONSHIP_ID = decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, CSI_INST_RELATIONSHIP_ID, p_CSI_INST_RELATIONSHIP_ID),
219: SUBJECT_TYPE = decode( SUBJECT_TYPE, FND_API.G_MISS_CHAR, SUBJECT_TYPE , p_SUBJECT_TYPE),
212: RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),
213: DISPLAY_ORDER = decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER),
214: POSITION_REFERENCE = decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, POSITION_REFERENCE, p_POSITION_REFERENCE),
215: MANDATORY_FLAG = decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, MANDATORY_FLAG, p_MANDATORY_FLAG),
216: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
217: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
218: CSI_INST_RELATIONSHIP_ID = decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, CSI_INST_RELATIONSHIP_ID, p_CSI_INST_RELATIONSHIP_ID),
219: SUBJECT_TYPE = decode( SUBJECT_TYPE, FND_API.G_MISS_CHAR, SUBJECT_TYPE , p_SUBJECT_TYPE),
220: SUBJECT_ID = decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, SUBJECT_ID, p_SUBJECT_ID),
213: DISPLAY_ORDER = decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER),
214: POSITION_REFERENCE = decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, POSITION_REFERENCE, p_POSITION_REFERENCE),
215: MANDATORY_FLAG = decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, MANDATORY_FLAG, p_MANDATORY_FLAG),
216: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
217: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
218: CSI_INST_RELATIONSHIP_ID = decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, CSI_INST_RELATIONSHIP_ID, p_CSI_INST_RELATIONSHIP_ID),
219: SUBJECT_TYPE = decode( SUBJECT_TYPE, FND_API.G_MISS_CHAR, SUBJECT_TYPE , p_SUBJECT_TYPE),
220: SUBJECT_ID = decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, SUBJECT_ID, p_SUBJECT_ID),
221: SUB_CONFIG_INST_HDR_ID = decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_HDR_ID, p_SUB_CONFIG_INST_HDR_ID),
214: POSITION_REFERENCE = decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, POSITION_REFERENCE, p_POSITION_REFERENCE),
215: MANDATORY_FLAG = decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, MANDATORY_FLAG, p_MANDATORY_FLAG),
216: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
217: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
218: CSI_INST_RELATIONSHIP_ID = decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, CSI_INST_RELATIONSHIP_ID, p_CSI_INST_RELATIONSHIP_ID),
219: SUBJECT_TYPE = decode( SUBJECT_TYPE, FND_API.G_MISS_CHAR, SUBJECT_TYPE , p_SUBJECT_TYPE),
220: SUBJECT_ID = decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, SUBJECT_ID, p_SUBJECT_ID),
221: SUB_CONFIG_INST_HDR_ID = decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_HDR_ID, p_SUB_CONFIG_INST_HDR_ID),
222: SUB_CONFIG_INST_REV_NUM = decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, SUB_CONFIG_INST_REV_NUM, p_SUB_CONFIG_INST_REV_NUM),
215: MANDATORY_FLAG = decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, MANDATORY_FLAG, p_MANDATORY_FLAG),
216: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
217: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
218: CSI_INST_RELATIONSHIP_ID = decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, CSI_INST_RELATIONSHIP_ID, p_CSI_INST_RELATIONSHIP_ID),
219: SUBJECT_TYPE = decode( SUBJECT_TYPE, FND_API.G_MISS_CHAR, SUBJECT_TYPE , p_SUBJECT_TYPE),
220: SUBJECT_ID = decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, SUBJECT_ID, p_SUBJECT_ID),
221: SUB_CONFIG_INST_HDR_ID = decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_HDR_ID, p_SUB_CONFIG_INST_HDR_ID),
222: SUB_CONFIG_INST_REV_NUM = decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, SUB_CONFIG_INST_REV_NUM, p_SUB_CONFIG_INST_REV_NUM),
223: SUB_CONFIG_INST_ITEM_ID = decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_ITEM_ID, p_SUB_CONFIG_INST_ITEM_ID),
216: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),
217: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
218: CSI_INST_RELATIONSHIP_ID = decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, CSI_INST_RELATIONSHIP_ID, p_CSI_INST_RELATIONSHIP_ID),
219: SUBJECT_TYPE = decode( SUBJECT_TYPE, FND_API.G_MISS_CHAR, SUBJECT_TYPE , p_SUBJECT_TYPE),
220: SUBJECT_ID = decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, SUBJECT_ID, p_SUBJECT_ID),
221: SUB_CONFIG_INST_HDR_ID = decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_HDR_ID, p_SUB_CONFIG_INST_HDR_ID),
222: SUB_CONFIG_INST_REV_NUM = decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, SUB_CONFIG_INST_REV_NUM, p_SUB_CONFIG_INST_REV_NUM),
223: SUB_CONFIG_INST_ITEM_ID = decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_ITEM_ID, p_SUB_CONFIG_INST_ITEM_ID),
224: OBJ_CONFIG_INST_HDR_ID = decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_HDR_ID, p_OBJ_CONFIG_INST_HDR_ID),
217: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),
218: CSI_INST_RELATIONSHIP_ID = decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, CSI_INST_RELATIONSHIP_ID, p_CSI_INST_RELATIONSHIP_ID),
219: SUBJECT_TYPE = decode( SUBJECT_TYPE, FND_API.G_MISS_CHAR, SUBJECT_TYPE , p_SUBJECT_TYPE),
220: SUBJECT_ID = decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, SUBJECT_ID, p_SUBJECT_ID),
221: SUB_CONFIG_INST_HDR_ID = decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_HDR_ID, p_SUB_CONFIG_INST_HDR_ID),
222: SUB_CONFIG_INST_REV_NUM = decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, SUB_CONFIG_INST_REV_NUM, p_SUB_CONFIG_INST_REV_NUM),
223: SUB_CONFIG_INST_ITEM_ID = decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_ITEM_ID, p_SUB_CONFIG_INST_ITEM_ID),
224: OBJ_CONFIG_INST_HDR_ID = decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_HDR_ID, p_OBJ_CONFIG_INST_HDR_ID),
225: OBJ_CONFIG_INST_REV_NUM = decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_REV_NUM, p_OBJ_CONFIG_INST_REV_NUM),
218: CSI_INST_RELATIONSHIP_ID = decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, CSI_INST_RELATIONSHIP_ID, p_CSI_INST_RELATIONSHIP_ID),
219: SUBJECT_TYPE = decode( SUBJECT_TYPE, FND_API.G_MISS_CHAR, SUBJECT_TYPE , p_SUBJECT_TYPE),
220: SUBJECT_ID = decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, SUBJECT_ID, p_SUBJECT_ID),
221: SUB_CONFIG_INST_HDR_ID = decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_HDR_ID, p_SUB_CONFIG_INST_HDR_ID),
222: SUB_CONFIG_INST_REV_NUM = decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, SUB_CONFIG_INST_REV_NUM, p_SUB_CONFIG_INST_REV_NUM),
223: SUB_CONFIG_INST_ITEM_ID = decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_ITEM_ID, p_SUB_CONFIG_INST_ITEM_ID),
224: OBJ_CONFIG_INST_HDR_ID = decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_HDR_ID, p_OBJ_CONFIG_INST_HDR_ID),
225: OBJ_CONFIG_INST_REV_NUM = decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_REV_NUM, p_OBJ_CONFIG_INST_REV_NUM),
226: OBJ_CONFIG_INST_ITEM_ID = decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_ITEM_ID, p_OBJ_CONFIG_INST_ITEM_ID),
219: SUBJECT_TYPE = decode( SUBJECT_TYPE, FND_API.G_MISS_CHAR, SUBJECT_TYPE , p_SUBJECT_TYPE),
220: SUBJECT_ID = decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, SUBJECT_ID, p_SUBJECT_ID),
221: SUB_CONFIG_INST_HDR_ID = decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_HDR_ID, p_SUB_CONFIG_INST_HDR_ID),
222: SUB_CONFIG_INST_REV_NUM = decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, SUB_CONFIG_INST_REV_NUM, p_SUB_CONFIG_INST_REV_NUM),
223: SUB_CONFIG_INST_ITEM_ID = decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_ITEM_ID, p_SUB_CONFIG_INST_ITEM_ID),
224: OBJ_CONFIG_INST_HDR_ID = decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_HDR_ID, p_OBJ_CONFIG_INST_HDR_ID),
225: OBJ_CONFIG_INST_REV_NUM = decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_REV_NUM, p_OBJ_CONFIG_INST_REV_NUM),
226: OBJ_CONFIG_INST_ITEM_ID = decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_ITEM_ID, p_OBJ_CONFIG_INST_ITEM_ID),
227: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE, p_TARGET_COMMITMENT_DATE),
220: SUBJECT_ID = decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, SUBJECT_ID, p_SUBJECT_ID),
221: SUB_CONFIG_INST_HDR_ID = decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_HDR_ID, p_SUB_CONFIG_INST_HDR_ID),
222: SUB_CONFIG_INST_REV_NUM = decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, SUB_CONFIG_INST_REV_NUM, p_SUB_CONFIG_INST_REV_NUM),
223: SUB_CONFIG_INST_ITEM_ID = decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_ITEM_ID, p_SUB_CONFIG_INST_ITEM_ID),
224: OBJ_CONFIG_INST_HDR_ID = decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_HDR_ID, p_OBJ_CONFIG_INST_HDR_ID),
225: OBJ_CONFIG_INST_REV_NUM = decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_REV_NUM, p_OBJ_CONFIG_INST_REV_NUM),
226: OBJ_CONFIG_INST_ITEM_ID = decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_ITEM_ID, p_OBJ_CONFIG_INST_ITEM_ID),
227: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE, p_TARGET_COMMITMENT_DATE),
228: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
221: SUB_CONFIG_INST_HDR_ID = decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_HDR_ID, p_SUB_CONFIG_INST_HDR_ID),
222: SUB_CONFIG_INST_REV_NUM = decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, SUB_CONFIG_INST_REV_NUM, p_SUB_CONFIG_INST_REV_NUM),
223: SUB_CONFIG_INST_ITEM_ID = decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_ITEM_ID, p_SUB_CONFIG_INST_ITEM_ID),
224: OBJ_CONFIG_INST_HDR_ID = decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_HDR_ID, p_OBJ_CONFIG_INST_HDR_ID),
225: OBJ_CONFIG_INST_REV_NUM = decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_REV_NUM, p_OBJ_CONFIG_INST_REV_NUM),
226: OBJ_CONFIG_INST_ITEM_ID = decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_ITEM_ID, p_OBJ_CONFIG_INST_ITEM_ID),
227: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE, p_TARGET_COMMITMENT_DATE),
228: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
229: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
222: SUB_CONFIG_INST_REV_NUM = decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, SUB_CONFIG_INST_REV_NUM, p_SUB_CONFIG_INST_REV_NUM),
223: SUB_CONFIG_INST_ITEM_ID = decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_ITEM_ID, p_SUB_CONFIG_INST_ITEM_ID),
224: OBJ_CONFIG_INST_HDR_ID = decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_HDR_ID, p_OBJ_CONFIG_INST_HDR_ID),
225: OBJ_CONFIG_INST_REV_NUM = decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_REV_NUM, p_OBJ_CONFIG_INST_REV_NUM),
226: OBJ_CONFIG_INST_ITEM_ID = decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_ITEM_ID, p_OBJ_CONFIG_INST_ITEM_ID),
227: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE, p_TARGET_COMMITMENT_DATE),
228: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
229: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
230: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
223: SUB_CONFIG_INST_ITEM_ID = decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, SUB_CONFIG_INST_ITEM_ID, p_SUB_CONFIG_INST_ITEM_ID),
224: OBJ_CONFIG_INST_HDR_ID = decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_HDR_ID, p_OBJ_CONFIG_INST_HDR_ID),
225: OBJ_CONFIG_INST_REV_NUM = decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_REV_NUM, p_OBJ_CONFIG_INST_REV_NUM),
226: OBJ_CONFIG_INST_ITEM_ID = decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_ITEM_ID, p_OBJ_CONFIG_INST_ITEM_ID),
227: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE, p_TARGET_COMMITMENT_DATE),
228: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
229: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
230: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
231: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
224: OBJ_CONFIG_INST_HDR_ID = decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_HDR_ID, p_OBJ_CONFIG_INST_HDR_ID),
225: OBJ_CONFIG_INST_REV_NUM = decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_REV_NUM, p_OBJ_CONFIG_INST_REV_NUM),
226: OBJ_CONFIG_INST_ITEM_ID = decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_ITEM_ID, p_OBJ_CONFIG_INST_ITEM_ID),
227: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE, p_TARGET_COMMITMENT_DATE),
228: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
229: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
230: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
231: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
232: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
225: OBJ_CONFIG_INST_REV_NUM = decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_REV_NUM, p_OBJ_CONFIG_INST_REV_NUM),
226: OBJ_CONFIG_INST_ITEM_ID = decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_ITEM_ID, p_OBJ_CONFIG_INST_ITEM_ID),
227: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE, p_TARGET_COMMITMENT_DATE),
228: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
229: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
230: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
231: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
232: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
233: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
226: OBJ_CONFIG_INST_ITEM_ID = decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, OBJ_CONFIG_INST_ITEM_ID, p_OBJ_CONFIG_INST_ITEM_ID),
227: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE, p_TARGET_COMMITMENT_DATE),
228: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
229: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
230: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
231: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
232: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
233: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
234: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
227: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE, p_TARGET_COMMITMENT_DATE),
228: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
229: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
230: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
231: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
232: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
233: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
234: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
235: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
228: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
229: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
230: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
231: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
232: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
233: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
234: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
235: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
236: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
229: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
230: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
231: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
232: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
233: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
234: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
235: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
236: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
237: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
230: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
231: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
232: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
233: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
234: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
235: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
236: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
237: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
238: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
231: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
232: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
233: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
234: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
235: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
236: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
237: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
238: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
239: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
232: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
233: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
234: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
235: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
236: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
237: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
238: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
239: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
240: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
233: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
234: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
235: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
236: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
237: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
238: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
239: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
240: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
241: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
234: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
235: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
236: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
237: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
238: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
239: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
240: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
241: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
242: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
235: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
236: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
237: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
238: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
239: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
240: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
241: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
242: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
243: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
236: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
237: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
238: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
239: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
240: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
241: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
242: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
243: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
244: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
237: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
238: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
239: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
240: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
241: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
242: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
243: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
244: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
245: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
238: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
239: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
240: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
241: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
242: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
243: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
244: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
245: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
239: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
240: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
241: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
242: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
243: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
244: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
245: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
247: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
240: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
241: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
242: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
243: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
244: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
245: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
247: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
248: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
241: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
242: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
243: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
244: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
245: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
247: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
248: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
249: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
242: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
243: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
244: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
245: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
247: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
248: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
249: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
250: TRANSFER_COMPONENTS_FLAG = decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, TRANSFER_COMPONENTS_FLAG, p_TRANSFER_COMPONENTS_FLAG)
243: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
244: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
245: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
247: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
248: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
249: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
250: TRANSFER_COMPONENTS_FLAG = decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, TRANSFER_COMPONENTS_FLAG, p_TRANSFER_COMPONENTS_FLAG)
251: where TXN_RELATIONSHIP_ID = p_TXN_RELATIONSHIP_ID;
244: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
245: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
247: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
248: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
249: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
250: TRANSFER_COMPONENTS_FLAG = decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, TRANSFER_COMPONENTS_FLAG, p_TRANSFER_COMPONENTS_FLAG)
251: where TXN_RELATIONSHIP_ID = p_TXN_RELATIONSHIP_ID;
252:
245: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
246: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
247: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
248: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
249: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
250: TRANSFER_COMPONENTS_FLAG = decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, TRANSFER_COMPONENTS_FLAG, p_TRANSFER_COMPONENTS_FLAG)
251: where TXN_RELATIONSHIP_ID = p_TXN_RELATIONSHIP_ID;
252:
253: If (SQL%NOTFOUND) then
246: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
247: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
248: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),
249: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
250: TRANSFER_COMPONENTS_FLAG = decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, TRANSFER_COMPONENTS_FLAG, p_TRANSFER_COMPONENTS_FLAG)
251: where TXN_RELATIONSHIP_ID = p_TXN_RELATIONSHIP_ID;
252:
253: If (SQL%NOTFOUND) then
254: RAISE NO_DATA_FOUND;