[Home] [Help]
901:
902: Print('Val and Insert >>>>'||'Inserting into fun_trx_headers Table');
903:
904:
905: -- Insertion into FUN_TRX_HEADERS and FUN_TRX_LINES TABLE
906: for l_head_count in 1..p_trx_tbl.count
907: LOOP
908:
909: /* To be uncommented - when doc seq is ready
1034: sysdate,
1035: l_login
1036: );
1037:
1038: Print('Val and Insert >>>>'||'Inserting into fun_trx_lines Table');
1039:
1040: /* To be uncommented - when doc seq is ready
1041:
1042: If NOT (fun_system_options_pkg.is_manual_numbering ) then
1045: fun_seq.get_sequence_number(
1046: P_CONTEXT_TYPE => 'DB_INSTANCE',
1047: p_context_value => null,
1048: P_APPLICATION_ID => 435,
1049: P_TABLE_NAME => 'FUN_TRX_LINES',
1050: P_EVENT_CODE => 'CREATION',
1051: p_control_attribute_rec => null,
1052: p_control_date_tbl => null,
1053: p_suppress_error => null,
1066: To be uncommented - when doc seq is ready
1067: */
1068:
1069:
1070: INSERT into fun_trx_lines (
1071: line_id,
1072: trx_id,
1073: line_number,
1074: line_type_flag,
1083: last_update_date,
1084: last_update_login
1085: )
1086: VALUES(
1087: Fun_trx_lines_s.nextval,
1088: Fun_trx_headers_s.currval,
1089: --l_sequence_number, commented out untill generation of doc seq
1090: --1234, Taking line_id as line_number instead of hardcoding it. Bug 3603338
1091: Fun_trx_lines_s.currval,
1087: Fun_trx_lines_s.nextval,
1088: Fun_trx_headers_s.currval,
1089: --l_sequence_number, commented out untill generation of doc seq
1090: --1234, Taking line_id as line_number instead of hardcoding it. Bug 3603338
1091: Fun_trx_lines_s.currval,
1092: 'I',
1093: p_trx_tbl(l_head_count).init_amount_cr,
1094: p_trx_tbl(l_head_count).init_amount_dr,
1095: p_trx_tbl(l_head_count).reci_amount_cr,
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,
1189: p_dist_lines_tbl(l_line_count).dist_type_flag,