DBA Data[Home] [Help]

APPS.CSI_T_II_RELATIONSHIPS_PKG dependencies on FND_API

Line 65: If (px_TXN_RELATIONSHIP_ID IS NULL) OR (px_TXN_RELATIONSHIP_ID = FND_API.G_MISS_NUM) then

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;

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

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),

Line 117: decode( p_OBJECT_TYPE, FND_API.G_MISS_CHAR, NULL, p_OBJECT_TYPE),

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),

Line 118: decode( p_OBJECT_ID, FND_API.G_MISS_NUM, NULL, p_OBJECT_ID),

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),

Line 119: decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_RELATIONSHIP_TYPE_CODE),

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),

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

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),

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

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),

Line 122: decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, NULL, p_MANDATORY_FLAG),

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),

Line 123: decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_START_DATE),

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),

Line 124: decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_ACTIVE_END_DATE),

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),

Line 125: decode( p_CSI_INST_RELATIONSHIP_ID, FND_API.G_MISS_NUM, NULL, p_CSI_INST_RELATIONSHIP_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),

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

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),

Line 127: decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, NULL, p_SUBJECT_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),

Line 128: decode( p_SUB_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_SUB_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),

Line 129: decode( p_SUB_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_SUB_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),

Line 130: decode( p_SUB_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_SUB_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),

Line 131: decode( p_OBJ_CONFIG_INST_HDR_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_HDR_ID),

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),

Line 132: decode( p_OBJ_CONFIG_INST_REV_NUM, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_REV_NUM),

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),

Line 133: decode( p_OBJ_CONFIG_INST_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_OBJ_CONFIG_INST_ITEM_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),
137: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

Line 134: decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_TARGET_COMMITMENT_DATE),

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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));

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

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;

Line 155: decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER),

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:

Line 156: decode( p_CONTEXT, FND_API.G_MISS_CHAR, NULL, p_CONTEXT),

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(

Line 157: decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, NULL, p_TRANSFER_COMPONENTS_FLAG));

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,

Line 209: TRANSACTION_LINE_ID = decode( p_TRANSACTION_LINE_ID, FND_API.G_MISS_NUM, TRANSACTION_LINE_ID, p_TRANSACTION_LINE_ID),

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),

Line 210: OBJECT_TYPE = decode( OBJECT_TYPE, FND_API.G_MISS_CHAR, OBJECT_TYPE, p_OBJECT_TYPE) ,

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),

Line 211: OBJECT_ID = decode( p_OBJECT_ID, FND_API.G_MISS_NUM, OBJECT_ID, p_OBJECT_ID),

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),

Line 212: RELATIONSHIP_TYPE_CODE = decode( p_RELATIONSHIP_TYPE_CODE, FND_API.G_MISS_CHAR, RELATIONSHIP_TYPE_CODE, p_RELATIONSHIP_TYPE_CODE),

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),

Line 213: DISPLAY_ORDER = decode( p_DISPLAY_ORDER, FND_API.G_MISS_NUM, DISPLAY_ORDER, p_DISPLAY_ORDER),

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),

Line 214: POSITION_REFERENCE = decode( p_POSITION_REFERENCE, FND_API.G_MISS_CHAR, POSITION_REFERENCE, p_POSITION_REFERENCE),

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),

Line 215: MANDATORY_FLAG = decode( p_MANDATORY_FLAG, FND_API.G_MISS_CHAR, MANDATORY_FLAG, p_MANDATORY_FLAG),

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),

Line 216: ACTIVE_START_DATE = decode( p_ACTIVE_START_DATE, FND_API.G_MISS_DATE, ACTIVE_START_DATE, p_ACTIVE_START_DATE),

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),

Line 217: ACTIVE_END_DATE = decode( p_ACTIVE_END_DATE, FND_API.G_MISS_DATE, ACTIVE_END_DATE, p_ACTIVE_END_DATE),

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),

Line 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),

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),

Line 219: SUBJECT_TYPE = decode( SUBJECT_TYPE, FND_API.G_MISS_CHAR, SUBJECT_TYPE , p_SUBJECT_TYPE),

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),

Line 220: SUBJECT_ID = decode( p_SUBJECT_ID, FND_API.G_MISS_NUM, SUBJECT_ID, p_SUBJECT_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),

Line 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),

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),

Line 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),

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),

Line 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),

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),

Line 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),

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),

Line 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),

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),

Line 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),

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),

Line 227: TARGET_COMMITMENT_DATE = decode( p_TARGET_COMMITMENT_DATE, FND_API.G_MISS_DATE, TARGET_COMMITMENT_DATE, p_TARGET_COMMITMENT_DATE),

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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),

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

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)

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

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;

Line 248: OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER),

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:

Line 249: CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),

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

Line 250: TRANSFER_COMPONENTS_FLAG = decode( p_TRANSFER_COMPONENTS_FLAG, FND_API.G_MISS_CHAR, TRANSFER_COMPONENTS_FLAG, p_TRANSFER_COMPONENTS_FLAG)

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;