APPS.IEC_VALIDATE_PVT dependencies on AMS_LIST_HEADERS_ALL

Line 1909: FROM AMS_LIST_HEADERS_ALL

1905: EXECUTE IMMEDIATE
1906:
1907: 'SELECT LIST_SOURCE_TYPE
1908:
1909: FROM AMS_LIST_HEADERS_ALL
1910:
1911: WHERE LIST_HEADER_ID = :list_id'
1912:
1913: INTO l_source_type

Line 3632: AMS_LIST_HEADERS_ALL where list_header_id = p_list_id;

3628: G_LISTHEADER_REC_INITIAL := 1;
3629: END IF;
3630:
3631: 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
3632: AMS_LIST_HEADERS_ALL where list_header_id = p_list_id;
3633: l_listheader_rec.list_header_id := p_list_id;
3634: l_listheader_rec.no_of_rows_in_list := l_no_of_rows_in_list + p_rows_in_list_incr;
3635: l_listheader_rec.no_of_rows_active := l_no_of_rows_active + p_rows_active_incr;
3636:

Line 3652: 'UPDATE AMS_LIST_HEADERS_ALL

3648:
3649: /*
3650: EXECUTE IMMEDIATE
3651:
3652: 'UPDATE AMS_LIST_HEADERS_ALL
3653:
3654: SET NO_OF_ROWS_IN_LIST = NVL(NO_OF_ROWS_IN_LIST, 0) + :rows_incr
3655:
3656: , NO_OF_ROWS_ACTIVE = NVL(NO_OF_ROWS_ACTIVE, 0) + :active_incr

Line 10580: FROM AMS_LIST_HEADERS_ALL

10576: SELECT LIST_SOURCE_TYPE
10577:
10578: INTO l_list_source_type
10579:
10580: FROM AMS_LIST_HEADERS_ALL
10581:
10582: WHERE LIST_HEADER_ID = p_list_id;
10583:
10584:

Line 12959: 'UPDATE AMS_LIST_HEADERS_ALL

12955:
12956:
12957: EXECUTE IMMEDIATE
12958:
12959: 'UPDATE AMS_LIST_HEADERS_ALL
12960:
12961: SET NO_OF_ROWS_DUPLICATES = NVL(NO_OF_ROWS_DUPLICATES, 0) + :rows_incr
12962:
12963: WHERE LIST_HEADER_ID = :list_id'

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

16656: , LAST_UPDATED_BY = 0
16657:
16658: , LAST_UPDATE_DATE = SYSDATE
16659:
16660: WHERE LIST_HEADER_ID IN (SELECT LIST_HEADER_ID FROM AMS_LIST_HEADERS_ALL WHERE LIST_HEADER_ID = :list_id AND STATUS_CODE = ''EXECUTING'')
16661:
16662: AND EXECUTION_START_TIME IS NULL'
16663:
16664: USING p_list_id;