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_DOCUMENT_TYPES

Line 29: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

25: */
26: PROCEDURE lock_doc_row
27: (p_api_version IN NUMBER,
28: x_return_status OUT NOCOPY VARCHAR2,
29: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
30: p_doc_id IN NUMBER)
31: IS
32:
33: l_api_name CONSTANT VARCHAR2(30) := 'lock_doc_row';

Line 309: FROM po_document_types podt

305: l_progress := '005' ;
306:
307: SELECT podt.default_approval_path_id
308: INTO l_approval_path_id
309: FROM po_document_types podt
310: WHERE podt.document_type_code = p_doc_type
311: AND podt.document_subtype = p_doc_subtype;
312:
313: IF g_debug_stmt THEN

Line 765: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

761: PROCEDURE init_action_date
762: (p_api_version IN NUMBER,
763: p_init_msg_list IN VARCHAR2,
764: x_return_status OUT NOCOPY VARCHAR2,
765: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
766: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
767: p_doc_id IN NUMBER,
768: x_action_date IN OUT NOCOPY DATE,
769: x_cbc_enabled OUT NOCOPY VARCHAR2)

Line 766: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

762: (p_api_version IN NUMBER,
763: p_init_msg_list IN VARCHAR2,
764: x_return_status OUT NOCOPY VARCHAR2,
765: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
766: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
767: p_doc_id IN NUMBER,
768: x_action_date IN OUT NOCOPY DATE,
769: x_cbc_enabled OUT NOCOPY VARCHAR2)
770: IS

Line 879: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

875: PROCEDURE get_action_date
876: (p_api_version IN NUMBER,
877: p_init_msg_list IN VARCHAR2,
878: x_return_status OUT NOCOPY VARCHAR2,
879: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
880: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
881: p_doc_id IN NUMBER,
882: p_cbc_enabled IN VARCHAR2,
883: x_action_date OUT NOCOPY DATE)

Line 880: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

876: (p_api_version IN NUMBER,
877: p_init_msg_list IN VARCHAR2,
878: x_return_status OUT NOCOPY VARCHAR2,
879: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
880: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
881: p_doc_id IN NUMBER,
882: p_cbc_enabled IN VARCHAR2,
883: x_action_date OUT NOCOPY DATE)
884: IS

Line 987: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

