APPS.CSI_II_RELATIONSHIPS_PKG dependencies on FND_API

Line 50: IF (px_relationship_id IS NULL) OR (px_relationship_id = fnd_api.g_miss_num) THEN

46:
47: IS
48: CURSOR c2 IS SELECT csi_ii_relationships_s.NEXTVAL FROM sys.dual;
49: BEGIN
50: IF (px_relationship_id IS NULL) OR (px_relationship_id = fnd_api.g_miss_num) THEN
51: OPEN c2;
52: FETCH c2 INTO px_relationship_id;
53: CLOSE c2;
54: END IF;

Line 90: decode( p_relationship_type_code, fnd_api.g_miss_char, NULL, p_relationship_type_code),

86: last_update_login,
87: object_version_number
88: ) VALUES (
89: px_relationship_id,
90: decode( p_relationship_type_code, fnd_api.g_miss_char, NULL, p_relationship_type_code),
91: decode( p_object_id, fnd_api.g_miss_num, NULL, p_object_id),
92: decode( p_subject_id, fnd_api.g_miss_num, NULL, p_subject_id),
93: decode( p_position_reference, fnd_api.g_miss_char, NULL, p_position_reference),
94: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),

Line 91: decode( p_object_id, fnd_api.g_miss_num, NULL, p_object_id),

87: object_version_number
88: ) VALUES (
89: px_relationship_id,
90: decode( p_relationship_type_code, fnd_api.g_miss_char, NULL, p_relationship_type_code),
91: decode( p_object_id, fnd_api.g_miss_num, NULL, p_object_id),
92: decode( p_subject_id, fnd_api.g_miss_num, NULL, p_subject_id),
93: decode( p_position_reference, fnd_api.g_miss_char, NULL, p_position_reference),
94: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
95: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),

Line 92: decode( p_subject_id, fnd_api.g_miss_num, NULL, p_subject_id),

88: ) VALUES (
89: px_relationship_id,
90: decode( p_relationship_type_code, fnd_api.g_miss_char, NULL, p_relationship_type_code),
91: decode( p_object_id, fnd_api.g_miss_num, NULL, p_object_id),
92: decode( p_subject_id, fnd_api.g_miss_num, NULL, p_subject_id),
93: decode( p_position_reference, fnd_api.g_miss_char, NULL, p_position_reference),
94: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
95: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
96: decode( p_display_order, fnd_api.g_miss_num, NULL, p_display_order),

Line 93: decode( p_position_reference, fnd_api.g_miss_char, NULL, p_position_reference),

89: px_relationship_id,
90: decode( p_relationship_type_code, fnd_api.g_miss_char, NULL, p_relationship_type_code),
91: decode( p_object_id, fnd_api.g_miss_num, NULL, p_object_id),
92: decode( p_subject_id, fnd_api.g_miss_num, NULL, p_subject_id),
93: decode( p_position_reference, fnd_api.g_miss_char, NULL, p_position_reference),
94: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
95: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
96: decode( p_display_order, fnd_api.g_miss_num, NULL, p_display_order),
97: decode( p_mandatory_flag, fnd_api.g_miss_char, NULL, p_mandatory_flag),

Line 94: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),

90: decode( p_relationship_type_code, fnd_api.g_miss_char, NULL, p_relationship_type_code),
91: decode( p_object_id, fnd_api.g_miss_num, NULL, p_object_id),
92: decode( p_subject_id, fnd_api.g_miss_num, NULL, p_subject_id),
93: decode( p_position_reference, fnd_api.g_miss_char, NULL, p_position_reference),
94: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
95: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
96: decode( p_display_order, fnd_api.g_miss_num, NULL, p_display_order),
97: decode( p_mandatory_flag, fnd_api.g_miss_char, NULL, p_mandatory_flag),
98: decode( p_context, fnd_api.g_miss_char, NULL, p_context),

Line 95: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),

91: decode( p_object_id, fnd_api.g_miss_num, NULL, p_object_id),
92: decode( p_subject_id, fnd_api.g_miss_num, NULL, p_subject_id),
93: decode( p_position_reference, fnd_api.g_miss_char, NULL, p_position_reference),
94: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
95: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
96: decode( p_display_order, fnd_api.g_miss_num, NULL, p_display_order),
97: decode( p_mandatory_flag, fnd_api.g_miss_char, NULL, p_mandatory_flag),
98: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
99: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),

Line 96: decode( p_display_order, fnd_api.g_miss_num, NULL, p_display_order),

92: decode( p_subject_id, fnd_api.g_miss_num, NULL, p_subject_id),
93: decode( p_position_reference, fnd_api.g_miss_char, NULL, p_position_reference),
94: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
95: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
96: decode( p_display_order, fnd_api.g_miss_num, NULL, p_display_order),
97: decode( p_mandatory_flag, fnd_api.g_miss_char, NULL, p_mandatory_flag),
98: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
99: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
100: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),

Line 97: decode( p_mandatory_flag, fnd_api.g_miss_char, NULL, p_mandatory_flag),

93: decode( p_position_reference, fnd_api.g_miss_char, NULL, p_position_reference),
94: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
95: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
96: decode( p_display_order, fnd_api.g_miss_num, NULL, p_display_order),
97: decode( p_mandatory_flag, fnd_api.g_miss_char, NULL, p_mandatory_flag),
98: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
99: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
100: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
101: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),

Line 98: decode( p_context, fnd_api.g_miss_char, NULL, p_context),

94: decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
95: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
96: decode( p_display_order, fnd_api.g_miss_num, NULL, p_display_order),
97: decode( p_mandatory_flag, fnd_api.g_miss_char, NULL, p_mandatory_flag),
98: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
99: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
100: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
101: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
102: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),

Line 99: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),

95: decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
96: decode( p_display_order, fnd_api.g_miss_num, NULL, p_display_order),
97: decode( p_mandatory_flag, fnd_api.g_miss_char, NULL, p_mandatory_flag),
98: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
99: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
100: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
101: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
102: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
103: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),

Line 100: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),

96: decode( p_display_order, fnd_api.g_miss_num, NULL, p_display_order),
97: decode( p_mandatory_flag, fnd_api.g_miss_char, NULL, p_mandatory_flag),
98: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
99: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
100: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
101: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
102: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
103: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
104: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),

Line 101: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),

97: decode( p_mandatory_flag, fnd_api.g_miss_char, NULL, p_mandatory_flag),
98: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
99: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
100: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
101: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
102: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
103: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
104: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
105: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),

Line 102: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),

98: decode( p_context, fnd_api.g_miss_char, NULL, p_context),
99: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
100: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
101: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
102: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
103: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
104: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
105: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
106: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),

Line 103: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),

99: decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
100: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
101: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
102: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
103: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
104: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
105: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
106: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
107: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),

Line 104: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),

100: decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
101: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
102: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
103: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
104: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
105: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
106: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
107: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
108: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),

Line 105: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),

101: decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
102: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
103: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
104: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
105: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
106: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
107: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
108: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
109: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),

Line 106: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),

102: decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
103: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
104: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
105: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
106: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
107: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
108: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
109: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
110: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),

Line 107: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),

103: decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
104: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
105: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
106: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
107: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
108: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
109: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
110: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
111: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),

Line 108: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),

104: decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
105: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
106: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
107: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
108: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
109: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
110: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
111: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
112: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),

Line 109: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),

105: decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
106: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
107: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
108: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
109: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
110: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
111: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
112: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
113: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),

Line 110: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),

106: decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
107: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
108: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
109: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
110: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
111: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
112: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
113: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
114: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

Line 111: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),

107: decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
108: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
109: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
110: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
111: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
112: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
113: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
114: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
115: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

Line 112: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),

108: decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
109: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
110: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
111: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
112: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
113: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
114: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
115: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
116: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

Line 113: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),

109: decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
110: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
111: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
112: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
113: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
114: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
115: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
116: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
117: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

Line 114: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

110: decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
111: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
112: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
113: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
114: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
115: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
116: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
117: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
118: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

Line 115: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

111: decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
112: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
113: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
114: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
115: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
116: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
117: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
118: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
119: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));

Line 116: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

112: decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
113: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
114: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
115: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
116: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
117: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
118: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
119: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
120: --px_relationship_id:=NULL;

Line 117: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

113: decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
114: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
115: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
116: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
117: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
118: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
119: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
120: --px_relationship_id:=NULL;
121: --dbms_output.put_line('after insert');

Line 118: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

114: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
115: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
116: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
117: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
118: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
119: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
120: --px_relationship_id:=NULL;
121: --dbms_output.put_line('after insert');
122: --commit;

Line 119: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));

115: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
116: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
117: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
118: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
119: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));
120: --px_relationship_id:=NULL;
121: --dbms_output.put_line('after insert');
122: --commit;
123: END insert_row;

Line 162: relationship_type_code = decode( p_relationship_type_code, fnd_api.g_miss_char, relationship_type_code, p_relationship_type_code),

158: IS
159: BEGIN
160: update csi_ii_relationships
161: set
162: relationship_type_code = decode( p_relationship_type_code, fnd_api.g_miss_char, relationship_type_code, p_relationship_type_code),
163: object_id = decode( p_object_id, fnd_api.g_miss_num, object_id, p_object_id),
164: subject_id = decode( p_subject_id, fnd_api.g_miss_num, subject_id, p_subject_id),
165: position_reference = decode( p_position_reference, fnd_api.g_miss_char, position_reference, p_position_reference),
166: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),

Line 163: object_id = decode( p_object_id, fnd_api.g_miss_num, object_id, p_object_id),

159: BEGIN
160: update csi_ii_relationships
161: set
162: relationship_type_code = decode( p_relationship_type_code, fnd_api.g_miss_char, relationship_type_code, p_relationship_type_code),
163: object_id = decode( p_object_id, fnd_api.g_miss_num, object_id, p_object_id),
164: subject_id = decode( p_subject_id, fnd_api.g_miss_num, subject_id, p_subject_id),
165: position_reference = decode( p_position_reference, fnd_api.g_miss_char, position_reference, p_position_reference),
166: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
167: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),

Line 164: subject_id = decode( p_subject_id, fnd_api.g_miss_num, subject_id, p_subject_id),

160: update csi_ii_relationships
161: set
162: relationship_type_code = decode( p_relationship_type_code, fnd_api.g_miss_char, relationship_type_code, p_relationship_type_code),
163: object_id = decode( p_object_id, fnd_api.g_miss_num, object_id, p_object_id),
164: subject_id = decode( p_subject_id, fnd_api.g_miss_num, subject_id, p_subject_id),
165: position_reference = decode( p_position_reference, fnd_api.g_miss_char, position_reference, p_position_reference),
166: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
167: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
168: display_order = decode( p_display_order, fnd_api.g_miss_num, display_order, p_display_order),

Line 165: position_reference = decode( p_position_reference, fnd_api.g_miss_char, position_reference, p_position_reference),

161: set
162: relationship_type_code = decode( p_relationship_type_code, fnd_api.g_miss_char, relationship_type_code, p_relationship_type_code),
163: object_id = decode( p_object_id, fnd_api.g_miss_num, object_id, p_object_id),
164: subject_id = decode( p_subject_id, fnd_api.g_miss_num, subject_id, p_subject_id),
165: position_reference = decode( p_position_reference, fnd_api.g_miss_char, position_reference, p_position_reference),
166: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
167: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
168: display_order = decode( p_display_order, fnd_api.g_miss_num, display_order, p_display_order),
169: mandatory_flag = decode( p_mandatory_flag, fnd_api.g_miss_char, mandatory_flag, p_mandatory_flag),

Line 166: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),

162: relationship_type_code = decode( p_relationship_type_code, fnd_api.g_miss_char, relationship_type_code, p_relationship_type_code),
163: object_id = decode( p_object_id, fnd_api.g_miss_num, object_id, p_object_id),
164: subject_id = decode( p_subject_id, fnd_api.g_miss_num, subject_id, p_subject_id),
165: position_reference = decode( p_position_reference, fnd_api.g_miss_char, position_reference, p_position_reference),
166: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
167: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
168: display_order = decode( p_display_order, fnd_api.g_miss_num, display_order, p_display_order),
169: mandatory_flag = decode( p_mandatory_flag, fnd_api.g_miss_char, mandatory_flag, p_mandatory_flag),
170: context = decode( p_context, fnd_api.g_miss_char, context, p_context),

Line 167: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),

163: object_id = decode( p_object_id, fnd_api.g_miss_num, object_id, p_object_id),
164: subject_id = decode( p_subject_id, fnd_api.g_miss_num, subject_id, p_subject_id),
165: position_reference = decode( p_position_reference, fnd_api.g_miss_char, position_reference, p_position_reference),
166: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
167: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
168: display_order = decode( p_display_order, fnd_api.g_miss_num, display_order, p_display_order),
169: mandatory_flag = decode( p_mandatory_flag, fnd_api.g_miss_char, mandatory_flag, p_mandatory_flag),
170: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
171: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),

Line 168: display_order = decode( p_display_order, fnd_api.g_miss_num, display_order, p_display_order),

164: subject_id = decode( p_subject_id, fnd_api.g_miss_num, subject_id, p_subject_id),
165: position_reference = decode( p_position_reference, fnd_api.g_miss_char, position_reference, p_position_reference),
166: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
167: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
168: display_order = decode( p_display_order, fnd_api.g_miss_num, display_order, p_display_order),
169: mandatory_flag = decode( p_mandatory_flag, fnd_api.g_miss_char, mandatory_flag, p_mandatory_flag),
170: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
171: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
172: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),

Line 169: mandatory_flag = decode( p_mandatory_flag, fnd_api.g_miss_char, mandatory_flag, p_mandatory_flag),

165: position_reference = decode( p_position_reference, fnd_api.g_miss_char, position_reference, p_position_reference),
166: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
167: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
168: display_order = decode( p_display_order, fnd_api.g_miss_num, display_order, p_display_order),
169: mandatory_flag = decode( p_mandatory_flag, fnd_api.g_miss_char, mandatory_flag, p_mandatory_flag),
170: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
171: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
172: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
173: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),

Line 170: context = decode( p_context, fnd_api.g_miss_char, context, p_context),

166: active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
167: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
168: display_order = decode( p_display_order, fnd_api.g_miss_num, display_order, p_display_order),
169: mandatory_flag = decode( p_mandatory_flag, fnd_api.g_miss_char, mandatory_flag, p_mandatory_flag),
170: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
171: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
172: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
173: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
174: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),

Line 171: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),

167: active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
168: display_order = decode( p_display_order, fnd_api.g_miss_num, display_order, p_display_order),
169: mandatory_flag = decode( p_mandatory_flag, fnd_api.g_miss_char, mandatory_flag, p_mandatory_flag),
170: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
171: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
172: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
173: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
174: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
175: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),

Line 172: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),

168: display_order = decode( p_display_order, fnd_api.g_miss_num, display_order, p_display_order),
169: mandatory_flag = decode( p_mandatory_flag, fnd_api.g_miss_char, mandatory_flag, p_mandatory_flag),
170: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
171: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
172: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
173: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
174: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
175: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
176: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),

Line 173: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),

169: mandatory_flag = decode( p_mandatory_flag, fnd_api.g_miss_char, mandatory_flag, p_mandatory_flag),
170: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
171: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
172: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
173: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
174: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
175: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
176: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
177: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),

Line 174: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),

170: context = decode( p_context, fnd_api.g_miss_char, context, p_context),
171: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
172: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
173: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
174: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
175: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
176: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
177: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
178: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),

Line 175: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),

171: attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
172: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
173: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
174: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
175: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
176: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
177: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
178: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
179: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),

Line 176: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),

172: attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
173: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
174: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
175: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
176: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
177: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
178: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
179: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
180: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),

Line 177: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),

173: attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
174: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
175: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
176: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
177: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
178: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
179: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
180: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
181: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),

Line 178: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),

174: attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
175: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
176: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
177: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
178: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
179: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
180: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
181: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
182: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),

Line 179: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),

175: attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
176: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
177: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
178: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
179: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
180: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
181: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
182: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
183: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),

Line 180: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),

176: attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
177: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
178: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
179: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
180: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
181: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
182: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
183: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
184: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),

Line 181: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),

177: attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
178: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
179: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
180: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
181: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
182: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
183: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
184: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
185: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),

Line 182: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),

178: attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
179: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
180: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
181: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
182: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
183: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
184: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
185: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
186: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

Line 183: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),

179: attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
180: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
181: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
182: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
183: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
184: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
185: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
186: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
187: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

Line 184: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),

180: attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
181: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
182: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
183: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
184: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
185: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
186: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
187: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
188: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

Line 185: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),

181: attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
182: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
183: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
184: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
185: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
186: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
187: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
188: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
189: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

Line 186: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),

182: attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
183: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
184: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
185: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
186: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
187: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
188: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
189: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
190: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

Line 187: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),

183: attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
184: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
185: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
186: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
187: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
188: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
189: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
190: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
191: object_version_number = object_version_number+1

Line 188: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),

184: attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
185: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
186: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
187: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
188: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
189: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
190: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
191: object_version_number = object_version_number+1
192: --object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)

Line 189: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),

185: attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
186: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
187: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
188: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
189: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
190: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
191: object_version_number = object_version_number+1
192: --object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
193: WHERE relationship_id = p_relationship_id;

Line 190: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),

186: created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
187: creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
188: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
189: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
190: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
191: object_version_number = object_version_number+1
192: --object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
193: WHERE relationship_id = p_relationship_id;
194:

Line 192: --object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)

188: last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
189: last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
190: last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
191: object_version_number = object_version_number+1
192: --object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
193: WHERE relationship_id = p_relationship_id;
194:
195: IF (SQL%NOTFOUND) THEN
196: RAISE NO_DATA_FOUND;