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

Line 38: p_doc_num IN PO_HEADERS.segment1%TYPE,

34: x_return_status OUT NOCOPY VARCHAR2,
35: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
36: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
37: p_doc_id IN NUMBER,
38: p_doc_num IN PO_HEADERS.segment1%TYPE,
39: p_release_id IN NUMBER,
40: p_release_num IN NUMBER,
41: p_doc_line_id IN NUMBER,
42: p_doc_line_num IN NUMBER,

Line 51: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,

47: p_action_date IN DATE,
48: p_cancel_reason IN PO_LINES.cancel_reason%TYPE,
49: p_cancel_reqs_flag IN VARCHAR2,
50: p_print_flag IN VARCHAR2,
51: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,
52: p_use_gldate IN VARCHAR2 --
53: )
54: IS
55:

Line 197: p_doc_num IN PO_HEADERS.segment1%TYPE,

193: PROCEDURE validate_control_action
194: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
195: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
196: p_doc_id IN NUMBER,
197: p_doc_num IN PO_HEADERS.segment1%TYPE,
198: p_release_id IN NUMBER,
199: p_release_num IN NUMBER,
200: p_doc_line_id IN NUMBER,
201: p_doc_line_num IN NUMBER,

Line 205: p_agent_id IN PO_HEADERS.agent_id%TYPE,

201: p_doc_line_num IN NUMBER,
202: p_doc_line_loc_id IN NUMBER,
203: p_doc_shipment_num IN NUMBER,
204: p_action IN VARCHAR2,
205: p_agent_id IN PO_HEADERS.agent_id%TYPE,
206: x_return_status OUT NOCOPY VARCHAR2)
207: IS
208:
209: l_api_name CONSTANT VARCHAR2(30) := 'validate_control_action';

Line 328: p_doc_num IN PO_HEADERS.segment1%TYPE,

324: x_return_status OUT NOCOPY VARCHAR2,
325: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
326: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
327: p_doc_id IN NUMBER,
328: p_doc_num IN PO_HEADERS.segment1%TYPE,
329: p_release_id IN NUMBER,
330: p_release_num IN NUMBER,
331: p_doc_line_id IN NUMBER,
332: p_doc_line_num IN NUMBER,

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

338: l_api_name CONSTANT VARCHAR2(30) := 'val_control_action';
339: l_api_version CONSTANT NUMBER := 1.0;
340:
341: -- Apps context should be initialized, so we can get the employee id directly
342: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;
343:
344: BEGIN
345: -- Start standard API initialization
346: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 437: p_doc_num IN PO_HEADERS.segment1%TYPE,

433: x_return_status OUT NOCOPY VARCHAR2,
434: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
435: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
436: p_doc_id IN NUMBER,
437: p_doc_num IN PO_HEADERS.segment1%TYPE,
438: p_release_id IN NUMBER,
439: p_release_num IN NUMBER,
440: p_doc_line_id IN NUMBER,
441: p_doc_line_num IN NUMBER,

Line 529: p_doc_num IN PO_HEADERS.segment1%TYPE,

525: PROCEDURE val_po_params
526: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
527: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
528: p_doc_id IN NUMBER,
529: p_doc_num IN PO_HEADERS.segment1%TYPE,
530: p_doc_line_id IN NUMBER,
531: p_doc_line_num IN NUMBER,
532: p_doc_line_loc_id IN NUMBER,
533: p_doc_shipment_num IN NUMBER,

Line 589: FROM po_headers poh

585: -- Derive header
586: IF (p_doc_id IS NULL) THEN
587: SELECT poh.po_header_id
588: INTO x_doc_id
589: FROM po_headers poh
590: WHERE poh.segment1 = p_doc_num AND
591: poh.type_lookup_code = p_doc_subtype;
592: ELSE
593: SELECT poh.po_header_id

Line 595: FROM po_headers poh

591: poh.type_lookup_code = p_doc_subtype;
592: ELSE
593: SELECT poh.po_header_id
594: INTO x_doc_id
595: FROM po_headers poh
596: WHERE poh.po_header_id = p_doc_id;
597: END IF;
598:
599: IF (g_fnd_debug = 'Y') THEN

Line 719: p_doc_num IN PO_HEADERS.segment1%TYPE,

715: PROCEDURE val_rel_params
716: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
717: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
718: p_doc_id IN NUMBER,
719: p_doc_num IN PO_HEADERS.segment1%TYPE,
720: p_release_id IN NUMBER,
721: p_release_num IN NUMBER,
722: p_doc_line_loc_id IN NUMBER,
723: p_doc_shipment_num IN NUMBER,

Line 789: FROM po_headers poh,

785: -- SQL Why: Need to derive the missing unique po_release_id
786: -- SQL Join: po_header_id
787: SELECT poh.po_header_id, por.po_release_id
788: INTO l_release_po_header_id, x_doc_id
789: FROM po_headers poh,
790: po_releases por
791: WHERE poh.segment1 = p_doc_num AND
792: poh.type_lookup_code = l_release_po_subtype AND
793: por.po_header_id = poh.po_header_id AND

Line 801: FROM po_headers poh,

797: -- SQL Why: Need to derive the missing unique po_release_id
798: -- SQL Join: po_header_id
799: SELECT poh.po_header_id, por.po_release_id
800: INTO l_release_po_header_id, x_doc_id
801: FROM po_headers poh,
802: po_releases por
803: WHERE poh.po_header_id = p_doc_id AND
804: por.po_header_id = poh.po_header_id AND
805: por.release_num = p_release_num;

Line 907: p_doc_num IN PO_HEADERS.segment1%TYPE,

903: x_return_status OUT NOCOPY VARCHAR2,
904: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
905: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
906: p_doc_id IN NUMBER,
907: p_doc_num IN PO_HEADERS.segment1%TYPE,
908: p_release_id IN NUMBER,
909: p_release_num IN NUMBER,
910: p_doc_line_id IN NUMBER,
911: p_doc_line_num IN NUMBER,