eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on PO_SESSION_GT

Line 2066: -- PO_SESSION_GT column mapping

2062: PO_DEBUG.debug_stmt(l_log_head,l_progress,'requisitions');
2063: END IF;
2064:
2065: ----------------------------------------------------------------
2066: -- PO_SESSION_GT column mapping
2067: --
2068: -- num1 sequence num of original (main) distribution
2069: -- num2 distribution_id of backing req
2070: -- num3 recreated req's distribution_id

Line 2079: INSERT INTO PO_SESSION_GT

2075: l_progress := '030';
2076:
2077: -- Get the encumbrance-impacted req distributions.
2078:
2079: INSERT INTO PO_SESSION_GT
2080: ( key
2081: , num1 -- main dist's sequence_num
2082: , num2 -- backing req's distribution_id
2083: )

Line 2171: UPDATE PO_SESSION_GT SCRATCH

2167: -- bug 3426141
2168: -- changed this statement to update num3 instead of updating num2,
2169: -- as there were difficulties in doing this correctly on 8i.
2170:
2171: UPDATE PO_SESSION_GT SCRATCH
2172: SET SCRATCH.num3 =
2173: ( SELECT PRD.distribution_id
2174: FROM PO_REQ_DISTRIBUTIONS_ALL PRD
2175: WHERE PRD.source_req_distribution_id = SCRATCH.num2

Line 2193: FROM PO_SESSION_GT WHERE key = l_backing_req_key ;

2189: l_progress := '080';
2190:
2191: IF g_debug_stmt THEN
2192: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
2193: FROM PO_SESSION_GT WHERE key = l_backing_req_key ;
2194:
2195: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
2196: PO_DEBUG.g_rowid_tbl,
2197: po_tbl_varchar30('key','num1','num2','num3')

Line 2195: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',

2191: IF g_debug_stmt THEN
2192: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
2193: FROM PO_SESSION_GT WHERE key = l_backing_req_key ;
2194:
2195: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
2196: PO_DEBUG.g_rowid_tbl,
2197: po_tbl_varchar30('key','num1','num2','num3')
2198: );
2199: END IF;

Line 2212: FROM PO_SESSION_GT SCRATCH

2208: , NVL(SCRATCH.num3, SCRATCH.num2)
2209: BULK COLLECT INTO
2210: x_origin_seq_num_tbl
2211: , x_dist_id_tbl
2212: FROM PO_SESSION_GT SCRATCH
2213: WHERE SCRATCH.key = l_backing_req_key
2214: ;
2215:
2216: l_progress := '090';

Line 4318: -- PO_SESSION_GT

4314: -- PO_ENCUMBRANCE_GT has been populated with the date information
4315: -- for both the original doc.
4316: --Modifies:
4317: -- PO_ENCUMBRANCE_GT
4318: -- PO_SESSION_GT
4319: --Locks:
4320: -- n/a
4321: --Function:
4322: -- This procedure updates the period information in PO_ENCUMBRANCE_GT

Line 4397: INSERT INTO PO_SESSION_GT

