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