APPS.FUN_TRX_PUB dependencies on FUN_DIST_LINES

Line 1107: -- Insertion into FUN_DIST_LINES

1103: l_login
1104: );
1105:
1106:
1107: -- Insertion into FUN_DIST_LINES
1108: Print('Val and Insert >>>>'||'Inserting into fun_trx_dist_lines Table');
1109: If p_dist_lines_tbl is not null then
1110:
1111: for l_line_count in 1..p_dist_lines_tbl.count

Line 1123: P_TABLE_NAME => 'FUN_DIST_LINES',

1119: fun_seq.get_sequence_number(
1120: P_CONTEXT_TYPE => 'DB_INSTANCE',
1121: p_context_value => null,
1122: P_APPLICATION_ID => 435,
1123: P_TABLE_NAME => 'FUN_DIST_LINES',
1124: P_EVENT_CODE => 'CREATION',
1125: p_control_attribute_rec => null,
1126: p_control_date_tbl => null,
1127: p_suppress_error => null,

Line 1147: INSERT into fun_dist_lines

1143: */
1144: /*p_dist_lines_tbl(l_line_count).dist_number := 1234; --Bug 3603338 Hardcoded becoz seq num is not ready
1145: Taking dist_id as dist_number instead of hardcoding it.
1146: */
1147: INSERT into fun_dist_lines
1148: (
1149: dist_id,
1150: line_id,
1151: dist_number,

Line 1185: Fun_dist_lines_s.nextval,

1181: last_update_login,
1182: trx_id
1183: )
1184: VALUES(
1185: Fun_dist_lines_s.nextval,
1186: Fun_trx_lines_s.CURRVAL,
1187: Fun_dist_lines_s.currval, --Bug 3603338
1188: p_dist_lines_tbl(l_line_count).party_id,
1189: p_dist_lines_tbl(l_line_count).party_type_flag,

Line 1187: Fun_dist_lines_s.currval, --Bug 3603338

1183: )
1184: VALUES(
1185: Fun_dist_lines_s.nextval,
1186: Fun_trx_lines_s.CURRVAL,
1187: Fun_dist_lines_s.currval, --Bug 3603338
1188: p_dist_lines_tbl(l_line_count).party_id,
1189: p_dist_lines_tbl(l_line_count).party_type_flag,
1190: p_dist_lines_tbl(l_line_count).dist_type_flag,
1191: p_dist_lines_tbl(l_line_count).batch_dist_id,