APPS.FUN_TRX_PUB dependencies on FUN_TRX_HEADERS

Line 903: Print('Val and Insert >>>>'||'Inserting into fun_trx_headers Table');

899: 'N'
900: );
901:
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

Line 906: -- Insertion into FUN_TRX_HEADERS and FUN_TRX_LINES TABLE

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

Line 919: P_TABLE_NAME => 'FUN_TRX_HEADERS',

915: fun_seq.get_sequence_number(
916: P_CONTEXT_TYPE => 'DB_INSTANCE',
917: p_context_value => null,
918: P_APPLICATION_ID => 435,
919: P_TABLE_NAME => 'FUN_TRX_HEADERS',
920: P_EVENT_CODE => 'CREATION',
921: p_control_attribute_rec => null,
922: p_control_date_tbl => null,
923: p_suppress_error => null,

Line 942: INSERT into fun_trx_headers (

938: To be uncommented - when doc seq is ready
939:
940: */
941:
942: INSERT into fun_trx_headers (
943: trx_id,
944: trx_number,
945: initiator_id,
946: recipient_id,

Line 991: Fun_trx_headers_s.nextval,

987: last_update_date,
988: last_update_login
989: )
990: VALUES(
991: Fun_trx_headers_s.nextval,
992: p_trx_tbl(l_head_count).trx_number,
993: p_batch_rec.initiator_id,
994: p_trx_tbl(l_head_count).recipient_id,
995: p_trx_tbl(l_head_count).to_le_id,

Line 1089: Fun_trx_headers_s.currval,

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,
1093: 'I',

Line 1219: Fun_trx_headers_s.currval

1215: sysdate,
1216: l_user,
1217: sysdate,
1218: l_login,
1219: Fun_trx_headers_s.currval
1220: );
1221: END IF; --p_dist_lines_tbl.trx_id = p_trx_tbl.trx_id
1222:
1223: END LOOP; -- l_line_count

Line 1231: select FUN_TRX_HEADERS_S.CURRVAL into l_trx_id from dual;

1227: --raise Workflow event if p_sent='Y'
1228: IF p_sent = 'Y' THEN
1229: Print('Val and Insert >>>>'||'Raise Business Event');
1230: select FUN_TRX_BATCHES_S.CURRVAL into l_batch_id from dual;
1231: select FUN_TRX_HEADERS_S.CURRVAL into l_trx_id from dual;
1232: l_wfkey := fun_initiator_wf_pkg.generate_key(l_batch_id, l_trx_id);
1233: fun_wf_common.raise_wf_bus_event(l_batch_id, l_trx_id, l_wfkey, 'oracle.apps.fun.manualtrx.batch.send');
1234: END IF;
1235: */

Line 1284: UPDATE fun_trx_headers

1280: UPDATE fun_trx_batches
1281: SET status = 'SENT'
1282: WHERE batch_id = l_batch_id;
1283:
1284: UPDATE fun_trx_headers
1285: SET status = 'SENT'
1286: WHERE batch_id = l_batch_id;
1287:
1288: l_wfkey := fun_initiator_wf_pkg.generate_key(l_batch_id, NULL);