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 2028: -- PO_SESSION_GT column mapping

2024: PO_DEBUG.debug_stmt(l_log_head,l_progress,'requisitions');
2025: END IF;
2026:
2027: ----------------------------------------------------------------
2028: -- PO_SESSION_GT column mapping
2029: --
2030: -- num1 sequence num of original (main) distribution
2031: -- num2 distribution_id of backing req
2032: -- num3 recreated req's distribution_id

Line 2041: INSERT INTO PO_SESSION_GT

2037: l_progress := '030';
2038:
2039: -- Get the encumbrance-impacted req distributions.
2040:
2041: INSERT INTO PO_SESSION_GT
2042: ( key
2043: , num1 -- main dist's sequence_num
2044: , num2 -- backing req's distribution_id
2045: )

Line 2133: UPDATE PO_SESSION_GT SCRATCH

2129: -- bug 3426141
2130: -- changed this statement to update num3 instead of updating num2,
2131: -- as there were difficulties in doing this correctly on 8i.
2132:
2133: UPDATE PO_SESSION_GT SCRATCH
2134: SET SCRATCH.num3 =
2135: ( SELECT PRD.distribution_id
2136: FROM PO_REQ_DISTRIBUTIONS_ALL PRD
2137: WHERE PRD.source_req_distribution_id = SCRATCH.num2

Line 2155: FROM PO_SESSION_GT WHERE key = l_backing_req_key ;

2151: l_progress := '080';
2152:
2153: IF g_debug_stmt THEN
2154: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
2155: FROM PO_SESSION_GT WHERE key = l_backing_req_key ;
2156:
2157: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
2158: PO_DEBUG.g_rowid_tbl,
2159: po_tbl_varchar30('key','num1','num2','num3')

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

2153: IF g_debug_stmt THEN
2154: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
2155: FROM PO_SESSION_GT WHERE key = l_backing_req_key ;
2156:
2157: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
2158: PO_DEBUG.g_rowid_tbl,
2159: po_tbl_varchar30('key','num1','num2','num3')
2160: );
2161: END IF;

Line 2174: FROM PO_SESSION_GT SCRATCH

2170: , NVL(SCRATCH.num3, SCRATCH.num2)
2171: BULK COLLECT INTO
2172: x_origin_seq_num_tbl
2173: , x_dist_id_tbl
2174: FROM PO_SESSION_GT SCRATCH
2175: WHERE SCRATCH.key = l_backing_req_key
2176: ;
2177:
2178: l_progress := '090';

Line 4241: -- PO_SESSION_GT

4237: -- PO_ENCUMBRANCE_GT has been populated with the date information
4238: -- for both the original doc.
4239: --Modifies:
4240: -- PO_ENCUMBRANCE_GT
4241: -- PO_SESSION_GT
4242: --Locks:
4243: -- n/a
4244: --Function:
4245: -- This procedure updates the period information in PO_ENCUMBRANCE_GT

Line 4318: INSERT INTO PO_SESSION_GT

