APPS.IEC_VALIDATE_PVT dependencies on IEC_G_REP_SUBSET_COUNTS

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

3108: BEGIN
3109:
3110:
3111:
3112: -- Create/Update subset records in IEC_G_REP_SUBSET_COUNTS
3113:
3114: IF p_subset_id_col IS NOT NULL AND p_subset_id_col.COUNT > 0 THEN
3115:
3116:

Line 3128: FROM IEC_G_REP_SUBSET_COUNTS

3124: EXECUTE IMMEDIATE
3125:
3126: 'SELECT COUNT(*)
3127:
3128: FROM IEC_G_REP_SUBSET_COUNTS
3129:
3130: WHERE SUBSET_ID = :subset_id'
3131:
3132: INTO l_rec_count

Line 3146: 'INSERT INTO IEC_G_REP_SUBSET_COUNTS

3142:
3143:
3144: EXECUTE IMMEDIATE
3145:
3146: 'INSERT INTO IEC_G_REP_SUBSET_COUNTS
3147:
3148: ( SUBSET_COUNT_ID
3149:
3150: , CAMPAIGN_ID

Line 3184: (IEC_G_REP_SUBSET_COUNTS_S.NEXTVAL

3180: )
3181:
3182: VALUES
3183:
3184: (IEC_G_REP_SUBSET_COUNTS_S.NEXTVAL
3185:
3186: , :campaign_id
3187:
3188: , :schedule_id

Line 3236: 'UPDATE IEC_G_REP_SUBSET_COUNTS

3232: -- If record exists, simply update counts by appropriate increment
3233:
3234: EXECUTE IMMEDIATE
3235:
3236: 'UPDATE IEC_G_REP_SUBSET_COUNTS
3237:
3238: SET RECORD_LOADED = RECORD_LOADED + :records_loaded
3239:
3240: , LAST_UPDATE_DATE = SYSDATE

Line 5076: UPDATE IEC_G_REP_SUBSET_COUNTS

5072: IF p_subset_id_col.COUNT > 0 THEN
5073:
5074: FORALL i IN p_subset_id_col.FIRST..p_subset_id_col.LAST
5075:
5076: UPDATE IEC_G_REP_SUBSET_COUNTS
5077:
5078: SET RECORD_LOADED = NVL(RECORD_LOADED, 0) + p_incr_amount_col(i)
5079:
5080: WHERE SCHEDULE_ID = p_schedule_id

Line 10990: FROM IEC_G_REP_SUBSET_COUNTS A,

10986: LIST_HEADER_ID = p_list_id;
10987:
10988: SELECT SUM(NVL(A.RECORD_LOADED, 0))
10989: into l_valid_count
10990: FROM IEC_G_REP_SUBSET_COUNTS A,
10991: IEC_G_LIST_SUBSETS D
10992: where A.SUBSET_ID = D.LIST_SUBSET_ID AND
10993: D.LIST_HEADER_ID = p_list_id AND D.STATUS_CODE <> 'DELETED';
10994:

Line 15974: FROM IEC_G_REP_SUBSET_COUNTS

15970: EXECUTE IMMEDIATE
15971:
15972: 'SELECT COUNT(*)
15973:
15974: FROM IEC_G_REP_SUBSET_COUNTS
15975:
15976: WHERE LIST_HEADER_ID = :list_id'
15977:
15978: INTO l_count