DBA Data[Home] [Help]

APPS.QA_TXN_GRP dependencies on QA_SEQUENCE_API

Line 471: QA_SEQUENCE_API.Generate_Seq_for_Txn

467: -- Calling the Sequence generation Api
468: -- to generate the sequences
469: -- ntungare Tue Jul 4 06:20:09 PDT 2006
470: --
471: QA_SEQUENCE_API.Generate_Seq_for_Txn
472: ( p_collection_id,
473: l_return_status);
474:
475: END evaltriggers_InsertRes_eamtxn;

Line 510: RETURN QA_SEQUENCE_API.get_sequence_default_value;

506: -- Need to insert the value 'Automatic' for Sequences while
507: -- posting background results. Calling Sequence API function
508: -- so as to consistently get the translated value for 'Automatic'
509: ELSIF datatype = 5 THEN -- sequence
510: RETURN QA_SEQUENCE_API.get_sequence_default_value;
511:
512: -- Bug 3179845. Timezone Project. rponnusa Fri Oct 17 10:34:50 PDT 2003
513: -- Added datetime datatype
514:

Line 588: || QA_SEQUENCE_API.get_sequence_default_value

584: --
585: ELSIF c.datatype = qa_ss_const.sequence_datatype THEN
586: l_insert_columns := l_insert_columns || ',' || c.result_column_name;
587: l_insert_values := l_insert_values || ', '''
588: || QA_SEQUENCE_API.get_sequence_default_value
589: || '''';
590:
591: --
592: -- Bug 5365165

Line 687: QA_SEQUENCE_API.Generate_Seq_for_Txn

683: -- Calling the Sequence generation Api
684: -- to generate the sequences
685: -- ntungare Tue Jul 4 06:20:09 PDT 2006
686: --
687: QA_SEQUENCE_API.Generate_Seq_for_Txn
688: (p_collection_id,
689: l_return_status);
690:
691: END IF;

Line 995: l_ret_string := l_ret_string || '@' || to_char(pc_rec.char_id) || '=' || QA_SEQUENCE_API.get_sequence_default_value;

991: -- 'Automatic'
992: -- ntungare
993: --
994: elsif pc_rec.datatype = qa_ss_const.sequence_datatype THEN
995: l_ret_string := l_ret_string || '@' || to_char(pc_rec.char_id) || '=' || QA_SEQUENCE_API.get_sequence_default_value;
996:
997: --
998: -- Bug 5365251
999: -- Checking if any collection element has

Line 1678: QA_SEQUENCE_API.generate_seq_for_txn

1674: );
1675: END IF;
1676:
1677: -- Generate Sequences
1678: QA_SEQUENCE_API.generate_seq_for_txn
1679: (
1680: p_collection_id => p_collection_id,
1681: p_return_status => l_return_status
1682: );

Line 2059: QA_SEQUENCE_API.generate_seq_for_txn

2055: );
2056: END IF;
2057:
2058: -- Generate Sequences
2059: QA_SEQUENCE_API.generate_seq_for_txn
2060: (
2061: p_collection_id => p_collection_id,
2062: p_return_status => l_return_status
2063: );