APPS.IEC_VALIDATE_PVT dependencies on AMS_LIST_HEADERS_ALL

Line 1891: FROM AMS_LIST_HEADERS_ALL

1887: EXECUTE IMMEDIATE
1888:
1889: 'SELECT LIST_SOURCE_TYPE
1890:
1891: FROM AMS_LIST_HEADERS_ALL
1892:
1893: WHERE LIST_HEADER_ID = :list_id'
1894:
1895: INTO l_source_type

Line 3610: AMS_LIST_HEADERS_ALL where list_header_id = p_list_id;

3606: G_LISTHEADER_REC_INITIAL := 1;
3607: END IF;
3608:
3609: select nvl(no_of_rows_in_list,0), nvl(no_of_rows_active,0) into l_no_of_rows_in_list, l_no_of_rows_active from
3610: AMS_LIST_HEADERS_ALL where list_header_id = p_list_id;
3611: l_listheader_rec.list_header_id := p_list_id;
3612: l_listheader_rec.no_of_rows_in_list := l_no_of_rows_in_list + p_rows_in_list_incr;
3613: l_listheader_rec.no_of_rows_active := l_no_of_rows_active + p_rows_active_incr;
3614:

Line 3630: 'UPDATE AMS_LIST_HEADERS_ALL

3626:
3627: /*
3628: EXECUTE IMMEDIATE
3629:
3630: 'UPDATE AMS_LIST_HEADERS_ALL
3631:
3632: SET NO_OF_ROWS_IN_LIST = NVL(NO_OF_ROWS_IN_LIST, 0) + :rows_incr
3633:
3634: , NO_OF_ROWS_ACTIVE = NVL(NO_OF_ROWS_ACTIVE, 0) + :active_incr

Line 10558: FROM AMS_LIST_HEADERS_ALL

10554: SELECT LIST_SOURCE_TYPE
10555:
10556: INTO l_list_source_type
10557:
10558: FROM AMS_LIST_HEADERS_ALL
10559:
10560: WHERE LIST_HEADER_ID = p_list_id;
10561:
10562:

Line 12937: 'UPDATE AMS_LIST_HEADERS_ALL

12933:
12934:
12935: EXECUTE IMMEDIATE
12936:
12937: 'UPDATE AMS_LIST_HEADERS_ALL
12938:
12939: SET NO_OF_ROWS_DUPLICATES = NVL(NO_OF_ROWS_DUPLICATES, 0) + :rows_incr
12940:
12941: WHERE LIST_HEADER_ID = :list_id'

Line 16638: WHERE LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM AMS_LIST_HEADERS_ALL WHERE LIST_HEADER_ID = :list_id AND STATUS_CODE = ''EXECUTING'')

16634: , LAST_UPDATED_BY = 0
16635:
16636: , LAST_UPDATE_DATE = SYSDATE
16637:
16638: WHERE LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM AMS_LIST_HEADERS_ALL WHERE LIST_HEADER_ID = :list_id AND STATUS_CODE = ''EXECUTING'')
16639:
16640: AND EXECUTION_START_TIME IS NULL'
16641:
16642: USING p_list_id;