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 927: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

923: PROCEDURE init_action_date
924: (p_api_version IN NUMBER,
925: p_init_msg_list IN VARCHAR2,
926: x_return_status OUT NOCOPY VARCHAR2,
927: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
928: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
929: p_doc_id IN NUMBER,
930: x_action_date IN OUT NOCOPY DATE,
931: x_cbc_enabled OUT NOCOPY VARCHAR2)

Line 928: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

924: (p_api_version IN NUMBER,
925: p_init_msg_list IN VARCHAR2,
926: x_return_status OUT NOCOPY VARCHAR2,
927: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
928: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
929: p_doc_id IN NUMBER,
930: x_action_date IN OUT NOCOPY DATE,
931: x_cbc_enabled OUT NOCOPY VARCHAR2)
932: IS

Line 1041: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

1037: PROCEDURE get_action_date
1038: (p_api_version IN NUMBER,
1039: p_init_msg_list IN VARCHAR2,
1040: x_return_status OUT NOCOPY VARCHAR2,
1041: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
1042: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
1043: p_doc_id IN NUMBER,
1044: p_cbc_enabled IN VARCHAR2,
1045: x_action_date OUT NOCOPY DATE)

Line 1042: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

1038: (p_api_version IN NUMBER,
1039: p_init_msg_list IN VARCHAR2,
1040: x_return_status OUT NOCOPY VARCHAR2,
1041: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
1042: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
1043: p_doc_id IN NUMBER,
1044: p_cbc_enabled IN VARCHAR2,
1045: x_action_date OUT NOCOPY DATE)
1046: IS

Line 1149: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

1145: PROCEDURE val_action_date
1146: (p_api_version IN NUMBER,
1147: p_init_msg_list IN VARCHAR2,
1148: x_return_status OUT NOCOPY VARCHAR2,
1149: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
1150: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
1151: p_doc_id IN NUMBER,
1152: p_action IN VARCHAR2,
1153: p_action_date IN DATE,

Line 1150: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

1146: (p_api_version IN NUMBER,
1147: p_init_msg_list IN VARCHAR2,
1148: x_return_status OUT NOCOPY VARCHAR2,
1149: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
1150: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
1151: p_doc_id IN NUMBER,
1152: p_action IN VARCHAR2,
1153: p_action_date IN DATE,
1154: p_cbc_enabled IN VARCHAR2,

Line 1374: FROM po_document_types podt

1370: AND NVL(poh.conterms_exist_flag, 'N') <> 'Y' /* */
1371: AND ( (p_agent_id IS NULL)
1372: OR (poh.agent_id = p_agent_id)
1373: OR EXISTS (SELECT 'security_level is full'
1374: FROM po_document_types podt
1375: WHERE podt.document_type_code IN ('PO', 'PA')
1376: AND podt.document_subtype = p_doc_subtype
1377: AND podt.access_level_code = 'FULL')
1378: )

Line 1388: FROM po_document_types podt

1384: OR ( polc.lookup_code = 'FINALLY CLOSE'
1385: AND ( (p_agent_id IS NULL)
1386: OR (poh.agent_id = p_agent_id)
1387: OR EXISTS (SELECT 'security_level = full'
1388: FROM po_document_types podt
1389: WHERE podt.document_type_code IN ('PO', 'PA')
1390: AND podt.document_subtype = p_doc_subtype
1391: AND podt.access_level_code = 'FULL')
1392: )

Line 1576: FROM po_document_types podt

1572: AND NVL(poh.conterms_exist_flag, 'N') <> 'Y' /* */
1573: AND ( (p_agent_id IS NULL)
1574: OR (poh.agent_id = p_agent_id)
1575: OR EXISTS (SELECT 'security_level is full'
1576: FROM po_document_types podt
1577: WHERE podt.document_type_code IN ('PO', 'PA')
1578: AND podt.document_subtype = p_doc_subtype
1579: AND podt.access_level_code = 'FULL')
1580: )

Line 1590: FROM po_document_types podt

1586: OR ( polc.lookup_code = 'FINALLY CLOSE'
1587: AND ( (p_agent_id IS NULL)
1588: OR (poh.agent_id = p_agent_id)
1589: OR EXISTS (SELECT 'security_level is= full'
1590: FROM po_document_types podt
1591: WHERE podt.document_type_code IN ('PO', 'PA')
1592: AND podt.document_subtype = p_doc_subtype
1593: AND podt.access_level_code = 'FULL')
1594: )

Line 1781: FROM po_document_types_all_b podt

1777: AND NVL(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED')
1778: AND ( (p_agent_id IS NULL)
1779: OR (poh.agent_id = p_agent_id)
1780: OR EXISTS (SELECT 'security_level is full'
1781: FROM po_document_types_all_b podt
1782: WHERE podt.document_type_code = p_doc_type
1783: AND podt.document_subtype = p_doc_subtype
1784: AND podt.access_level_code = 'FULL'
1785: AND podt.org_id = poh.org_id)

Line 1807: FROM po_document_types_all_b podt

1803: OR ( polc.lookup_code = 'FINALLY CLOSE'
1804: AND ( (p_agent_id IS NULL)
1805: OR (poh.agent_id = p_agent_id)
1806: OR EXISTS (SELECT 'security_level is full'
1807: FROM po_document_types_all_b podt
1808: WHERE podt.document_type_code = p_doc_type
1809: AND podt.document_subtype = p_doc_subtype
1810: AND podt.access_level_code = 'FULL'
1811: AND podt.org_id = poh.org_id)

Line 1998: FROM po_document_types podt

1994: ('IN PROCESS', 'PRE-APPROVED', 'INCOMPLETE')
1995: AND ( (p_agent_id IS NULL)
1996: OR (por.agent_id = p_agent_id)
1997: OR EXISTS (SELECT 'security_level is full'
1998: FROM po_document_types podt
1999: WHERE podt.document_type_code = 'RELEASE'
2000: AND podt.document_subtype = p_doc_subtype
2001: AND podt.access_level_code = 'FULL')
2002: )

Line 2012: FROM po_document_types podt

2008: OR ( polc.lookup_code = 'FINALLY CLOSE'
2009: AND ( (p_agent_id IS NULL)
2010: OR (por.agent_id = p_agent_id)
2011: OR EXISTS (SELECT 'security_level is full'
2012: FROM po_document_types podt
2013: WHERE podt.document_type_code = 'RELEASE'
2014: AND podt.document_subtype = p_doc_subtype
2015: AND podt.access_level_code = 'FULL')
2016: )

Line 2178: FROM po_document_types podt

2174: AND NVL(poll.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED')
2175: AND ( (p_agent_id IS NULL)
2176: OR (por.agent_id = p_agent_id)
2177: OR EXISTS (SELECT 'security_level is full'
2178: FROM po_document_types podt
2179: WHERE podt.document_type_code = 'RELEASE'
2180: AND podt.document_subtype = p_doc_subtype
2181: AND podt.access_level_code = 'FULL')
2182: )

Line 2193: FROM po_document_types podt

2189: OR ( polc.lookup_code = 'FINALLY CLOSE'
2190: AND ( (p_agent_id IS NULL)
2191: OR (por.agent_id = p_agent_id)
2192: OR EXISTS(SELECT 'security_level is full'
2193: FROM po_document_types podt
2194: WHERE podt.document_type_code = 'RELEASE'
2195: AND podt.document_subtype = p_doc_subtype
2196: AND podt.access_level_code = 'FULL')
2197: )

Line 2297: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

2293: PROCEDURE val_control_action
2294: (p_api_version IN NUMBER,
2295: p_init_msg_list IN VARCHAR2,
2296: x_return_status OUT NOCOPY VARCHAR2,
2297: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2298: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
2299: p_doc_id IN NUMBER,
2300: p_doc_line_id IN NUMBER,
2301: p_doc_line_loc_id IN NUMBER,

Line 2298: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

2294: (p_api_version IN NUMBER,
2295: p_init_msg_list IN VARCHAR2,
2296: x_return_status OUT NOCOPY VARCHAR2,
2297: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2298: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%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,

Line 2598: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

2594: PROCEDURE po_stop_wf_process
2595: (p_api_version IN NUMBER,
2596: p_init_msg_list IN VARCHAR2,
2597: x_return_status OUT NOCOPY VARCHAR2,
2598: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2599: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
2600: p_doc_id IN NUMBER)
2601: IS
2602:

Line 2599: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

2595: (p_api_version IN NUMBER,
2596: p_init_msg_list IN VARCHAR2,
2597: x_return_status OUT NOCOPY VARCHAR2,
2598: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2599: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
2600: p_doc_id IN NUMBER)
2601: IS
2602:
2603: CURSOR l_po_wf_csr IS

Line 2770: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

2766: PROCEDURE rel_stop_wf_process
2767: (p_api_version IN NUMBER,
2768: p_init_msg_list IN VARCHAR2,
2769: x_return_status OUT NOCOPY VARCHAR2,
2770: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2771: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
2772: p_doc_id IN NUMBER)
2773: IS
2774:

Line 2771: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

2767: (p_api_version IN NUMBER,
2768: p_init_msg_list IN VARCHAR2,
2769: x_return_status OUT NOCOPY VARCHAR2,
2770: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
2771: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
2772: p_doc_id IN NUMBER)
2773: IS
2774:
2775: CURSOR l_rel_wf_csr IS

Line 3190: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

3186: PROCEDURE create_print_request
3187: (p_api_version IN NUMBER,
3188: p_init_msg_list IN VARCHAR2,
3189: x_return_status OUT NOCOPY VARCHAR2,
3190: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
3191: p_doc_num IN VARCHAR2,
3192: p_rel_doc_num IN VARCHAR2,
3193: x_request_id OUT NOCOPY NUMBER)
3194: IS

Line 3305: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

3301: (p_api_version IN NUMBER,
3302: p_init_msg_list IN VARCHAR2,
3303: p_commit IN VARCHAR2,
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

Line 3488: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

3484: FUNCTION pass_security_check
3485: (p_api_version IN NUMBER,
3486: p_init_msg_list IN VARCHAR2,
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

Line 3489: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

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

Line 3578: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

3574: FUNCTION has_shipments
3575: (p_api_version IN NUMBER,
3576: p_init_msg_list IN VARCHAR2,
3577: x_return_status OUT NOCOPY VARCHAR2,
3578: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
3579: p_doc_id IN NUMBER)
3580: RETURN BOOLEAN
3581: IS
3582:

Line 3693: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

3689: FUNCTION has_unencumbered_shipments
3690: (p_api_version IN NUMBER,
3691: p_init_msg_list IN VARCHAR2,
3692: x_return_status OUT NOCOPY VARCHAR2,
3693: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
3694: p_doc_id IN NUMBER)
3695: RETURN BOOLEAN
3696: IS
3697: