APPS.IEC_VALIDATE_PVT dependencies on IEC_G_REP_SUBSET_COUNTS

Line 3090: -- Create/Update subset records in IEC_G_REP_SUBSET_COUNTS

3086: BEGIN
3087:
3088:
3089:
3090: -- Create/Update subset records in IEC_G_REP_SUBSET_COUNTS
3091:
3092: IF p_subset_id_col IS NOT NULL AND p_subset_id_col.COUNT > 0 THEN
3093:
3094:

Line 3106: FROM IEC_G_REP_SUBSET_COUNTS

3102: EXECUTE IMMEDIATE
3103:
3104: 'SELECT COUNT(*)
3105:
3106: FROM IEC_G_REP_SUBSET_COUNTS
3107:
3108: WHERE SUBSET_ID = :subset_id'
3109:
3110: INTO l_rec_count

Line 3124: 'INSERT INTO IEC_G_REP_SUBSET_COUNTS

3120:
3121:
3122: EXECUTE IMMEDIATE
3123:
3124: 'INSERT INTO IEC_G_REP_SUBSET_COUNTS
3125:
3126: ( SUBSET_COUNT_ID
3127:
3128: , CAMPAIGN_ID

Line 3162: (IEC_G_REP_SUBSET_COUNTS_S.NEXTVAL

3158: )
3159:
3160: VALUES
3161:
3162: (IEC_G_REP_SUBSET_COUNTS_S.NEXTVAL
3163:
3164: , :campaign_id
3165:
3166: , :schedule_id

Line 3214: 'UPDATE IEC_G_REP_SUBSET_COUNTS

3210: -- If record exists, simply update counts by appropriate increment
3211:
3212: EXECUTE IMMEDIATE
3213:
3214: 'UPDATE IEC_G_REP_SUBSET_COUNTS
3215:
3216: SET RECORD_LOADED = RECORD_LOADED + :records_loaded
3217:
3218: , LAST_UPDATE_DATE = SYSDATE

Line 5054: UPDATE IEC_G_REP_SUBSET_COUNTS

5050: IF p_subset_id_col.COUNT > 0 THEN
5051:
5052: FORALL i IN p_subset_id_col.FIRST..p_subset_id_col.LAST
5053:
5054: UPDATE IEC_G_REP_SUBSET_COUNTS
5055:
5056: SET RECORD_LOADED = NVL(RECORD_LOADED, 0) + p_incr_amount_col(i)
5057:
5058: WHERE SCHEDULE_ID = p_schedule_id

Line 10968: FROM IEC_G_REP_SUBSET_COUNTS A,

10964: LIST_HEADER_ID = p_list_id;
10965:
10966: SELECT SUM(NVL(A.RECORD_LOADED, 0))
10967: into l_valid_count
10968: FROM IEC_G_REP_SUBSET_COUNTS A,
10969: IEC_G_LIST_SUBSETS D
10970: where A.SUBSET_ID = D.LIST_SUBSET_ID AND
10971: D.LIST_HEADER_ID = p_list_id AND D.STATUS_CODE <> 'DELETED';
10972:

Line 15952: FROM IEC_G_REP_SUBSET_COUNTS

15948: EXECUTE IMMEDIATE
15949:
15950: 'SELECT COUNT(*)
15951:
15952: FROM IEC_G_REP_SUBSET_COUNTS
15953:
15954: WHERE LIST_HEADER_ID = :list_id'
15955:
15956: INTO l_count