APPS.FUN_TRX_PUB dependencies on FUN_DIST_LINES

Line 1106: -- Insertion into FUN_DIST_LINES

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

Line 1122: P_TABLE_NAME => 'FUN_DIST_LINES',

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

Line 1146: INSERT into fun_dist_lines

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

Line 1184: Fun_dist_lines_s.nextval,

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

Line 1186: Fun_dist_lines_s.currval, --Bug 3603338

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