983: PROCEDURE val_action_date
984: (p_api_version IN NUMBER,
985: p_init_msg_list IN VARCHAR2,
986: x_return_status OUT NOCOPY VARCHAR2,
987: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
988: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
989: p_doc_id IN NUMBER,
990: p_action IN VARCHAR2,
991: p_action_date IN DATE,

Line 988: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

984: (p_api_version IN NUMBER,
985: p_init_msg_list IN VARCHAR2,
986: x_return_status OUT NOCOPY VARCHAR2,
987: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
988: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
989: p_doc_id IN NUMBER,
990: p_action IN VARCHAR2,
991: p_action_date IN DATE,
992: p_cbc_enabled IN VARCHAR2,

Line 1213: FROM po_document_types podt

1209: -- AND NVL(poh.conterms_exist_flag, 'N') <> 'Y' /* */ --Bug 7309989
1210: AND ( (p_agent_id IS NULL)
1211: OR (poh.agent_id = p_agent_id)
1212: OR EXISTS (SELECT 'security_level is full'
1213: FROM po_document_types podt
1214: WHERE podt.document_type_code IN ('PO', 'PA')
1215: AND podt.document_subtype = p_doc_subtype
1216: AND podt.access_level_code = 'FULL')
1217: )

Line 1227: FROM po_document_types podt

1223: OR ( polc.lookup_code = 'FINALLY CLOSE'
1224: AND ( (p_agent_id IS NULL)
1225: OR (poh.agent_id = p_agent_id)
1226: OR EXISTS (SELECT 'security_level = full'
1227: FROM po_document_types podt
1228: WHERE podt.document_type_code IN ('PO', 'PA')
1229: AND podt.document_subtype = p_doc_subtype
1230: AND podt.access_level_code = 'FULL')
1231: )

Line 1416: FROM po_document_types podt

1412: -- AND NVL(poh.conterms_exist_flag, 'N') <> 'Y' /* */ --Bug 7309989*/
1413: AND ( (p_agent_id IS NULL)
1414: OR (poh.agent_id = p_agent_id)
1415: OR EXISTS (SELECT 'security_level is full'
1416: FROM po_document_types podt
1417: WHERE podt.document_type_code IN ('PO', 'PA')
1418: AND podt.document_subtype = p_doc_subtype
1419: AND podt.access_level_code = 'FULL')
1420: )

Line 1430: FROM po_document_types podt

1426: OR ( polc.lookup_code = 'FINALLY CLOSE'
1427: AND ( (p_agent_id IS NULL)
1428: OR (poh.agent_id = p_agent_id)
1429: OR EXISTS (SELECT 'security_level is= full'
1430: FROM po_document_types podt
1431: WHERE podt.document_type_code IN ('PO', 'PA')
1432: AND podt.document_subtype = p_doc_subtype
1433: AND podt.access_level_code = 'FULL')
1434: )

Line 1632: FROM po_document_types_all_b podt

1628: AND NVL(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED')
1629: AND ( (p_agent_id IS NULL)
1630: OR (poh.agent_id = p_agent_id)
1631: OR EXISTS (SELECT 'security_level is full'
1632: FROM po_document_types_all_b podt
1633: WHERE podt.document_type_code = p_doc_type
1634: AND podt.document_subtype = p_doc_subtype
1635: AND podt.access_level_code = 'FULL'
1636: AND podt.org_id = poh.org_id)

Line 1658: FROM po_document_types_all_b podt

1654: OR ( polc.lookup_code = 'FINALLY CLOSE'
1655: AND ( (p_agent_id IS NULL)
1656: OR (poh.agent_id = p_agent_id)
1657: OR EXISTS (SELECT 'security_level is full'
1658: FROM po_document_types_all_b podt
1659: WHERE podt.document_type_code = p_doc_type
1660: AND podt.document_subtype = p_doc_subtype
1661: AND podt.access_level_code = 'FULL'
1662: AND podt.org_id = poh.org_id)

Line 1850: FROM po_document_types podt

1846: ('IN PROCESS', 'PRE-APPROVED', 'INCOMPLETE')
1847: AND ( (p_agent_id IS NULL)
1848: OR (por.agent_id = p_agent_id)
1849: OR EXISTS (SELECT 'security_level is full'
1850: FROM po_document_types podt
1851: WHERE podt.document_type_code = 'RELEASE'
1852: AND podt.document_subtype = p_doc_subtype
1853: AND podt.access_level_code = 'FULL')
1854: )

Line 1864: FROM po_document_types podt

1860: OR ( polc.lookup_code = 'FINALLY CLOSE'
1861: AND ( (p_agent_id IS NULL)
1862: OR (por.agent_id = p_agent_id)
1863: OR EXISTS (SELECT 'security_level is full'
1864: FROM po_document_types podt
1865: WHERE podt.document_type_code = 'RELEASE'
1866: AND podt.document_subtype = p_doc_subtype
1867: AND podt.access_level_code = 'FULL')
1868: )

Line 2031: FROM po_document_types podt

2027: AND NVL(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED')
2028: AND ( (p_agent_id IS NULL)
2029: OR (por.agent_id = p_agent_id)
2030: OR EXISTS (SELECT 'security_level is full'
2031: FROM po_document_types podt
2032: WHERE podt.document_type_code = 'RELEASE'
2033: AND podt.document_subtype = p_doc_subtype
2034: AND podt.access_level_code = 'FULL')
2035: )

Line 2046: FROM po_document_types podt

2042: OR ( polc.lookup_code = 'FINALLY CLOSE'
2043: AND ( (p_agent_id IS NULL)
2044: OR (por.agent_id = p_agent_id)
2045: OR EXISTS(SELECT 'security_level is full'
2046: FROM po_document_types podt
2047: WHERE podt.document_type_code = 'RELEASE'
2048: AND podt.document_subtype = p_doc_subtype
2049: AND podt.access_level_code = 'FULL')
2050: )

Line 2150: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

2146: PROCEDURE val_control_action
2147: (p_api_version IN NUMBER,
2148: p_init_msg_list IN VARCHAR2,
2149: x_return_status OUT NOCOPY VARCHAR2,
2150: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2151: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
2152: p_doc_id IN NUMBER,
2153: p_doc_line_id IN NUMBER,
2154: p_doc_line_loc_id IN NUMBER,

Line 2151: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

2147: (p_api_version IN NUMBER,
2148: p_init_msg_list IN VARCHAR2,
2149: x_return_status OUT NOCOPY VARCHAR2,
2150: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2151: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%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,

Line 2451: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

2447: PROCEDURE po_stop_wf_process
2448: (p_api_version IN NUMBER,
2449: p_init_msg_list IN VARCHAR2,
2450: x_return_status OUT NOCOPY VARCHAR2,
2451: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2452: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
2453: p_doc_id IN NUMBER)
2454: IS
2455:

Line 2452: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

2448: (p_api_version IN NUMBER,
2449: p_init_msg_list IN VARCHAR2,
2450: x_return_status OUT NOCOPY VARCHAR2,
2451: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2452: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
2453: p_doc_id IN NUMBER)
2454: IS
2455:
2456: CURSOR l_po_wf_csr IS

Line 2623: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

2619: PROCEDURE rel_stop_wf_process
2620: (p_api_version IN NUMBER,
2621: p_init_msg_list IN VARCHAR2,
2622: x_return_status OUT NOCOPY VARCHAR2,
2623: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2624: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
2625: p_doc_id IN NUMBER)
2626: IS
2627:

Line 2624: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

2620: (p_api_version IN NUMBER,
2621: p_init_msg_list IN VARCHAR2,
2622: x_return_status OUT NOCOPY VARCHAR2,
2623: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2624: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
2625: p_doc_id IN NUMBER)
2626: IS
2627:
2628: CURSOR l_rel_wf_csr IS

Line 3045: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

3041: PROCEDURE create_print_request
3042: (p_api_version IN NUMBER,
3043: p_init_msg_list IN VARCHAR2,
3044: x_return_status OUT NOCOPY VARCHAR2,
3045: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
3046: p_doc_num IN VARCHAR2,
3047: p_rel_doc_num IN VARCHAR2,
3048: x_request_id OUT NOCOPY NUMBER)
3049: IS

Line 3160: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

3156: (p_api_version IN NUMBER,
3157: p_init_msg_list IN VARCHAR2,
3158: p_commit IN VARCHAR2,
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

Line 3343: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

3339: FUNCTION pass_security_check
3340: (p_api_version IN NUMBER,
3341: p_init_msg_list IN VARCHAR2,
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

Line 3344: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

3340: (p_api_version IN NUMBER,
3341: p_init_msg_list IN VARCHAR2,
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

Line 3433: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

3429: FUNCTION has_shipments
3430: (p_api_version IN NUMBER,
3431: p_init_msg_list IN VARCHAR2,
3432: x_return_status OUT NOCOPY VARCHAR2,
3433: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
3434: p_doc_id IN NUMBER)
3435: RETURN BOOLEAN
3436: IS
3437:

Line 3548: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

3544: FUNCTION has_unencumbered_shipments
3545: (p_api_version IN NUMBER,
3546: p_init_msg_list IN VARCHAR2,
3547: x_return_status OUT NOCOPY VARCHAR2,
3548: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
3549: p_doc_id IN NUMBER)
3550: RETURN BOOLEAN
3551: IS
3552: