APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_LOOKUP_CODES

Line 1334: FROM po_lookup_codes polc,

1330: -- SQL What: Querying for control actions
1331: -- SQL Why: Find all allowable header level control actions for this doc
1332: SELECT polc.displayed_field,
1333: polc.lookup_code
1334: FROM po_lookup_codes polc,
1335: po_headers poh
1336: WHERE poh.po_header_id = p_doc_id
1337: AND polc.lookup_type = 'CONTROL ACTIONS'
1338: AND NVL(poh.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 1554: FROM po_lookup_codes polc,

1550: -- SQL What: Querying for control actions
1551: -- SQL Why: Find all allowable line level control actions for this doc
1552: SELECT polc.displayed_field,
1553: polc.lookup_code
1554: FROM po_lookup_codes polc,
1555: po_lines pol,
1556: po_headers poh
1557: WHERE pol.po_line_id = p_doc_line_id
1558: AND pol.po_header_id = poh.po_header_id

Line 1754: FROM po_lookup_codes polc,

1750: -- SQL What: Querying for control actions
1751: -- SQL Why: Find all allowable shipment level control actions for this doc
1752: SELECT polc.displayed_field,
1753: polc.lookup_code
1754: FROM po_lookup_codes polc,
1755: po_line_locations_all poll,
1756: po_headers_all poh
1757: WHERE poll.line_location_id = p_doc_line_loc_id
1758: AND poll.po_header_id = poh.po_header_id

Line 1959: FROM po_lookup_codes polc,

1955: -- SQL Why: Find all allowable release header level control actions for this
1956: -- release.
1957: SELECT polc.displayed_field,
1958: polc.lookup_code
1959: FROM po_lookup_codes polc,
1960: po_releases por
1961: WHERE por.po_release_id = p_doc_id
1962: AND polc.lookup_type = 'CONTROL ACTIONS'
1963: AND NVL(por.closed_code, 'OPEN') <> 'FINALLY CLOSED'

Line 2158: FROM po_lookup_codes polc,

2154: -- SQL Why: Find all allowable shipment level control actions for this
2155: -- release.
2156: SELECT polc.displayed_field,
2157: polc.lookup_code
2158: FROM po_lookup_codes polc,
2159: po_line_locations poll,
2160: po_releases por
2161: WHERE poll.line_location_id = p_doc_line_loc_id
2162: AND poll.po_release_id = por.po_release_id

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

2307: l_api_name CONSTANT VARCHAR2(30) := 'val_control_action';
2308: l_api_version CONSTANT NUMBER := 1.0;
2309: l_allowable_actions_tbl g_lookup_code_tbl_type; --< Bug 3194665 >
2310: l_displayed_field_tbl g_displayed_field_tbl_type; --< Bug 3194665 >
2311: l_action PO_LOOKUP_CODES.lookup_code%TYPE := p_action;
2312: l_action_ok BOOLEAN;
2313: l_current_entity_changed VARCHAR2(1); --
2314: --
2315: l_progress VARCHAR2(3) := '000';

Line 4202: l_control_action_disp_name PO_LOOKUP_CODES.displayed_field%type;

4198: l_msg_count NUMBER;
4199: l_msg_data VARCHAR2(2000);
4200: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;
4201: l_return_code VARCHAR2(25);
4202: l_control_action_disp_name PO_LOOKUP_CODES.displayed_field%type;
4203: d_pos NUMBER;
4204: l_api_name CONSTANT VARCHAR2(30) := 'do_control_action';
4205: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_Document_Control_PVT.do_control_action';
4206: BEGIN

Line 4237: FROM PO_LOOKUP_CODES

4233:
4234: d_pos := 15;
4235: SELECT displayed_field
4236: INTO l_control_action_disp_name
4237: FROM PO_LOOKUP_CODES
4238: WHERE lookup_type = 'CONTROL ACTIONS'
4239: AND lookup_code = p_control_action;
4240:
4241: IF (PO_LOG.d_stmt) THEN

Line 5139: l_current_action PO_LOOKUP_CODES.lookup_code%TYPE;

5135: l_index NUMBER;
5136: l_agent_id NUMBER;
5137: l_item_id PO_LINES_ALL.item_Id%TYPE;
5138: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
5139: l_current_action PO_LOOKUP_CODES.lookup_code%TYPE;
5140: l_mode VARCHAR2(30);
5141: l_ship_invalid_for_ctrl_actn VARCHAR2(1) := 'N';
5142: d_pos NUMBER;
5143: l_api_name CONSTANT VARCHAR2(30) := 'get_valid_control_actions';