APPS.POS_ASN_SEARCH_PKG dependencies on POS_ASN_SEARCH_RESULT

Line 90: delete pos_asn_search_result where session_id = l_session_id;

86:
87:
88: if p_start_row = 0 then
89:
90: delete pos_asn_search_result where session_id = l_session_id;
91: commit;
92:
93: end if;
94:

Line 525: delete pos_asn_search_result where session_id = l_session_id;

521: EXCEPTION
522:
523: when others then
524:
525: delete pos_asn_search_result where session_id = l_session_id;
526: commit;
527:
528: ShowResult(p_start_row, fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
529:

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,