APPS.JG_JGZZGLJRN_XMLP_PKG dependencies on FND_DOCUMENT_SEQUENCES

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

77: USE_NL(GLL) INDEX (GLL GL_JE_LINES_N1)
78: USE_NL(GLH) INDEX (GLH GL_JE_HEADERS_U1)
79: USE_NL(GLB) INDEX (GLB GL_JE_BATCHES_U1)
80: USE_NL(FSV) INDEX (FSV FUN_SEQ_VERSIONS_U1)
81: USE_NL(DOCSEQ) INDEX (DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
82: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)
83: USE_NL(CAT) INDEX (CAT GL_JE_CATEGORY_TL_U1)
84: USE_NL(GLC) INDEX (GLC GL_LEDGER_CONFIGURATIONS_U1)
85: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)

Line 90: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,

86: */ ';
87: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
88: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
89: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
90: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
91: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';
92: ELSE
93: P_PERIOD_INX_HINT := ' /*+ ORDERED
94: USE_NL(CC) INDEX (CC GL_CODE_COMBINATIONS_N2

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

97: USE_NL(GLL) INDEX (GLL GL_JE_LINES_N1)
98: USE_NL(GLH) INDEX (GLH GL_JE_HEADERS_U1)
99: USE_NL(GLB) INDEX (GLB GL_JE_BATCHES_U1)
100: USE_NL(FSV) INDEX (FSV FUN_SEQ_VERSIONS_U1)
101: USE_NL(DOCSEQ) INDEX (DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
102: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)
103: USE_NL(CAT) INDEX (CAT GL_JE_CATEGORY_TL_U1)
104: USE_NL(GLC) INDEX (GLC GL_LEDGER_CONFIGURATIONS_U1)
105: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)

Line 111: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,

107: */ ';
108: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
109: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
110: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
111: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
112: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
113: END IF;
114: ELSIF ((P_STATUS = 'E') OR (P_STATUS = 'U')) THEN
115: P_PERIOD_INX_HINT := '/*+ ORDERED */';

Line 119: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,

115: P_PERIOD_INX_HINT := '/*+ ORDERED */';
116: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,
117: GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
118: GL_LEDGERS LGR, GL_LEDGER_CONFIGURATIONS glc,
119: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
120: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
121: END IF;
122: ELSE
123: F_PERIOD_NUM := GET_EFF_PERIOD_NUM(P_ACCESS_SET_ID

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

134: USE_NL(GLL) INDEX (GLL GL_JE_LINES_N1)
135: USE_NL(GLH) INDEX (GLH GL_JE_HEADERS_U1)
136: USE_NL(GLB) INDEX (GLB GL_JE_BATCHES_U1)
137: USE_NL(FSV) INDEX (FSV FUN_SEQ_VERSIONS_U1)
138: USE_NL(DOCSEQ) INDEX (DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
139: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)
140: USE_NL(CAT) INDEX (CAT GL_JE_CATEGORY_TL_U1)
141: USE_NL(GLC) INDEX (GLC GL_LEDGER_CONFIGURATIONS_U1)
142: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)

Line 147: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,

143: */ ';
144: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
145: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
146: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
147: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
148: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';
149: ELSE
150: P_PERIOD_INX_HINT := ' /*+ ORDERED
151: USE_NL(CC) INDEX (CC GL_CODE_COMBINATIONS_N2

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

154: USE_NL(GLL) INDEX (GLL GL_JE_LINES_N1)
155: USE_NL(GLH) INDEX (GLH GL_JE_HEADERS_U1)
156: USE_NL(GLB) INDEX (GLB GL_JE_BATCHES_U1)
157: USE_NL(FSV) INDEX (FSV FUN_SEQ_VERSIONS_U1)
158: USE_NL(DOCSEQ) INDEX (DOCSEQ FND_DOCUMENT_SEQUENCES_U1)
159: USE_NL(SRC) INDEX (SRC GL_JE_SOURCES_TL_U1)
160: USE_NL(CAT) INDEX (CAT GL_JE_CATEGORY_TL_U1)
161: USE_NL(GLC) INDEX (GLC GL_LEDGER_CONFIGURATIONS_U1)
162: USE_NL(LOOK) INDEX (LOOK FND_LOOKUP_VALUES_U1)

Line 168: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,

164: */ ';
165: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
166: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
167: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
168: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
169: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
170: END IF;
171: ELSIF ((P_STATUS = 'E') OR (P_STATUS = 'U')) THEN
172: P_PERIOD_INX_HINT := '/*+ ORDERED */';

Line 176: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,

172: P_PERIOD_INX_HINT := '/*+ ORDERED */';
173: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,
174: GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
175: GL_LEDGERS LGR, GL_LEDGER_CONFIGURATIONS glc,
176: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
177: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT , GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
178: END IF;
179: END IF;
180: IF ((P_START_DATE IS NOT NULL) OR (P_END_DATE IS NOT NULL)) THEN

Line 320: FND_DOCUMENT_SEQUENCES

316: SELECT
317: NAME
318: INTO DOC_SEQ_NAME_PARAM
319: FROM
320: FND_DOCUMENT_SEQUENCES
321: WHERE DOC_SEQUENCE_ID = P_DOC_SEQ_NAME;
322: END IF;
323: START_DOC_SEQ_NUM_PARAM := P_START_DOC_VALUE;
324: END_DOC_SEQ_NUM_PARAM := P_END_DOC_VALUE;