APPS.GL_GLWACCTR_XMLP_PKG dependencies on FND_DOCUMENT_SEQUENCES

Line 893: FROM FND_DOCUMENT_SEQUENCES

889:
890: IF P_DOC_ID IS NOT NULL THEN
891: SELECT NAME
892: INTO PARAM_DOC_SEQ_NAME
893: FROM FND_DOCUMENT_SEQUENCES
894: WHERE DOC_SEQUENCE_ID = P_DOC_ID;
895: END IF;
896: PARAM_DOC_SEQ_VALUE := P_DOC_VALUE;
897: PARAM_START_DOC_SEQ_VALUE := P_START_DOC_VALUE;

Line 903: FROM FND_DOCUMENT_SEQUENCES

899:
900: IF P_SUB_DOC_ID IS NOT NULL THEN
901: SELECT NAME
902: INTO PARAM_SUB_DOC_SEQ_NAME
903: FROM FND_DOCUMENT_SEQUENCES
904: WHERE DOC_SEQUENCE_ID = P_SUB_DOC_ID;
905: END IF;
906: PARAM_SUB_DOC_SEQ_VALUE := P_SUB_DOC_VALUE;
907:

Line 967: ' GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUENCES DOCSEQ, '||

963:
964: P_PERF_FROM :=
965: ' GL_JE_BATCHES GLB, GL_JE_HEADERS GLH '||P_LEDGER_FROM||
966: ' , GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_LEDGERS LGR, GL_JE_SOURCES GJS, GL_JE_CATEGORIES GJC, '||
967: ' GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUENCES DOCSEQ, '||
968: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ' ;
969:
970: -- SINCE THE FOLLOWING VARIABLE IS IN THE MAIN QUERY TO HANDLE THE REGULAR CASE
971: -- AND IN THIS CASE IT IS INCLUDED INTO THE P_PERF_FROM

Line 968: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ' ;

964: P_PERF_FROM :=
965: ' GL_JE_BATCHES GLB, GL_JE_HEADERS GLH '||P_LEDGER_FROM||
966: ' , GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_LEDGERS LGR, GL_JE_SOURCES GJS, GL_JE_CATEGORIES GJC, '||
967: ' GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUENCES DOCSEQ, '||
968: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ' ;
969:
970: -- SINCE THE FOLLOWING VARIABLE IS IN THE MAIN QUERY TO HANDLE THE REGULAR CASE
971: -- AND IN THIS CASE IT IS INCLUDED INTO THE P_PERF_FROM
972:

Line 988: USE_NL(DOCSEQ) INDEX(DOCSEQ FND_DOCUMENT_SEQUENCES_U1)

984: USE_NL(GLB) INDEX(GLB GL_JE_BATCHES_U1)
985: USE_NL(GJC) INDEX (GJC GL_JE_CATEGORIES_TL_U1)
986: USE_NL(GJS) INDEX (GJS GL_JE_SOURCES_TL_U1)
987: USE_NL(DCT) INDEX (DCT GL_DAILY_CONVERSION_TYPES_U1)
988: USE_NL(DOCSEQ) INDEX(DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
989: USE_NL(SUBDOCSEQ) INDEX(SUBDOCSEQ FND_DOCUMENT_SEQUENCES_U1)
990: USE_NL(FU) INDEX(FU FND_USER_U1) */';
991: ELSE
992: P_HINT_CLAUSE := '/*+ ORDERED

Line 989: USE_NL(SUBDOCSEQ) INDEX(SUBDOCSEQ FND_DOCUMENT_SEQUENCES_U1)

985: USE_NL(GJC) INDEX (GJC GL_JE_CATEGORIES_TL_U1)
986: USE_NL(GJS) INDEX (GJS GL_JE_SOURCES_TL_U1)
987: USE_NL(DCT) INDEX (DCT GL_DAILY_CONVERSION_TYPES_U1)
988: USE_NL(DOCSEQ) INDEX(DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
989: USE_NL(SUBDOCSEQ) INDEX(SUBDOCSEQ FND_DOCUMENT_SEQUENCES_U1)
990: USE_NL(FU) INDEX(FU FND_USER_U1) */';
991: ELSE
992: P_HINT_CLAUSE := '/*+ ORDERED
993: USE_NL(GLL) INDEX (GLL GL_JE_LINES_U1)

Line 999: USE_NL(DOCSEQ) INDEX(DOCSEQ FND_DOCUMENT_SEQUENCES_U1)

995: USE_NL(GLB) INDEX(GLB GL_JE_BATCHES_U1)
996: USE_NL(GJC) INDEX (GJC GL_JE_CATEGORIES_TL_U1)
997: USE_NL(GJS) INDEX (GJS GL_JE_SOURCES_TL_U1)
998: USE_NL(DCT) INDEX (DCT GL_DAILY_CONVERSION_TYPES_U1)
999: USE_NL(DOCSEQ) INDEX(DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
1000: USE_NL(SUBDOCSEQ) INDEX(SUBDOCSEQ FND_DOCUMENT_SEQUENCES_U1)
1001: USE_NL(FU) INDEX(FU FND_USER_U1) */';
1002: END IF;
1003:

Line 1000: USE_NL(SUBDOCSEQ) INDEX(SUBDOCSEQ FND_DOCUMENT_SEQUENCES_U1)

996: USE_NL(GJC) INDEX (GJC GL_JE_CATEGORIES_TL_U1)
997: USE_NL(GJS) INDEX (GJS GL_JE_SOURCES_TL_U1)
998: USE_NL(DCT) INDEX (DCT GL_DAILY_CONVERSION_TYPES_U1)
999: USE_NL(DOCSEQ) INDEX(DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
1000: USE_NL(SUBDOCSEQ) INDEX(SUBDOCSEQ FND_DOCUMENT_SEQUENCES_U1)
1001: USE_NL(FU) INDEX(FU FND_USER_U1) */';
1002: END IF;
1003:
1004: P_PERF_FROM :=

Line 1007: ' GL_JE_CATEGORIES GJC, GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUENCES DOCSEQ, '||

1003:
1004: P_PERF_FROM :=
1005: ' GL_JE_HEADERS GLH '||P_LEDGER_FROM||
1006: ' , GL_JE_BATCHES GLB, GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_JE_SOURCES GJS, GL_LEDGERS LGR,'||
1007: ' GL_JE_CATEGORIES GJC, GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUENCES DOCSEQ, '||
1008: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ';
1009:
1010: -- SINCE THE FOLLOWING VARIABLE IS IN THE MAIN QUERY TO HANDLE THE REGULAR CASE
1011: -- AND IN THIS CASE IT IS INCLUDED INTO THE P_PERF_FROM

Line 1008: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ';

1004: P_PERF_FROM :=
1005: ' GL_JE_HEADERS GLH '||P_LEDGER_FROM||
1006: ' , GL_JE_BATCHES GLB, GL_JE_LINES GLL, GL_CODE_COMBINATIONS CC, GL_JE_SOURCES GJS, GL_LEDGERS LGR,'||
1007: ' GL_JE_CATEGORIES GJC, GL_DAILY_CONVERSION_TYPES DCT, FND_DOCUMENT_SEQUENCES DOCSEQ, '||
1008: ' FND_DOCUMENT_SEQUENCES SUBDOCSEQ, FND_USER FU ';
1009:
1010: -- SINCE THE FOLLOWING VARIABLE IS IN THE MAIN QUERY TO HANDLE THE REGULAR CASE
1011: -- AND IN THIS CASE IT IS INCLUDED INTO THE P_PERF_FROM
1012: