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.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_HEADERS

Line 151: FROM po_headers poh,

147:
148: -- Amended Cursor below whilst testing Relock failure
149: CURSOR c_lock_po IS
150: SELECT 'x'
151: FROM po_headers poh,
152: po_lines pol ,
153: po_line_locations poll,
154: po_distributions pod
155: WHERE poh.po_header_id = p_document_id

Line 173: FROM po_headers poh,

169: FOR UPDATE NOWAIT;
170:
171: CURSOR c_lock_bpa IS
172: SELECT 'x'
173: FROM po_headers poh,
174: po_distributions pod
175: WHERE poh.po_header_id = p_document_id
176: AND poh.po_header_id = pod.po_header_id
177: FOR UPDATE NOWAIT;

Line 1518: po_headers_all poh

1514: Nvl(pod.encumbered_flag,'N'),
1515: pod.gl_encumbered_date,
1516: pod.gl_encumbered_period_name
1517: FROM po_distributions_all pod,
1518: po_headers_all poh
1519: WHERE (Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) > 0
1520: AND Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(pod.unencumbered_amount,0)
1521: OR Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(poh.blanket_total_amount,0))
1522: AND Nvl(poh.encumbrance_required_flag,'N') = 'Y'

Line 2871: po_headers poh,

2867: FROM
2868: fnd_currencies base_cur,
2869: gl_sets_of_books glsob,
2870: financials_system_parameters fsp,
2871: po_headers poh,
2872: po_line_locations poll,
2873: po_line_locations prll,
2874: po_distributions pod,
2875: po_distributions prd,

Line 3065: po_headers poh,

3061: FROM
3062: fnd_currencies base_cur,
3063: gl_sets_of_books glsob,
3064: financials_system_parameters fsp,
3065: po_headers poh,
3066: po_line_locations poll,
3067: po_line_locations prll,
3068: po_distributions pod,
3069: po_distributions prd,

Line 3870: CURSOR c_get_po_headers(p_header_id NUMBER) IS

3866: cbc_accounting_date
3867: FROM po_releases
3868: WHERE po_release_id = p_release_id ;
3869:
3870: CURSOR c_get_po_headers(p_header_id NUMBER) IS
3871: SELECT authorization_status auth_status,
3872: user_hold_flag hold_flag,
3873: type_lookup_code document_subtype,
3874: frozen_flag,

Line 3876: FROM po_headers

3872: user_hold_flag hold_flag,
3873: type_lookup_code document_subtype,
3874: frozen_flag,
3875: cbc_accounting_date
3876: FROM po_headers
3877: WHERE po_header_id = p_header_id ;
3878:
3879: CURSOR c_get_requisitions(p_req_id NUMBER) IS
3880: SELECT authorization_status auth_status,

Line 3915: po_headers poh

3911: CURSOR c_get_po_future(p_req_id NUMBER) IS
3912: SELECT 'x'
3913: FROM po_distributions pod,
3914: po_requisition_lines porl,
3915: po_headers poh
3916: WHERE porl.requisition_header_id = p_req_id
3917: AND porl.line_location_id = pod.line_location_id
3918: AND pod.gl_encumbered_date >= p_curr_year_start_date
3919: AND pod.po_header_id = poh.po_header_id

Line 3961: l_po c_get_po_headers%ROWTYPE ;

3957: AND ipe.document_type = 'REQ'
3958: AND ipe.conc_request_id = p_conc_request_id ;
3959:
3960: l_release c_get_releases%ROWTYPE ;
3961: l_po c_get_po_headers%ROWTYPE ;
3962: l_requisition c_get_requisitions%ROWTYPE ;
3963: l_bpa c_get_po_headers%ROWTYPE ;
3964: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3965: l_found_error VARCHAR2(1) ;

Line 3963: l_bpa c_get_po_headers%ROWTYPE ;

3959:
3960: l_release c_get_releases%ROWTYPE ;
3961: l_po c_get_po_headers%ROWTYPE ;
3962: l_requisition c_get_requisitions%ROWTYPE ;
3963: l_bpa c_get_po_headers%ROWTYPE ;
3964: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3965: l_found_error VARCHAR2(1) ;
3966: l_found_future VARCHAR2(1) ;
3967: l_msg_data VARCHAR2(2000) := null ;

Line 4150: OPEN c_get_po_headers(p_po_header_id);

4146: END IF; -- Lock Documents
4147: END IF ; -- process_phase = 'F'
4148:
4149: -- get PO document details
4150: OPEN c_get_po_headers(p_po_header_id);
4151: FETCH c_get_po_headers INTO l_po;
4152: CLOSE c_get_po_headers;
4153:
4154: IF (g_debug_mode = 'Y') THEN

Line 4151: FETCH c_get_po_headers INTO l_po;

4147: END IF ; -- process_phase = 'F'
4148:
4149: -- get PO document details
4150: OPEN c_get_po_headers(p_po_header_id);
4151: FETCH c_get_po_headers INTO l_po;
4152: CLOSE c_get_po_headers;
4153:
4154: IF (g_debug_mode = 'Y') THEN
4155: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed get po');

Line 4152: CLOSE c_get_po_headers;

4148:
4149: -- get PO document details
4150: OPEN c_get_po_headers(p_po_header_id);
4151: FETCH c_get_po_headers INTO l_po;
4152: CLOSE c_get_po_headers;
4153:
4154: IF (g_debug_mode = 'Y') THEN
4155: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed get po');
4156: END IF;

Line 4535: OPEN c_get_po_headers(p_po_header_id);

4531: END IF; -- Lock_Documents
4532: END IF ; -- p_process_phase = 'F'
4533:
4534: -- Get BPA details
4535: OPEN c_get_po_headers(p_po_header_id);
4536: FETCH c_get_po_headers INTO l_bpa;
4537: CLOSE c_get_po_headers;
4538:
4539: IF (g_debug_mode = 'Y') THEN

Line 4536: FETCH c_get_po_headers INTO l_bpa;

4532: END IF ; -- p_process_phase = 'F'
4533:
4534: -- Get BPA details
4535: OPEN c_get_po_headers(p_po_header_id);
4536: FETCH c_get_po_headers INTO l_bpa;
4537: CLOSE c_get_po_headers;
4538:
4539: IF (g_debug_mode = 'Y') THEN
4540: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed get blanket agreements');

Line 4537: CLOSE c_get_po_headers;

4533:
4534: -- Get BPA details
4535: OPEN c_get_po_headers(p_po_header_id);
4536: FETCH c_get_po_headers INTO l_bpa;
4537: CLOSE c_get_po_headers;
4538:
4539: IF (g_debug_mode = 'Y') THEN
4540: Put_Debug_Msg (l_full_path,p_debug_msg => 'completed get blanket agreements');
4541: END IF;