DBA Data[Home] [Help]

APPS.ARP_MAINTAIN_PS dependencies on FND_SEQNUM

Line 717: * We are using FND_SEQNUM.GET_SEQ_NAME *

713: /********************************************
714: * Bug 1097459. *
715: * Changing all fnd sequnce calls *
716: * to the new ones. *
717: * We are using FND_SEQNUM.GET_SEQ_NAME *
718: * Instead of FND_SEQNUM.GET_SEQ_INFO *
719: *******************************************/
720:
721: /* fnd_seqnum.get_seq_name(

Line 718: * Instead of FND_SEQNUM.GET_SEQ_INFO *

714: * Bug 1097459. *
715: * Changing all fnd sequnce calls *
716: * to the new ones. *
717: * We are using FND_SEQNUM.GET_SEQ_NAME *
718: * Instead of FND_SEQNUM.GET_SEQ_INFO *
719: *******************************************/
720:
721: /* fnd_seqnum.get_seq_name(
722: 222, -- application_id

Line 721: /* fnd_seqnum.get_seq_name(

717: * We are using FND_SEQNUM.GET_SEQ_NAME *
718: * Instead of FND_SEQNUM.GET_SEQ_INFO *
719: *******************************************/
720:
721: /* fnd_seqnum.get_seq_name(
722: 222, -- application_id
723: l_type, -- category_code
724: l_set_of_books_id,
725: 'A', -- method_code

Line 741: l_dummy:= FND_SEQNUM.GET_SEQ_INFO(

737:
738: FND_PROFILE.GET( 'UNIQUE:SEQ_NUMBERS', v_profVal );
739: debug(' v_profVal='||v_profVal, MSG_LEVEL_DEVELOP );
740: if(v_profVal = 'P') THEN
741: l_dummy:= FND_SEQNUM.GET_SEQ_INFO(
742: 222, -- application_id
743: l_type, -- category_code
744: l_set_of_books_id,
745: 'A', -- method_code

Line 757: l_dummy:= FND_SEQNUM.GET_SEQ_INFO(

753: l_audit_table_name,
754: l_mesg_flag,'y','y');
755:
756: else
757: l_dummy:= FND_SEQNUM.GET_SEQ_INFO(
758: 222, -- application_id
759: l_type, -- category_code
760: l_set_of_books_id,
761: 'A', -- method_code

Line 797: fnd_seqnum.get_next_auto_seq( l_sequence_name );

793: END;
794:
795: /*
796: l_sequence_value :=
797: fnd_seqnum.get_next_auto_seq( l_sequence_name );
798:
799: debug(' sequence_value='||
800: l_sequence_value, MSG_LEVEL_DEVELOP );
801: */

Line 809: l_sequence_value := FND_SEQNUM.get_next_sequence (222,

805: For adj_rec in c_ar_adjustments(p_customer_trx_id) loop
806:
807: --Bug 1508981 - Added the call to get the next sequence number
808:
809: l_sequence_value := FND_SEQNUM.get_next_sequence (222,
810: l_type,
811: l_set_of_books_id,
812: 'A',
813: l_trx_date,