4393: -- to just ignore their updated value and skip straight to override
4394: -- date).
4395: l_progress := '030';
4396:
4397: INSERT INTO PO_SESSION_GT
4398: (
4399: key
4400: , index_num1 -- bug3543542 : Save sequence_num to an indexed column
4401: , date1

Line 4445: INSERT INTO PO_SESSION_GT ( key, date1 )

4441: -- this case, ALL distributions use the same override_date -- so we
4442: -- only perform the date SQL on one date.
4443: l_progress := '040';
4444:
4445: INSERT INTO PO_SESSION_GT ( key, date1 )
4446: VALUES ( l_procedure_id, TRUNC(p_override_date))
4447: ;
4448:
4449: END IF;

Line 4485: UPDATE PO_SESSION_GT TEMP

4481: l_validate_gl_period := nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y');
4482:
4483: IF (p_roll_logic_used= g_roll_logic_NONE ) THEN
4484:
4485: UPDATE PO_SESSION_GT TEMP
4486: SET (
4487: TEMP.char1, -- period_name
4488: TEMP.num2, -- period_year
4489: TEMP.num3, -- period_num

Line 4531: UPDATE PO_SESSION_GT TEMP

4527:
4528: --bug# 3627073
4529: ELSIF (p_roll_logic_used= g_roll_logic_FORWARD ) THEN
4530:
4531: UPDATE PO_SESSION_GT TEMP
4532: SET (
4533: TEMP.char1, -- period_name
4534: TEMP.num2, -- period_year
4535: TEMP.num3, -- period_num

Line 4591: UPDATE PO_SESSION_GT TEMP

4587:
4588: --bug# 3627073
4589: ELSIF(p_roll_logic_used= g_roll_logic_BACKWARD ) THEN
4590:
4591: UPDATE PO_SESSION_GT TEMP
4592: SET (
4593: TEMP.char1, -- period_name
4594: TEMP.num2, -- period_year
4595: TEMP.num3, -- period_num

Line 4655: UPDATE PO_SESSION_GT TEMP

4651: -- the present GL Date in the distributions does not belong to Open period,
4652: -- for the profile "PO: Validate GL Period: Redefault".
4653: IF Nvl(l_validate_gl_period,'N') = 'R' THEN
4654:
4655: UPDATE PO_SESSION_GT TEMP
4656: SET (
4657: TEMP.char1, -- period_name
4658: TEMP.num2, -- period_year
4659: TEMP.num3, -- period_num

Line 4710: FROM PO_SESSION_GT WHERE key = l_procedure_id

4706: IF g_debug_stmt THEN
4707: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Search for matching periods done');
4708:
4709: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
4710: FROM PO_SESSION_GT WHERE key = l_procedure_id
4711: ;
4712:
4713: PO_DEBUG.g_column_tbl := po_tbl_varchar30('key','date1','index_num1','char1','num2','num3','num4'); -- bug3543542
4714:

Line 4715: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',PO_DEBUG.g_rowid_tbl,PO_DEBUG.g_column_tbl,'PO');

4711: ;
4712:
4713: PO_DEBUG.g_column_tbl := po_tbl_varchar30('key','date1','index_num1','char1','num2','num3','num4'); -- bug3543542
4714:
4715: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',PO_DEBUG.g_rowid_tbl,PO_DEBUG.g_column_tbl,'PO');
4716:
4717: END IF;
4718:
4719:

Line 4721: -- the po_session_gt scratchpad.

4717: END IF;
4718:
4719:
4720: -- Update the main encumbrance GTT with the results from
4721: -- the po_session_gt scratchpad.
4722: IF (p_override_attempt = 'N') THEN
4723: -- There is one row in the session GT for each
4724: -- row in the main encumbrance GT that needs to be updated
4725: l_progress := '070';

Line 4728: -- Need to Add hints to ensure that PO_SESSION_GT_N2 index is used

4724: -- row in the main encumbrance GT that needs to be updated
4725: l_progress := '070';
4726:
4727: -- bug3543542
4728: -- Need to Add hints to ensure that PO_SESSION_GT_N2 index is used
4729:
4730: --bug#5098665 From now on we would populate the open period start date
4731: --instead of gl_encumbered_date. This is to ensure that the funds get
4732: --reserved/unreserved in the correct period. We would first populate

Line 4745: ( SELECT /+ INDEX (VALID_PERIOD PO_SESSION_GT_N2) /

4741: , DISTS.quarter_num
4742: , DISTS.gl_period_date --
4743: )
4744: =
4745: ( SELECT /*+ INDEX (VALID_PERIOD PO_SESSION_GT_N2) */
4746: VALID_PERIOD.char1 period_name
4747: , VALID_PERIOD.num2 period_year
4748: , VALID_PERIOD.num3 period_num
4749: , VALID_PERIOD.num4 quarter_num

Line 4751: FROM PO_SESSION_GT VALID_PERIOD

4747: , VALID_PERIOD.num2 period_year
4748: , VALID_PERIOD.num3 period_num
4749: , VALID_PERIOD.num4 quarter_num
4750: , VALID_PERIOD.date1 gl_period_date --
4751: FROM PO_SESSION_GT VALID_PERIOD
4752: WHERE
4753: VALID_PERIOD.key = l_procedure_id
4754: AND VALID_PERIOD.index_num1 = DISTS.sequence_num -- bug3543542
4755: AND VALID_PERIOD.char1 IS NOT NULL

Line 4789: FROM PO_SESSION_GT VALID_PERIOD

4785: , VALID_PERIOD.num2 period_year
4786: , VALID_PERIOD.num3 period_num
4787: , VALID_PERIOD.num4 quarter_num
4788: , VALID_PERIOD.date1 gl_period_date --
4789: FROM PO_SESSION_GT VALID_PERIOD
4790: WHERE
4791: VALID_PERIOD.key = l_procedure_id
4792: AND VALID_PERIOD.char1 IS NOT NULL
4793: AND rownum = 1

Line 4816: FROM PO_SESSION_GT TEMP

4812: INTO x_missing_date_flag
4813: FROM DUAL
4814: WHERE EXISTS
4815: (SELECT 'period information not populated'
4816: FROM PO_SESSION_GT TEMP
4817: WHERE TEMP.key = l_procedure_id
4818: AND TEMP.char1 is NULL -- no period name populated
4819: )
4820: ;

Line 4830: FROM PO_SESSION_GT TEMP

4826: l_progress := '100';
4827:
4828: -- Clean up the scratchpad
4829: DELETE
4830: FROM PO_SESSION_GT TEMP
4831: WHERE TEMP.key = l_procedure_id
4832: ;
4833:
4834: l_progress := '900';

Line 6329: FROM po_session_gt

6325: num2
6326: BULK COLLECT INTO
6327: l_sequence_num_tbl,
6328: l_enc_amt_tbl
6329: FROM po_session_gt
6330: WHERE index_char1= g_column_PO_ENCUMBERED_AMOUNT;
6331:
6332: IF g_debug_stmt THEN
6333: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl

Line 6334: FROM PO_SESSION_GT WHERE index_char1 = g_column_PO_ENCUMBERED_AMOUNT;

6330: WHERE index_char1= g_column_PO_ENCUMBERED_AMOUNT;
6331:
6332: IF g_debug_stmt THEN
6333: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
6334: FROM PO_SESSION_GT WHERE index_char1 = g_column_PO_ENCUMBERED_AMOUNT;
6335:
6336: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
6337: PO_DEBUG.g_rowid_tbl,
6338: po_tbl_varchar30('index_char1','num1','num2')

Line 6336: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',

6332: IF g_debug_stmt THEN
6333: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
6334: FROM PO_SESSION_GT WHERE index_char1 = g_column_PO_ENCUMBERED_AMOUNT;
6335:
6336: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
6337: PO_DEBUG.g_rowid_tbl,
6338: po_tbl_varchar30('index_char1','num1','num2')
6339: );
6340: END IF;

Line 6715: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Inserting the converted encumbered amount into po session gt');

6711: IF p_column_to_use IN (g_column_PO_ENCUMBERED_AMOUNT) THEN
6712:
6713: l_progress := '040';
6714: IF g_debug_stmt THEN
6715: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Inserting the converted encumbered amount into po session gt');
6716: END IF;
6717:
6718: FORALL i IN 1..l_sequence_num_tbl.COUNT
6719: INSERT INTO po_session_gt(index_char1,num1,num2)

Line 6719: INSERT INTO po_session_gt(index_char1,num1,num2)

6715: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Inserting the converted encumbered amount into po session gt');
6716: END IF;
6717:
6718: FORALL i IN 1..l_sequence_num_tbl.COUNT
6719: INSERT INTO po_session_gt(index_char1,num1,num2)
6720: VALUES (g_column_PO_ENCUMBERED_AMOUNT,l_sequence_num_tbl(i),l_amount_result_tbl(i));
6721: END IF;
6722: ----
6723: