APPS.FUN_TRX_PUB dependencies on FUN_TRX_BATCHES

Line 349: FROM fun_trx_batches

345: IF (p_calling_sequence = 'Intercompany Import Program') then
346: Print('Val and Insert >>>>'||'Validating Batch Id');
347: BEGIN
348: SELECT batch_id INTO l_unique_batch_id
349: FROM fun_trx_batches
350: WHERE batch_id=l_batch_rec.batch_id;
351: -- IF batch_id exist
352: l_return_status :=FND_API.G_RET_STS_ERROR;
353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 767: Select fun_trx_batches_s.nextval INTO l_batch_id from dual;

763:
764: IF p_batch_rec.batch_id is not null then
765: l_batch_id :=p_batch_rec.batch_id;
766: Else
767: Select fun_trx_batches_s.nextval INTO l_batch_id from dual;
768: END IF;
769:
770: /* If all Validations pass then the record should be inserted into Fun Tables with status as New */
771: If x_return_Status = FND_API.G_RET_STS_SUCCESS then

Line 777: Print('Val and Insert >>>>'||'Inserting into fun_trx_batches Table');

773: If (nvl(p_insert, FND_API.G_TRUE) = FND_API.G_TRUE) THEN
774: Print ('Populating User Id');
775: l_user := fnd_global.user_id;
776: l_login := fnd_global.login_id;
777: Print('Val and Insert >>>>'||'Inserting into fun_trx_batches Table');
778:
779: /* To be uncommented - when doc seq is ready
780:
781: If NOT(fun_system_options_pkg.is_manual_numbering ) then

Line 788: P_TABLE_NAME => 'FUN_TRX_BATCHES',

784: fun_seq.get_sequence_number(
785: P_CONTEXT_TYPE => 'DB_INSTANCE',
786: p_context_value => null,
787: P_APPLICATION_ID => 435,
788: P_TABLE_NAME => 'FUN_TRX_BATCHES',
789: P_EVENT_CODE => 'CREATION',
790: p_control_attribute_rec => null,
791: p_control_date_tbl => null,
792: p_suppress_error => null,

Line 809: -- Insertion into FUN_TRX_BATCHES TABLE

805: End If;
806: To be uncommented - when doc seq is ready
807: */
808:
809: -- Insertion into FUN_TRX_BATCHES TABLE
810:
811: INSERT into fun_trx_batches(
812: batch_id,
813: batch_number,

Line 811: INSERT into fun_trx_batches(

807: */
808:
809: -- Insertion into FUN_TRX_BATCHES TABLE
810:
811: INSERT into fun_trx_batches(
812: batch_id,
813: batch_number,
814: initiator_id,
815: from_le_id,

Line 1230: select FUN_TRX_BATCHES_S.CURRVAL into l_batch_id from dual;

1226: /* -- Send Batch not individual transactions
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;

Line 1280: UPDATE fun_trx_batches

1276:
1277: IF p_sent = 'Y' THEN
1278: Print('Val and Insert >>>>'||'Raise Business Event');
1279:
1280: UPDATE fun_trx_batches
1281: SET status = 'SENT'
1282: WHERE batch_id = l_batch_id;
1283:
1284: UPDATE fun_trx_headers