4314: -- to just ignore their updated value and skip straight to override
4315: -- date).
4316: l_progress := '030';
4317:
4318: INSERT INTO PO_SESSION_GT
4319: (
4320: key
4321: , index_num1 -- bug3543542 : Save sequence_num to an indexed column
4322: , date1

Line 4366: INSERT INTO PO_SESSION_GT ( key, date1 )

4362: -- this case, ALL distributions use the same override_date -- so we
4363: -- only perform the date SQL on one date.
4364: l_progress := '040';
4365:
4366: INSERT INTO PO_SESSION_GT ( key, date1 )
4367: VALUES ( l_procedure_id, TRUNC(p_override_date))
4368: ;
4369:
4370: END IF;

Line 4403: UPDATE PO_SESSION_GT TEMP

4399: -- in a period and the exact date does not matter.
4400:
4401: IF (p_roll_logic_used= g_roll_logic_NONE ) THEN
4402:
4403: UPDATE PO_SESSION_GT TEMP
4404: SET (
4405: TEMP.char1, -- period_name
4406: TEMP.num2, -- period_year
4407: TEMP.num3, -- period_num

Line 4444: UPDATE PO_SESSION_GT TEMP

4440:
4441: --bug# 3627073
4442: ELSIF (p_roll_logic_used= g_roll_logic_FORWARD ) THEN
4443:
4444: UPDATE PO_SESSION_GT TEMP
4445: SET (
4446: TEMP.char1, -- period_name
4447: TEMP.num2, -- period_year
4448: TEMP.num3, -- period_num

Line 4499: UPDATE PO_SESSION_GT TEMP

4495:
4496: --bug# 3627073
4497: ELSIF(p_roll_logic_used= g_roll_logic_BACKWARD ) THEN
4498:
4499: UPDATE PO_SESSION_GT TEMP
4500: SET (
4501: TEMP.char1, -- period_name
4502: TEMP.num2, -- period_year
4503: TEMP.num3, -- period_num

Line 4559: FROM PO_SESSION_GT WHERE key = l_procedure_id

4555: IF g_debug_stmt THEN
4556: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Search for matching periods done');
4557:
4558: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
4559: FROM PO_SESSION_GT WHERE key = l_procedure_id
4560: ;
4561:
4562: PO_DEBUG.g_column_tbl := po_tbl_varchar30('key','date1','index_num1','char1','num2','num3','num4'); -- bug3543542
4563:

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

4560: ;
4561:
4562: PO_DEBUG.g_column_tbl := po_tbl_varchar30('key','date1','index_num1','char1','num2','num3','num4'); -- bug3543542
4563:
4564: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',PO_DEBUG.g_rowid_tbl,PO_DEBUG.g_column_tbl,'PO');
4565:
4566: END IF;
4567:
4568:

Line 4570: -- the po_session_gt scratchpad.

4566: END IF;
4567:
4568:
4569: -- Update the main encumbrance GTT with the results from
4570: -- the po_session_gt scratchpad.
4571: IF (p_override_attempt = 'N') THEN
4572: -- There is one row in the session GT for each
4573: -- row in the main encumbrance GT that needs to be updated
4574: l_progress := '070';

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

4573: -- row in the main encumbrance GT that needs to be updated
4574: l_progress := '070';
4575:
4576: -- bug3543542
4577: -- Need to Add hints to ensure that PO_SESSION_GT_N2 index is used
4578:
4579: --bug#5098665 From now on we would populate the open period start date
4580: --instead of gl_encumbered_date. This is to ensure that the funds get
4581: --reserved/unreserved in the correct period. We would first populate

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

4590: , DISTS.quarter_num
4591: , DISTS.gl_period_date --
4592: )
4593: =
4594: ( SELECT /*+ INDEX (VALID_PERIOD PO_SESSION_GT_N2) */
4595: VALID_PERIOD.char1 period_name
4596: , VALID_PERIOD.num2 period_year
4597: , VALID_PERIOD.num3 period_num
4598: , VALID_PERIOD.num4 quarter_num

Line 4600: FROM PO_SESSION_GT VALID_PERIOD

4596: , VALID_PERIOD.num2 period_year
4597: , VALID_PERIOD.num3 period_num
4598: , VALID_PERIOD.num4 quarter_num
4599: , VALID_PERIOD.date1 gl_period_date --
4600: FROM PO_SESSION_GT VALID_PERIOD
4601: WHERE
4602: VALID_PERIOD.key = l_procedure_id
4603: AND VALID_PERIOD.index_num1 = DISTS.sequence_num -- bug3543542
4604: AND VALID_PERIOD.char1 IS NOT NULL

Line 4638: FROM PO_SESSION_GT VALID_PERIOD

4634: , VALID_PERIOD.num2 period_year
4635: , VALID_PERIOD.num3 period_num
4636: , VALID_PERIOD.num4 quarter_num
4637: , VALID_PERIOD.date1 gl_period_date --
4638: FROM PO_SESSION_GT VALID_PERIOD
4639: WHERE
4640: VALID_PERIOD.key = l_procedure_id
4641: AND VALID_PERIOD.char1 IS NOT NULL
4642: AND rownum = 1

Line 4665: FROM PO_SESSION_GT TEMP

4661: INTO x_missing_date_flag
4662: FROM DUAL
4663: WHERE EXISTS
4664: (SELECT 'period information not populated'
4665: FROM PO_SESSION_GT TEMP
4666: WHERE TEMP.key = l_procedure_id
4667: AND TEMP.char1 is NULL -- no period name populated
4668: )
4669: ;

Line 4679: FROM PO_SESSION_GT TEMP

4675: l_progress := '100';
4676:
4677: -- Clean up the scratchpad
4678: DELETE
4679: FROM PO_SESSION_GT TEMP
4680: WHERE TEMP.key = l_procedure_id
4681: ;
4682:
4683: l_progress := '900';