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 1519: po_headers_all poh

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

Line 2872: po_headers poh,

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

Line 3066: po_headers poh,

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

Line 3871: CURSOR c_get_po_headers(p_header_id NUMBER) IS

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

Line 3877: FROM po_headers

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

Line 3916: po_headers poh

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

Line 3962: l_po c_get_po_headers%ROWTYPE ;

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

Line 3964: l_bpa c_get_po_headers%ROWTYPE ;

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

Line 4151: OPEN c_get_po_headers(p_po_header_id);

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

Line 4152: FETCH c_get_po_headers INTO l_po;

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

Line 4153: CLOSE c_get_po_headers;

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

Line 4536: OPEN c_get_po_headers(p_po_header_id);

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

Line 4537: FETCH c_get_po_headers INTO l_bpa;

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

Line 4538: CLOSE c_get_po_headers;

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