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 177: l_auth_status po_headers.authorization_status%TYPE;

173: d_api_version CONSTANT NUMBER := 1.0;
174: d_module CONSTANT VARCHAR2(100) := g_pkg_name|| d_api_name;
175: l_progress VARCHAR2(3) := '000' ;
176:
177: l_auth_status po_headers.authorization_status%TYPE;
178: l_sub_check_status VARCHAR2(1);
179: l_online_report_id NUMBER;
180: l_check_asl BOOLEAN;
181: l_approval_path_id NUMBER;

Line 223: FROM po_headers_all

219: l_progress :='001';
220:
221: SELECT authorization_status
222: INTO l_auth_status
223: FROM po_headers_all
224: WHERE po_header_id=p_doc_id;
225:
226: ELSE
227:

Line 451: l_old_auth_status po_headers.authorization_status%TYPE; --Bug5142892

447: d_module CONSTANT VARCHAR2(100) := g_pkg_name|| l_api_name;
448:
449: l_msg_data VARCHAR2(2000);
450: l_msg_count NUMBER;
451: l_old_auth_status po_headers.authorization_status%TYPE; --Bug5142892
452: --
453: l_entity_dtl_rec_tbl po_document_action_pvt.entity_dtl_rec_type_tbl;
454: l_exc_msg VARCHAR2(2000);
455: l_return_code VARCHAR2(25);

Line 517: FROM po_headers_all

513: l_progress :='001';
514:
515: SELECT authorization_status
516: INTO l_old_auth_status
517: FROM po_headers_all
518: WHERE po_header_id=p_doc_id;
519:
520: ELSE
521:

Line 1173: po_headers poh

