');
Line 671: from pos_asn_shop_cart_headers
667: select ship_to_organization_id,
668: ship_to_location_id
669: into l_first_org_id,
670: l_first_loc_id
671: from pos_asn_shop_cart_headers
672: where session_id = l_session_id;
673: exception
674: when others then
675: null;
Line 699: pos_asn_search_pkg.search_page('N', 'ICX_POS_ASN_DIFF_ORG', pos_start_row);
695: end if;
696:
697: if l_first_org_id <> l_ship_to_org_id then
698: if pos_submit = 'NEXT' then
699: pos_asn_search_pkg.search_page('N', 'ICX_POS_ASN_DIFF_ORG', pos_start_row);
700: else
701: ShowResult(to_number(pos_start_row), 'ICX_POS_ASN_DIFF_ORG');
702: end if;
703: return;
Line 701: ShowResult(to_number(pos_start_row), 'ICX_POS_ASN_DIFF_ORG');
697: if l_first_org_id <> l_ship_to_org_id then
698: if pos_submit = 'NEXT' then
699: pos_asn_search_pkg.search_page('N', 'ICX_POS_ASN_DIFF_ORG', pos_start_row);
700: else
701: ShowResult(to_number(pos_start_row), 'ICX_POS_ASN_DIFF_ORG');
702: end if;
703: return;
704: end if;
705:
Line 708: pos_asn_search_pkg.search_page('N', 'ICX_POS_ASN_DIFF_LOC', pos_start_row);
704: end if;
705:
706: if l_first_loc_id <> l_ship_to_loc_id then
707: if pos_submit = 'NEXT' then
708: pos_asn_search_pkg.search_page('N', 'ICX_POS_ASN_DIFF_LOC', pos_start_row);
709: else
710: ShowResult(to_number(pos_start_row), 'ICX_POS_ASN_DIFF_LOC');
711: end if;
712: return;
Line 710: ShowResult(to_number(pos_start_row), 'ICX_POS_ASN_DIFF_LOC');
706: if l_first_loc_id <> l_ship_to_loc_id then
707: if pos_submit = 'NEXT' then
708: pos_asn_search_pkg.search_page('N', 'ICX_POS_ASN_DIFF_LOC', pos_start_row);
709: else
710: ShowResult(to_number(pos_start_row), 'ICX_POS_ASN_DIFF_LOC');
711: end if;
712: return;
713: end if;
714:
Line 723: from pos_asn_shop_cart_headers
719: -- if no, create a new ASN header.
720:
721: select count(1)
722: into l_header_count
723: from pos_asn_shop_cart_headers
724: where session_id = l_session_id;
725:
726: if l_header_count = 0 and pos_select.count > 0 then
727:
Line 743: insert into pos_asn_shop_cart_headers
739: po_headers poh
740: where poh.po_header_id = poll.po_header_id
741: and poll.line_location_id = l_po_shipment_id;
742:
743: insert into pos_asn_shop_cart_headers
744: (
745: SESSION_ID,
746: SHIP_TO_ORGANIZATION_ID,
747: SHIP_TO_LOCATION_ID,
Line 776: from pos_asn_shop_cart_details
772: FOR l_counter IN 1..pos_select.count LOOP
773:
774: select nvl(max(asn_line_id), 0) + 1
775: into l_asn_line_id
776: from pos_asn_shop_cart_details
777: where session_id = l_session_id;
778:
779: l_po_shipment_id := to_number(pos_po_shipment_id(to_number(pos_select(l_counter))));
780:
Line 794: insert into pos_asn_shop_cart_details
790: po_lines pol
791: where poll.line_location_id = l_po_shipment_id
792: and poll.po_line_id = pol.po_line_id;
793:
794: insert into pos_asn_shop_cart_details
795: (
796: SESSION_ID,
797: ASN_LINE_ID,
798: PO_LINE_LOCATION_ID,
Line 834: pos_asn.show_edit_page;
830:
831: -- If pos_submit = 'NEXT', means go to next page.
832:
833: if pos_submit = 'NEXT' then
834: pos_asn.show_edit_page;
835: else
836: ShowResult(to_number(pos_start_row));
837: end if;
838:
Line 855: delete pos_asn_search_result where session_id = p_session_id;
851: result NUMBER;
852:
853: BEGIN
854:
855: delete pos_asn_search_result where session_id = p_session_id;
856:
857: v_cursor_id := DBMS_SQL.open_cursor;
858:
859: v_stmt :=
Line 860: 'insert into pos_asn_search_result select ' || to_char(p_session_id) || ',
856:
857: v_cursor_id := DBMS_SQL.open_cursor;
858:
859: v_stmt :=
860: 'insert into pos_asn_search_result select ' || to_char(p_session_id) || ',
861: PO_HEADER_ID,
862: PO_NUMBER,
863: PO_RELEASE_ID,
864: PO_LINE_ID,
Line 887: from POS_ASN_PO_SHIPMENTS_V
883: ITEM_NUMBER,
884: ITEM_REVISION,
885: CATEGORY_ID,
886: CATEGORY
887: from POS_ASN_PO_SHIPMENTS_V
888: where ' || p_where_clause;
889:
890: DBMS_SQL.parse(v_cursor_id, v_stmt, dbms_sql.native);
891:
Line 976: p_parent_region_code=>'POS_ASN_SEARCH_R',
972:
973: BEGIN
974:
975: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
976: p_parent_region_code=>'POS_ASN_SEARCH_R',
977: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
978: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
979: p_return_parents=>'F',
980: p_return_children=>'F');
Line 1124: p_parent_region_code=>'POS_ASN_ADV_SEARCH_R',
1120:
1121: BEGIN
1122:
1123: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
1124: p_parent_region_code=>'POS_ASN_ADV_SEARCH_R',
1125: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1126: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1127: p_return_parents=>'F',
1128: p_return_children=>'F');
Line 1281: htp.p(' ');
Line 1302: from POS_ASN_SHOP_CART_DETAILS
1298: end if;
1299:
1300: select decode(count(1), 0, 'Y', 'N')
1301: into l_empty_cart
1302: from POS_ASN_SHOP_CART_DETAILS
1303: where session_id = l_session_id;
1304:
1305: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
1306: p_parent_region_code=>'POS_ASN_RESULT_R',
Line 1306: p_parent_region_code=>'POS_ASN_RESULT_R',
1302: from POS_ASN_SHOP_CART_DETAILS
1303: where session_id = l_session_id;
1304:
1305: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
1306: p_parent_region_code=>'POS_ASN_RESULT_R',
1307: p_where_clause=>l_where_clause,
1308: p_responsibility_id=>icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1309: p_user_id=>icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1310: p_return_parents=>'T',
Line 1325: htp.p(' ');
1321: end if;
1322:
1323: htp.p('
');
1324:
1325: htp.p('');
1326:
1327: htp.p(' ');
1328: htp.p(' ');
1329:
Line 1360: from pos_asn_shop_cart_details
1356: l_shipment_id := to_number(get_result_value(l_result_index, 1));
1357:
1358: select count(1)
1359: into l_in_cart
1360: from pos_asn_shop_cart_details
1361: where session_id = l_session_id
1362: and po_line_location_id = l_shipment_id;
1363:
1364: if l_in_cart = 0 then
Line 1722: where REGION_CODE = 'POS_ASN_SEARCH_R'
1718:
1719: select REQUIRED_FLAG
1720: into l_required_flag
1721: from ak_region_items
1722: where REGION_CODE = 'POS_ASN_SEARCH_R'
1723: and ATTRIBUTE_CODE = p_attribute_code;
1724:
1725: return(l_required_flag);
1726:
Line 1734: END pos_asn_search_pkg;
1730: return('N');
1731:
1732: end;
1733:
1734: END pos_asn_search_pkg;