APPS.FUN_TRX_PUB dependencies on FUN_TRX_HEADERS

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

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

Line 905: -- Insertion into FUN_TRX_HEADERS and FUN_TRX_LINES TABLE

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

Line 918: P_TABLE_NAME => 'FUN_TRX_HEADERS',

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

Line 941: INSERT into fun_trx_headers (

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

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

Line 1283: UPDATE fun_trx_headers

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