1169: -- SQL Why: Find all allowable header level control actions for this doc
1170: SELECT polc.displayed_field,
1171: polc.lookup_code
1172: FROM po_lookup_codes polc,
1173: po_headers poh
1174: WHERE poh.po_header_id = p_doc_id
1175: AND polc.lookup_type = 'CONTROL ACTIONS'
1176: AND NVL(poh.closed_code, 'OPEN') <> 'FINALLY CLOSED'
1177: AND ( NVL(poh.cancel_flag, 'N') IN ('N','I')

Line 1395: po_headers poh

1391: SELECT polc.displayed_field,
1392: polc.lookup_code
1393: FROM po_lookup_codes polc,
1394: po_lines pol,
1395: po_headers poh
1396: WHERE pol.po_line_id = p_doc_line_id
1397: AND pol.po_header_id = poh.po_header_id
1398: AND polc.lookup_type = 'CONTROL ACTIONS'
1399: AND NVL(pol.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 1596: po_headers_all poh

1592: SELECT polc.displayed_field,
1593: polc.lookup_code
1594: FROM po_lookup_codes polc,
1595: po_line_locations_all poll,
1596: po_headers_all poh
1597: WHERE poll.line_location_id = p_doc_line_loc_id
1598: AND poll.po_header_id = poh.po_header_id
1599: AND polc.lookup_type = 'CONTROL ACTIONS'
1600: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 2156: p_agent_id IN PO_HEADERS.agent_id%TYPE,

2152: p_doc_id IN NUMBER,
2153: p_doc_line_id IN NUMBER,
2154: p_doc_line_loc_id IN NUMBER,
2155: p_action IN VARCHAR2,
2156: p_agent_id IN PO_HEADERS.agent_id%TYPE,
2157: x_control_level OUT NOCOPY NUMBER)
2158: IS
2159:
2160: l_api_name CONSTANT VARCHAR2(30) := 'val_control_action';

Line 2458: FROM po_headers poh

2454: IS
2455:
2456: CURSOR l_po_wf_csr IS
2457: SELECT poh.wf_item_type, poh.wf_item_key
2458: FROM po_headers poh
2459: WHERE poh.po_header_id = p_doc_id;
2460: CURSOR l_unapproved_releases_csr IS
2461: -- SQL What: Querying PO_HEADERS, PO_RELEASES for unapproved releases
2462: -- SQL Why: Need to stop wf processes for unapproved releases

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

2457: SELECT poh.wf_item_type, poh.wf_item_key
2458: FROM po_headers poh
2459: WHERE poh.po_header_id = p_doc_id;
2460: CURSOR l_unapproved_releases_csr IS
2461: -- SQL What: Querying PO_HEADERS, PO_RELEASES for unapproved releases
2462: -- SQL Why: Need to stop wf processes for unapproved releases
2463: -- SQL Join: po_header_id
2464: SELECT por.po_release_id, poh.type_lookup_code,
2465: por.wf_item_type, por.wf_item_key

Line 2467: po_headers poh

2463: -- SQL Join: po_header_id
2464: SELECT por.po_release_id, poh.type_lookup_code,
2465: por.wf_item_type, por.wf_item_key
2466: FROM po_releases por,
2467: po_headers poh
2468: WHERE por.po_header_id = p_doc_id AND
2469: por.po_header_id = poh.po_header_id AND
2470: NVL(por.authorization_status,'INCOMPLETE') IN
2471: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL') AND

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

2474:
2475: -- Bulk processing types and variables
2476: TYPE release_id_tbl_type IS TABLE OF PO_RELEASES.po_release_id%TYPE
2477: INDEX BY BINARY_INTEGER;
2478: TYPE doc_subtype_tbl_type IS TABLE OF PO_HEADERS.type_lookup_code%TYPE
2479: INDEX BY BINARY_INTEGER;
2480: TYPE wf_item_type_tbl_type IS TABLE OF PO_RELEASES.wf_item_type%TYPE
2481: INDEX BY BINARY_INTEGER;
2482: TYPE wf_item_key_tbl_type IS TABLE OF PO_RELEASES.wf_item_key%TYPE

Line 2491: l_wf_item_type PO_HEADERS.wf_item_type%TYPE;

2487: l_wf_item_key_tbl wf_item_key_tbl_type;
2488:
2489: l_api_name CONSTANT VARCHAR2(30) := 'po_stop_wf_process';
2490: l_api_version CONSTANT NUMBER := 1.0;
2491: l_wf_item_type PO_HEADERS.wf_item_type%TYPE;
2492: l_wf_item_key PO_HEADERS.wf_item_key%TYPE;
2493: l_num_fetched NUMBER := 0; -- number of rows fetched at each iteration
2494:
2495: BEGIN

Line 2492: l_wf_item_key PO_HEADERS.wf_item_key%TYPE;

2488:
2489: l_api_name CONSTANT VARCHAR2(30) := 'po_stop_wf_process';
2490: l_api_version CONSTANT NUMBER := 1.0;
2491: l_wf_item_type PO_HEADERS.wf_item_type%TYPE;
2492: l_wf_item_key PO_HEADERS.wf_item_key%TYPE;
2493: l_num_fetched NUMBER := 0; -- number of rows fetched at each iteration
2494:
2495: BEGIN
2496: -- Start standard API initialization

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

3139:
3140: /**
3141: * Public Procedure: update_note_to_vendor
3142: * Requires: API message list has been initialized if p_init_msg_list is false.
3143: * Modifies: note_to_vendor in PO_HEADERS, PO_LINES, or PO_RELEASES. API message
3144: * list.
3145: * Effects: Updates the note_to_vendor column of PO_HEADERS, PO_LINES, or
3146: * PO_RELEASES depending upon p_doc_type. If p_doc_line_id is not NULL and the
3147: * document is not a RELEASE, then updates PO_LINES. All changes will be

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

3141: * Public Procedure: update_note_to_vendor
3142: * Requires: API message list has been initialized if p_init_msg_list is false.
3143: * Modifies: note_to_vendor in PO_HEADERS, PO_LINES, or PO_RELEASES. API message
3144: * list.
3145: * Effects: Updates the note_to_vendor column of PO_HEADERS, PO_LINES, or
3146: * PO_RELEASES depending upon p_doc_type. If p_doc_line_id is not NULL and the
3147: * document is not a RELEASE, then updates PO_LINES. All changes will be
3148: * committed upon success if p_commit is FND_API.G_TRUE. Appends to API
3149: * message list on error.

Line 3163: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE)

3159: x_return_status OUT NOCOPY VARCHAR2,
3160: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
3161: p_doc_id IN NUMBER,
3162: p_doc_line_id IN NUMBER,
3163: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE)
3164: IS
3165:
3166: l_api_name CONSTANT VARCHAR2(30) := 'update_note_to_vendor';
3167: l_api_version CONSTANT NUMBER := 1.0;

Line 3223: FROM po_headers poh

3219: SET pla.note_to_vendor = p_note_to_vendor
3220: WHERE pla.po_line_id = p_doc_line_id AND
3221: pla.po_header_id = p_doc_id AND
3222: pla.revision_num = (SELECT poh.revision_num
3223: FROM po_headers poh
3224: WHERE poh.po_header_id = p_doc_id);
3225:
3226: ELSE
3227:

Line 3228: UPDATE po_headers poh

3224: WHERE poh.po_header_id = p_doc_id);
3225:
3226: ELSE
3227:
3228: UPDATE po_headers poh
3229: SET poh.note_to_vendor = p_note_to_vendor
3230: WHERE poh.po_header_id = p_doc_id;
3231:
3232: --

Line 3250: UPDATE po_headers_archive pha

3246:
3247: /* Bug 2781710: We should update the note_to_vendor column
3248: in the archive table also. */
3249:
3250: UPDATE po_headers_archive pha
3251: SET pha.note_to_vendor = p_note_to_vendor
3252: WHERE pha.po_header_id = p_doc_id AND
3253: pha.revision_num = (SELECT poh.revision_num
3254: FROM po_headers poh

Line 3254: FROM po_headers poh

3250: UPDATE po_headers_archive pha
3251: SET pha.note_to_vendor = p_note_to_vendor
3252: WHERE pha.po_header_id = p_doc_id AND
3253: pha.revision_num = (SELECT poh.revision_num
3254: FROM po_headers poh
3255: WHERE poh.po_header_id = p_doc_id);
3256: END IF; --
3257:
3258: ELSIF (p_doc_type = 'RELEASE') THEN

Line 3346: p_agent_id IN PO_HEADERS.agent_id%TYPE)

3342: x_return_status OUT NOCOPY VARCHAR2,
3343: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
3344: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
3345: p_doc_id IN NUMBER,
3346: p_agent_id IN PO_HEADERS.agent_id%TYPE)
3347: RETURN BOOLEAN
3348: IS
3349:
3350: l_api_name CONSTANT VARCHAR2(30) := 'pass_security_check';

Line 3352: l_doc_agent_id PO_HEADERS.agent_id%TYPE;

3348: IS
3349:
3350: l_api_name CONSTANT VARCHAR2(30) := 'pass_security_check';
3351: l_api_version CONSTANT NUMBER := 1.0;
3352: l_doc_agent_id PO_HEADERS.agent_id%TYPE;
3353: l_return_value BOOLEAN;
3354:
3355: BEGIN
3356: -- Start standard API initialization

Line 3391: FROM po_headers poh

3387: WHERE por.po_release_id = p_doc_id;
3388: ELSE
3389: SELECT poh.agent_id
3390: INTO l_doc_agent_id
3391: FROM po_headers poh
3392: WHERE poh.po_header_id = p_doc_id;
3393: END IF; -- if p_doc_type = ...
3394:
3395: -- Check if this agent has security clearance for this document

Line 4026: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

4022: ,x_online_report_id OUT NOCOPY NUMBER--bug#5055417
4023: )
4024: IS
4025: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4026: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4027: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4028: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4029: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;

Line 4027: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;

4023: )
4024: IS
4025: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4026: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4027: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4028: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4029: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4031: l_print_flag VARCHAR2(1);

Line 4028: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;

4024: IS
4025: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4026: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4027: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4028: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4029: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4031: l_print_flag VARCHAR2(1);
4032: l_event_code VARCHAR2(30);

