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 766: Select fun_trx_batches_s.nextval INTO l_batch_id from dual;

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

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

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

Line 787: P_TABLE_NAME => 'FUN_TRX_BATCHES',

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

Line 808: -- Insertion into FUN_TRX_BATCHES TABLE

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

Line 810: INSERT into fun_trx_batches(

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

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

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

Line 1279: UPDATE fun_trx_batches

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