DBA Data[Home] [Help]

APPS.FUN_TRX_PUB dependencies on FUN_TRX_HEADERS_S

Line 990: Fun_trx_headers_s.nextval,

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

Line 1088: Fun_trx_headers_s.currval,

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

Line 1218: Fun_trx_headers_s.currval

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

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

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