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_DOCUMENT_CONTROL_PVT dependencies on PO_HEADERS

Line 60: FROM po_headers poh

56:
57: IF (p_doc_type IN ('PO','PA')) THEN
58: SELECT 'Lock header'
59: INTO l_lock_row
60: FROM po_headers poh
61: WHERE poh.po_header_id = p_doc_id
62: FOR UPDATE NOWAIT;
63: ELSIF (p_doc_type = 'RELEASE') THEN
64: SELECT 'Lock release'

Line 214: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;

210: l_req_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE;
211: l_cancel_reqs_flag VARCHAR2(1) := p_cancel_reqs_flag;
212:
213: -- Apps context should be initialized, so we can get the employee id directly
214: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;
215:
216: l_action_date DATE := p_action_date;
217: l_cbc_enabled VARCHAR2(1);
218:

Line 225: l_doc_num PO_HEADERS.segment1%TYPE;

221: l_fetch_req_line_status VARCHAR2(1);
222: l_req_line_id_tbl PO_ReqChangeRequestWF_PVT.ReqLineID_tbl_type;
223:
224: l_request_id NUMBER := 0;
225: l_doc_num PO_HEADERS.segment1%TYPE;
226: l_rel_doc_num PO_RELEASES.release_num%TYPE;
227:
228: --< Bug 3554754 > Removed unnecessary CancelPO FPJ variables. Added variable for
229: -- approved_date.

Line 230: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;

226: l_rel_doc_num PO_RELEASES.release_num%TYPE;
227:
228: --< Bug 3554754 > Removed unnecessary CancelPO FPJ variables. Added variable for
229: -- approved_date.
230: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;
231: l_authorization_status po_headers.authorization_status%TYPE; --Bug5142892
232:
233: --
234: l_printflag VARCHAR2(1) := 'N';

Line 231: l_authorization_status po_headers.authorization_status%TYPE; --Bug5142892

227:
228: --< Bug 3554754 > Removed unnecessary CancelPO FPJ variables. Added variable for
229: -- approved_date.
230: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;
231: l_authorization_status po_headers.authorization_status%TYPE; --Bug5142892
232:
233: --
234: l_printflag VARCHAR2(1) := 'N';
235: l_faxflag VARCHAR2(1) := 'N';

Line 247: l_xml_flag PO_HEADERS_all.xml_flag%TYPE; -- Bug 5407459

243: l_is_complex_work_po BOOLEAN;
244: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
245: --
246:
247: l_xml_flag PO_HEADERS_all.xml_flag%TYPE; -- Bug 5407459
248:
249: BEGIN
250: -- Start standard API initialization
251: SAVEPOINT control_document_PVT;

Line 429: FROM po_headers_all

425: WHERE po_release_id = p_doc_id;
426: ELSE
427: SELECT authorization_status
428: INTO l_authorization_status
429: FROM po_headers_all
430: WHERE po_header_id= p_doc_id;
431: END IF;
432: --Bug5142892 end
433:

Line 729: from po_headers_all

725: ELSE
726: --Get the segment1 for the given document
727: select segment1
728: into l_doc_num
729: from po_headers_all
730: where po_header_id = p_doc_id;
731:
732: IF(p_communication_method_option = 'EMAIL') then
733: l_emailflag := 'Y';

Line 754: -- xml_flag on PO_HEADERS_ALL/PO_RELEASES_ALL accordingly.

750: --
751:
752: -- Bug 5407459 START
753: -- Pass p_xml_flag to start_wf_process so it can update the
754: -- xml_flag on PO_HEADERS_ALL/PO_RELEASES_ALL accordingly.
755: IF (l_default_method = 'XML') THEN
756: l_xml_flag := 'Y';
757: ELSE
758: l_xml_flag := 'N';

Line 821: po_headers poh

817: -- SQL Join: po_header_id
818: SELECT por.release_num, poh.segment1
819: INTO l_rel_doc_num, l_doc_num
820: FROM po_releases por,
821: po_headers poh
822: WHERE por.po_release_id = p_doc_id AND
823: por.po_header_id = poh.po_header_id;
824: ELSE
825: SELECT poh.segment1

Line 827: FROM po_headers poh

