APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_LOOKUP_CODES

Line 1172: FROM po_lookup_codes polc,

1168: -- SQL What: Querying for control actions
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'

Line 1393: FROM po_lookup_codes polc,

1389: -- SQL What: Querying for control actions
1390: -- SQL Why: Find all allowable line level control actions for this doc
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

Line 1594: FROM po_lookup_codes polc,

1590: -- SQL What: Querying for control actions
1591: -- SQL Why: Find all allowable shipment level control actions for this doc
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

Line 1810: FROM po_lookup_codes polc,

1806: -- SQL Why: Find all allowable release header level control actions for this
1807: -- release.
1808: SELECT polc.displayed_field,
1809: polc.lookup_code
1810: FROM po_lookup_codes polc,
1811: po_releases por
1812: WHERE por.po_release_id = p_doc_id
1813: AND polc.lookup_type = 'CONTROL ACTIONS'
1814: AND NVL(por.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 2010: FROM po_lookup_codes polc,

2006: -- SQL Why: Find all allowable shipment level control actions for this
2007: -- release.
2008: SELECT polc.displayed_field,
2009: polc.lookup_code
2010: FROM po_lookup_codes polc,
2011: po_line_locations poll,
2012: po_releases por
2013: WHERE poll.line_location_id = p_doc_line_loc_id
2014: AND poll.po_release_id = por.po_release_id

Line 2164: l_action PO_LOOKUP_CODES.lookup_code%TYPE := p_action;

2160: l_api_name CONSTANT VARCHAR2(30) := 'val_control_action';
2161: l_api_version CONSTANT NUMBER := 1.0;
2162: l_allowable_actions_tbl g_lookup_code_tbl_type; --< Bug 3194665 >
2163: l_displayed_field_tbl g_displayed_field_tbl_type; --< Bug 3194665 >
2164: l_action PO_LOOKUP_CODES.lookup_code%TYPE := p_action;
2165: l_action_ok BOOLEAN;
2166: l_current_entity_changed VARCHAR2(1); --
2167: --
2168: l_progress VARCHAR2(3) := '000';

Line 4041: l_control_action_disp_name PO_LOOKUP_CODES.displayed_field%type;

4037: l_msg_count NUMBER;
4038: l_msg_data VARCHAR2(2000);
4039: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;
4040: l_return_code VARCHAR2(25);
4041: l_control_action_disp_name PO_LOOKUP_CODES.displayed_field%type;
4042: d_pos NUMBER;
4043: l_api_name CONSTANT VARCHAR2(30) := 'do_control_action';
4044: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.do_control_action';
4045: BEGIN

Line 4076: FROM PO_LOOKUP_CODES

4072:
4073: d_pos := 15;
4074: SELECT displayed_field
4075: INTO l_control_action_disp_name
4076: FROM PO_LOOKUP_CODES
4077: WHERE lookup_type = 'CONTROL ACTIONS'
4078: AND lookup_code = p_control_action;
4079:
4080: IF (PO_LOG.d_stmt) THEN

Line 4965: l_current_action PO_LOOKUP_CODES.lookup_code%TYPE;

4961: l_index NUMBER;
4962: l_agent_id NUMBER;
4963: l_item_id PO_LINES_ALL.item_Id%TYPE;
4964: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
4965: l_current_action PO_LOOKUP_CODES.lookup_code%TYPE;
4966: l_mode VARCHAR2(30);
4967: l_ship_invalid_for_ctrl_actn VARCHAR2(1) := 'N';
4968: d_pos NUMBER;
4969: l_api_name CONSTANT VARCHAR2(30) := 'get_valid_control_actions';