Line 4029: l_document_version PO_HEADERS_ALL.revision_num%TYPE;

4025: l_doc_subtype PO_LINE_LOCATIONS_ALL.shipment_type%type;
4026: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4027: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4028: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4029: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4031: l_print_flag VARCHAR2(1);
4032: l_event_code VARCHAR2(30);
4033: SUBTYPE busdocdates_tbl_type IS

Line 4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;

4026: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
4027: l_document_start_date PO_HEADERS_ALL.start_date%TYPE;
4028: l_document_end_date PO_HEADERS_ALL.end_date%TYPE;
4029: l_document_version PO_HEADERS_ALL.revision_num%TYPE;
4030: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE;
4031: l_print_flag VARCHAR2(1);
4032: l_event_code VARCHAR2(30);
4033: SUBTYPE busdocdates_tbl_type IS
4034: okc_manage_deliverables_grp.busdocdates_tbl_type;

Line 4143: from po_headers_all

4139: select conterms_exist_flag, start_date,
4140: end_date, decode(cancel_flag,'I',null,cancel_flag)
4141: into l_conterms_exist_flag, l_document_start_date,
4142: l_document_end_date, l_cancel_flag
4143: from po_headers_all
4144: where po_header_id = p_doc_header_id;
4145: d_pos := 70;
4146:
4147: IF (PO_LOG.d_stmt) THEN

Line 4959: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;

4955: ,x_valid_ctrl_ctn_tbl OUT NOCOPY PO_TBL_VARCHAR30)
4956: IS
4957: l_valid_actions_tbl g_lookup_code_tbl_type;
4958: l_displayed_field_tbl g_displayed_field_tbl_type;
4959: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%type;
4960: l_cons_trans_exist VARCHAR2(1);
4961: l_index NUMBER;
4962: l_agent_id NUMBER;
4963: l_item_id PO_LINES_ALL.item_Id%TYPE;

Line 4993: FROM po_headers_all

4989: --Get Document Sub type
4990: IF(p_doc_type IN (PO_CORE_S.g_doc_type_PO, PO_CORE_S.g_doc_type_PA)) THEN
4991: SELECT type_lookup_code
4992: INTO l_doc_subtype
4993: FROM po_headers_all
4994: WHERE po_header_id = p_doc_header_id;
4995: END IF;
4996: d_pos := 20;
4997: IF (PO_LOG.d_stmt) THEN

Line 5226: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;

5222: d_module CONSTANT VARCHAR2(100) := g_pkg_name|| d_api_name;
5223: l_progress VARCHAR2(3) := '000' ;
5224:
5225:
5226: l_conterms_exist_flag PO_HEADERS_ALL.conterms_exist_flag%TYPE;
5227: l_auth_status VARCHAR2(30);
5228: l_revision_num NUMBER;
5229: l_request_id NUMBER := 0;
5230: l_doc_type VARCHAR2(30);

Line 5265: FROM po_headers_all

5261: revision_num
5262: INTO l_conterms_exist_flag,
5263: l_auth_status,
5264: l_revision_num
5265: FROM po_headers_all
5266: WHERE po_header_id = p_doc_id;
5267:
5268: ELSE
5269:

Line 5309: FROM po_headers_archive_all

5305:
5306: l_progress :='003';
5307: SELECT Count(1)
5308: INTO l_archive_count
5309: FROM po_headers_archive_all
5310: WHERE po_header_id = p_doc_id;
5311:
5312: ELSE
5313: l_progress :='004';