823: por.po_header_id = poh.po_header_id;
824: ELSE
825: SELECT poh.segment1
826: INTO l_doc_num
827: FROM po_headers poh
828: WHERE poh.po_header_id = p_doc_id;
829: END IF;
830:
831: create_print_request(p_api_version => 1.0,

Line 1335: po_headers poh

1331: -- SQL Why: Find all allowable header level control actions for this doc
1332: SELECT polc.displayed_field,
1333: polc.lookup_code
1334: FROM po_lookup_codes polc,
1335: po_headers poh
1336: WHERE poh.po_header_id = p_doc_id
1337: AND polc.lookup_type = 'CONTROL ACTIONS'
1338: AND NVL(poh.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1339: AND ( NVL(poh.cancel_flag, 'N') IN ('N','I')

Line 1556: po_headers poh

1552: SELECT polc.displayed_field,
1553: polc.lookup_code
1554: FROM po_lookup_codes polc,
1555: po_lines pol,
1556: po_headers poh
1557: WHERE pol.po_line_id = p_doc_line_id
1558: AND pol.po_header_id = poh.po_header_id
1559: AND polc.lookup_type = 'CONTROL ACTIONS'
1560: AND NVL(pol.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 1756: po_headers_all poh

1752: SELECT polc.displayed_field,
1753: polc.lookup_code
1754: FROM po_lookup_codes polc,
1755: po_line_locations_all poll,
1756: po_headers_all poh
1757: WHERE poll.line_location_id = p_doc_line_loc_id
1758: AND poll.po_header_id = poh.po_header_id
1759: AND polc.lookup_type = 'CONTROL ACTIONS'
1760: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 2303: p_agent_id IN PO_HEADERS.agent_id%TYPE,

2299: p_doc_id IN NUMBER,
2300: p_doc_line_id IN NUMBER,
2301: p_doc_line_loc_id IN NUMBER,
2302: p_action IN VARCHAR2,
2303: p_agent_id IN PO_HEADERS.agent_id%TYPE,
2304: x_control_level OUT NOCOPY NUMBER)
2305: IS
2306:
2307: l_api_name CONSTANT VARCHAR2(30) := 'val_control_action';

Line 2605: FROM po_headers poh

2601: IS
2602:
2603: CURSOR l_po_wf_csr IS
2604: SELECT poh.wf_item_type, poh.wf_item_key
2605: FROM po_headers poh
2606: WHERE poh.po_header_id = p_doc_id;
2607: CURSOR l_unapproved_releases_csr IS
2608: -- SQL What: Querying PO_HEADERS, PO_RELEASES for unapproved releases
2609: -- SQL Why: Need to stop wf processes for unapproved releases

Line 2608: -- SQL What: Querying PO_HEADERS, PO_RELEASES for unapproved releases

2604: SELECT poh.wf_item_type, poh.wf_item_key
2605: FROM po_headers poh
2606: WHERE poh.po_header_id = p_doc_id;
2607: CURSOR l_unapproved_releases_csr IS
2608: -- SQL What: Querying PO_HEADERS, PO_RELEASES for unapproved releases
2609: -- SQL Why: Need to stop wf processes for unapproved releases
2610: -- SQL Join: po_header_id
2611: SELECT por.po_release_id, poh.type_lookup_code,
2612: por.wf_item_type, por.wf_item_key

Line 2614: po_headers poh

2610: -- SQL Join: po_header_id
2611: SELECT por.po_release_id, poh.type_lookup_code,
2612: por.wf_item_type, por.wf_item_key
2613: FROM po_releases por,
2614: po_headers poh
2615: WHERE por.po_header_id = p_doc_id AND
2616: por.po_header_id = poh.po_header_id AND
2617: NVL(por.authorization_status,'INCOMPLETE') IN
2618: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL') AND

Line 2625: TYPE doc_subtype_tbl_type IS TABLE OF PO_HEADERS.type_lookup_code%TYPE

2621:
2622: -- Bulk processing types and variables
2623: TYPE release_id_tbl_type IS TABLE OF PO_RELEASES.po_release_id%TYPE
2624: INDEX BY BINARY_INTEGER;
2625: TYPE doc_subtype_tbl_type IS TABLE OF PO_HEADERS.type_lookup_code%TYPE
2626: INDEX BY BINARY_INTEGER;
2627: TYPE wf_item_type_tbl_type IS TABLE OF PO_RELEASES.wf_item_type%TYPE
2628: INDEX BY BINARY_INTEGER;
2629: TYPE wf_item_key_tbl_type IS TABLE OF PO_RELEASES.wf_item_key%TYPE

Line 2638: l_wf_item_type PO_HEADERS.wf_item_type%TYPE;

2634: l_wf_item_key_tbl wf_item_key_tbl_type;
2635:
2636: l_api_name CONSTANT VARCHAR2(30) := 'po_stop_wf_process';
2637: l_api_version CONSTANT NUMBER := 1.0;
2638: l_wf_item_type PO_HEADERS.wf_item_type%TYPE;
2639: l_wf_item_key PO_HEADERS.wf_item_key%TYPE;
2640: l_num_fetched NUMBER := 0; -- number of rows fetched at each iteration
2641:
2642: BEGIN

Line 2639: l_wf_item_key PO_HEADERS.wf_item_key%TYPE;

2635:
2636: l_api_name CONSTANT VARCHAR2(30) := 'po_stop_wf_process';
2637: l_api_version CONSTANT NUMBER := 1.0;
2638: l_wf_item_type PO_HEADERS.wf_item_type%TYPE;
2639: l_wf_item_key PO_HEADERS.wf_item_key%TYPE;
2640: l_num_fetched NUMBER := 0; -- number of rows fetched at each iteration
2641:
2642: BEGIN
2643: -- Start standard API initialization

Line 3288: * Modifies: note_to_vendor in PO_HEADERS, PO_LINES, or PO_RELEASES. API message

3284:
3285: /**
3286: * Public Procedure: update_note_to_vendor
3287: * Requires: API message list has been initialized if p_init_msg_list is false.
3288: * Modifies: note_to_vendor in PO_HEADERS, PO_LINES, or PO_RELEASES. API message
3289: * list.
3290: * Effects: Updates the note_to_vendor column of PO_HEADERS, PO_LINES, or
3291: * PO_RELEASES depending upon p_doc_type. If p_doc_line_id is not NULL and the
3292: * document is not a RELEASE, then updates PO_LINES. All changes will be

Line 3290: * Effects: Updates the note_to_vendor column of PO_HEADERS, PO_LINES, or

3286: * Public Procedure: update_note_to_vendor
3287: * Requires: API message list has been initialized if p_init_msg_list is false.
3288: * Modifies: note_to_vendor in PO_HEADERS, PO_LINES, or PO_RELEASES. API message
3289: * list.
3290: * Effects: Updates the note_to_vendor column of PO_HEADERS, PO_LINES, or
3291: * PO_RELEASES depending upon p_doc_type. If p_doc_line_id is not NULL and the
3292: * document is not a RELEASE, then updates PO_LINES. All changes will be
3293: * committed upon success if p_commit is FND_API.G_TRUE. Appends to API
3294: * message list on error.

Line 3308: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE)

3304: x_return_status OUT NOCOPY VARCHAR2,
3305: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
3306: p_doc_id IN NUMBER,
3307: p_doc_line_id IN NUMBER,
3308: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE)
3309: IS
3310:
3311: l_api_name CONSTANT VARCHAR2(30) := 'update_note_to_vendor';
3312: l_api_version CONSTANT NUMBER := 1.0;

Line 3368: FROM po_headers poh

3364: SET pla.note_to_vendor = p_note_to_vendor
3365: WHERE pla.po_line_id = p_doc_line_id AND
3366: pla.po_header_id = p_doc_id AND
3367: pla.revision_num = (SELECT poh.revision_num
3368: FROM po_headers poh
3369: WHERE poh.po_header_id = p_doc_id);
3370:
3371: ELSE
3372:

Line 3373: UPDATE po_headers poh

3369: WHERE poh.po_header_id = p_doc_id);
3370:
3371: ELSE
3372:
3373: UPDATE po_headers poh
3374: SET poh.note_to_vendor = p_note_to_vendor
3375: WHERE poh.po_header_id = p_doc_id;
3376:
3377: --

Line 3395: UPDATE po_headers_archive pha

3391:
3392: /* Bug 2781710: We should update the note_to_vendor column
3393: in the archive table also. */
3394:
3395: UPDATE po_headers_archive pha
3396: SET pha.note_to_vendor = p_note_to_vendor
3397: WHERE pha.po_header_id = p_doc_id AND
3398: pha.revision_num = (SELECT poh.revision_num
3399: FROM po_headers poh

Line 3399: FROM po_headers poh

3395: UPDATE po_headers_archive pha
3396: SET pha.note_to_vendor = p_note_to_vendor
3397: WHERE pha.po_header_id = p_doc_id AND
3398: pha.revision_num = (SELECT poh.revision_num
3399: FROM po_headers poh
3400: WHERE poh.po_header_id = p_doc_id);
3401: END IF; --
3402:
3403: ELSIF (p_doc_type = 'RELEASE') THEN

Line 3491: p_agent_id IN PO_HEADERS.agent_id%TYPE)

3487: x_return_status OUT NOCOPY VARCHAR2,
3488: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
3489: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
3490: p_doc_id IN NUMBER,
3491: p_agent_id IN PO_HEADERS.agent_id%TYPE)
3492: RETURN BOOLEAN
3493: IS
3494:
3495: l_api_name CONSTANT VARCHAR2(30) := 'pass_security_check';

Line 3497: l_doc_agent_id PO_HEADERS.agent_id%TYPE;

3493: IS
3494:
3495: l_api_name CONSTANT VARCHAR2(30) := 'pass_security_check';
3496: l_api_version CONSTANT NUMBER := 1.0;
3497: l_doc_agent_id PO_HEADERS.agent_id%TYPE;
3498: l_return_value BOOLEAN;
3499:
3500: BEGIN
3501: -- Start standard API initialization

Line 3536: FROM po_headers poh

3532: WHERE por.po_release_id = p_doc_id;
3533: ELSE
3534: SELECT poh.agent_id
3535: INTO l_doc_agent_id
3536: FROM po_headers poh
3537: WHERE poh.po_header_id = p_doc_id;
3538: END IF; -- if p_doc_type = ...
3539:
3540: -- Check if this agent has security clearance for this document

Line 4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

4182: ,x_online_report_id OUT NOCOPY NUMBER--bug#5055417
4183: )
4184: IS
4185: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;

Line 4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;

4183: )
4184: IS
4185: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4191: l_print_flag VARCHAR2(1);

