DBA Data[Home] [Help]

APPS.FUN_TRX_PUB dependencies on FUN_TRX_HEADERS_S

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: */