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: p_launch_approvals_flag IN VARCHAR2, -- Bug#8224603
54: p_caller IN VARCHAR2 --Bug9321845(6603493)
55: )

Line 78: x_document_num po_headers.segment1%type := null;

74: x_fax_number varchar2(100) := null;
75: x_po_api_return_status varchar2 (3) := null;
76: x_msg_count number := NULL;
77: x_msg_data varchar2(2000):= NULL;
78: x_document_num po_headers.segment1%type := null;
79: x_communication_method_value varchar2(100) := null;
80: --16035142 end
81:
82: BEGIN

Line 255: p_doc_num IN PO_HEADERS.segment1%TYPE,

251: x_return_status OUT NOCOPY VARCHAR2,
252: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
253: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
254: p_doc_id IN NUMBER,
255: p_doc_num IN PO_HEADERS.segment1%TYPE,
256: p_release_id IN NUMBER,
257: p_release_num IN NUMBER,
258: p_doc_line_id IN RecTabpo_line_ids,
259: p_doc_line_num IN NUMBER,

Line 268: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,

264: p_action_date IN DATE,
265: p_cancel_reason IN PO_LINES.cancel_reason%TYPE,
266: p_cancel_reqs_flag IN VARCHAR2,
267: p_print_flag IN VARCHAR2,
268: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,
269: p_use_gldate IN VARCHAR2,
270: p_launch_approvals_flag IN VARCHAR2,
271: p_caller IN VARCHAR2)
272: -- )

Line 299: x_document_num po_headers.segment1%type := null;

295: x_fax_number varchar2(100) := null;
296: x_po_api_return_status varchar2 (3) := null;
297: x_msg_count number := NULL;
298: x_msg_data varchar2(2000):= NULL;
299: x_document_num po_headers.segment1%type := null;
300: --16035142 end
301:
302:
303: BEGIN

Line 421: FROM po_headers_all

417: ELSE
418:
419: SELECT authorization_status
420: INTO l_old_auth_status
421: FROM po_headers_all
422: WHERE po_header_id= l_doc_id;
423:
424: END IF;
425: --Bug 8792423 added exception

Line 594: p_doc_num IN PO_HEADERS.segment1%TYPE,

590: PROCEDURE validate_control_action
591: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
592: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
593: p_doc_id IN NUMBER,
594: p_doc_num IN PO_HEADERS.segment1%TYPE,
595: p_release_id IN NUMBER,
596: p_release_num IN NUMBER,
597: p_doc_line_id IN NUMBER,
598: p_doc_line_num IN NUMBER,

Line 602: p_agent_id IN PO_HEADERS.agent_id%TYPE,

598: p_doc_line_num IN NUMBER,
599: p_doc_line_loc_id IN NUMBER,
600: p_doc_shipment_num IN NUMBER,
601: p_action IN VARCHAR2,
602: p_agent_id IN PO_HEADERS.agent_id%TYPE,
603: x_return_status OUT NOCOPY VARCHAR2)
604: IS
605:
606: l_api_name CONSTANT VARCHAR2(30) := 'validate_control_action';

Line 725: p_doc_num IN PO_HEADERS.segment1%TYPE,

721: x_return_status OUT NOCOPY VARCHAR2,
722: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
723: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
724: p_doc_id IN NUMBER,
725: p_doc_num IN PO_HEADERS.segment1%TYPE,
726: p_release_id IN NUMBER,
727: p_release_num IN NUMBER,
728: p_doc_line_id IN NUMBER,
729: p_doc_line_num IN NUMBER,

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

735: l_api_name CONSTANT VARCHAR2(30) := 'val_control_action';
736: l_api_version CONSTANT NUMBER := 1.0;
737:
738: -- Apps context should be initialized, so we can get the employee id directly
739: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;
740:
741: BEGIN
742: -- Start standard API initialization
743: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 834: p_doc_num IN PO_HEADERS.segment1%TYPE,

830: x_return_status OUT NOCOPY VARCHAR2,
831: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
832: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
833: p_doc_id IN NUMBER,
834: p_doc_num IN PO_HEADERS.segment1%TYPE,
835: p_release_id IN NUMBER,
836: p_release_num IN NUMBER,
837: p_doc_line_id IN NUMBER,
838: p_doc_line_num IN NUMBER,

Line 926: p_doc_num IN PO_HEADERS.segment1%TYPE,

922: PROCEDURE val_po_params
923: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
924: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
925: p_doc_id IN NUMBER,
926: p_doc_num IN PO_HEADERS.segment1%TYPE,
927: p_doc_line_id IN NUMBER,
928: p_doc_line_num IN NUMBER,
929: p_doc_line_loc_id IN NUMBER,
930: p_doc_shipment_num IN NUMBER,

Line 986: FROM po_headers poh

982: -- Derive header
983: IF (p_doc_id IS NULL) THEN
984: SELECT poh.po_header_id
985: INTO x_doc_id
986: FROM po_headers poh
987: WHERE poh.segment1 = p_doc_num AND
988: poh.type_lookup_code = p_doc_subtype;
989: ELSE
990: SELECT poh.po_header_id

Line 992: FROM po_headers poh

988: poh.type_lookup_code = p_doc_subtype;
989: ELSE
990: SELECT poh.po_header_id
991: INTO x_doc_id
992: FROM po_headers poh
993: WHERE poh.po_header_id = p_doc_id;
994: END IF;
995:
996: IF (g_fnd_debug = 'Y') THEN

Line 1116: p_doc_num IN PO_HEADERS.segment1%TYPE,

1112: PROCEDURE val_rel_params
1113: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
1114: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
1115: p_doc_id IN NUMBER,
1116: p_doc_num IN PO_HEADERS.segment1%TYPE,
1117: p_release_id IN NUMBER,
1118: p_release_num IN NUMBER,
1119: p_doc_line_loc_id IN NUMBER,
1120: p_doc_shipment_num IN NUMBER,

Line 1186: FROM po_headers poh,

1182: -- SQL Why: Need to derive the missing unique po_release_id
1183: -- SQL Join: po_header_id
1184: SELECT poh.po_header_id, por.po_release_id
1185: INTO l_release_po_header_id, x_doc_id
1186: FROM po_headers poh,
1187: po_releases por
1188: WHERE poh.segment1 = p_doc_num AND
1189: poh.type_lookup_code = l_release_po_subtype AND
1190: por.po_header_id = poh.po_header_id AND

Line 1198: FROM po_headers poh,

1194: -- SQL Why: Need to derive the missing unique po_release_id
1195: -- SQL Join: po_header_id
1196: SELECT poh.po_header_id, por.po_release_id
1197: INTO l_release_po_header_id, x_doc_id
1198: FROM po_headers poh,
1199: po_releases por
1200: WHERE poh.po_header_id = p_doc_id AND
1201: por.po_header_id = poh.po_header_id AND
1202: por.release_num = p_release_num;

Line 1304: p_doc_num IN PO_HEADERS.segment1%TYPE,

1300: x_return_status OUT NOCOPY VARCHAR2,
1301: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
1302: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
1303: p_doc_id IN NUMBER,
1304: p_doc_num IN PO_HEADERS.segment1%TYPE,
1305: p_release_id IN NUMBER,
1306: p_release_num IN NUMBER,
1307: p_doc_line_id IN NUMBER,
1308: p_doc_line_num IN NUMBER,