APPS.ICX_REQ_NAVIGATION dependencies on PO_REQUISITION_HEADERS

Line 1022: select PO_REQUISITION_HEADERS_S.nextval from sys.dual;

1018: -- cursor getCartId is
1019: -- select icx_shopping_Carts_s.nextval from sys.dual;
1020: --new code:
1021: cursor getCartId is
1022: select PO_REQUISITION_HEADERS_S.nextval from sys.dual;
1023:
1024:
1025: cursor getDate(increment number) is
1026: SELECT sysdate+increment from sys.dual;

Line 1127: WHERE table_name = 'PO_REQUISITION_HEADERS'

1123: sysdate,
1124: icx_cart_distributions_s.nextval
1125: INTO v_req_num, v_sysdate, v_dist_id
1126: FROM po_unique_identifier_control
1127: WHERE table_name = 'PO_REQUISITION_HEADERS'
1128: FOR UPDATE OF current_max_unique_identifier;
1129:
1130: UPDATE po_unique_identifier_control
1131: SET current_max_unique_identifier =

Line 1133: WHERE table_name = 'PO_REQUISITION_HEADERS';

1129:
1130: UPDATE po_unique_identifier_control
1131: SET current_max_unique_identifier =
1132: current_max_unique_identifier+1
1133: WHERE table_name = 'PO_REQUISITION_HEADERS';
1134:
1135: commit;
1136:
1137: OPEN getDate(nvl(icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY), 0));

Line 1316: from po_requisition_headers

1312: -- select header_attribute7
1313: -- from po_requisitions_interface
1314: -- where requisition_header_id = reqheader;
1315: select attribute7
1316: from po_requisition_headers
1317: where requisition_header_id = reqheader;
1318:
1319: cursor reqlines(reqheader number) is
1320: select requisition_line_id

Line 1382: from po_requisition_headers

1378:
1379: -- get the preparer,
1380: select preparer_id, authorization_status
1381: into v_preparer_id, v_req_status
1382: from po_requisition_headers
1383: where requisition_header_id = v_req_header_id;
1384:
1385: ICX_REQ_NAVIGATION.shopper_info(v_preparer_id,l_shopper_name,l_location_id,l_location_code,l_org_id,l_org_code);
1386:

Line 1427: WHERE table_name = 'PO_REQUISITION_HEADERS'

1423:
1424: select to_char(current_max_unique_identifier +1)
1425: into v_req_num
1426: from po_unique_identifier_control
1427: WHERE table_name = 'PO_REQUISITION_HEADERS'
1428: FOR UPDATE OF current_max_unique_identifier;
1429:
1430: UPDATE po_unique_identifier_control
1431: SET current_max_unique_identifier = current_max_unique_identifier+1

Line 1432: WHERE table_name = 'PO_REQUISITION_HEADERS';

1428: FOR UPDATE OF current_max_unique_identifier;
1429:
1430: UPDATE po_unique_identifier_control
1431: SET current_max_unique_identifier = current_max_unique_identifier+1
1432: WHERE table_name = 'PO_REQUISITION_HEADERS';
1433:
1434: commit;
1435:
1436: -- get some req line info

Line 1473: select PO_REQUISITION_HEADERS_S.nextval

1469: -- select icx_shopping_carts_s.nextval
1470: -- into v_cart_id
1471: -- from sys.dual;
1472: --new code:
1473: select PO_REQUISITION_HEADERS_S.nextval
1474: into v_cart_id
1475: from sys.dual;
1476:
1477:

Line 1558: from po_requisition_headers rh

1554: l_emer,
1555: l_location_code,
1556: l_shopper_name,
1557: v_org_id
1558: from po_requisition_headers rh
1559: where requisition_header_id = v_req_header_id;
1560:
1561: --add by alex
1562: --copy attachment for the header

Line 1563: fnd_attached_documents2_pkg.copy_attachments('PO_REQUISITION_HEADERS',

1559: where requisition_header_id = v_req_header_id;
1560:
1561: --add by alex
1562: --copy attachment for the header
1563: fnd_attached_documents2_pkg.copy_attachments('PO_REQUISITION_HEADERS',
1564: v_req_header_id,
1565: '',
1566: '',
1567: '',

Line 1569: 'PO_REQUISITION_HEADERS',

1565: '',
1566: '',
1567: '',
1568: '',
1569: 'PO_REQUISITION_HEADERS',
1570: v_cart_id,
1571: '',
1572: '',
1573: '',

Line 1600: from po_requisition_headers rh

1596: rh.created_by,
1597: sysdate,
1598: rh.created_by,
1599: v_org_id
1600: from po_requisition_headers rh
1601: where requisition_header_id = v_req_header_id;
1602:
1603:
1604: -- for line_id, insert po_lines.po_line_id if possible; otherwise,