Line 4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;

4184: IS
4185: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4191: l_print_flag VARCHAR2(1);
4192: l_event_code VARCHAR2(30);

Line 4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;

4185: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4191: l_print_flag VARCHAR2(1);
4192: l_event_code VARCHAR2(30);
4193: SUBTYPE busdocdates_tbl_type IS

Line 4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;

4186: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4187: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4188: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4189: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4190: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4191: l_print_flag VARCHAR2(1);
4192: l_event_code VARCHAR2(30);
4193: SUBTYPE busdocdates_tbl_type IS
4194: okc_manage_deliverables_grp.busdocdates_tbl_type;

Line 4304: from po_headers_all

4300: select conterms_exist_flag, start_date,
4301: end_date, decode(cancel_flag,'I',null,cancel_flag)
4302: into l_conterms_exist_flag, l_document_start_date,
4303: l_document_end_date, l_cancel_flag
4304: from po_headers_all
4305: where po_header_id = p_doc_header_id;
4306: d_pos := 70;
4307:
4308: IF (PO_LOG.d_stmt) THEN

Line 5133: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;

5129: ,x_valid_ctrl_ctn_tbl OUT NOCOPY PO_TBL_VARCHAR30)
5130: IS
5131: l_valid_actions_tbl g_lookup_code_tbl_type;
5132: l_displayed_field_tbl g_displayed_field_tbl_type;
5133: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;
5134: l_cons_trans_exist VARCHAR2(1);
5135: l_index NUMBER;
5136: l_agent_id NUMBER;
5137: l_item_id PO_LINES_ALL.item_Id%TYPE;

Line 5167: FROM po_headers_all

5163: --Get Document Sub type
5164: IF(p_doc_type IN (PO_CORE_S.g_doc_type_PO, PO_CORE_S.g_doc_type_PA)) THEN
5165: SELECT type_lookup_code
5166: INTO l_doc_subtype
5167: FROM po_headers_all
5168: WHERE po_header_id = p_doc_header_id;
5169: END IF;
5170: d_pos := 20;
5171: IF (PO_LOG.d_stmt) THEN