608: TRACELOG('STARTING DROP TARGET GROUP VIEWS');
609: X_RETURN_CODE := FND_API.G_RET_STS_SUCCESS;
610:
611: FOR subset_rec IN (SELECT LIST_SUBSET_ID
612: FROM IEC_G_LIST_SUBSETS
613: WHERE LIST_HEADER_ID = P_TARGET_GROUP_ID
614: AND NVL(DEFAULT_SUBSET_FLAG, 'N') = 'N')
615: LOOP
616: DROP_SUBSET_VIEW( P_SOURCE_ID
780: SAVEPOINT CREATE_SUBSET_RT_INFO_SAVE;
781:
782: ----------------------------------------------------------------
783: -- Retrieve the default data values for the release strategy
784: -- from the subset entry on the IEC_G_LIST_SUBSETS table. If
785: -- default values do not exists then we use defaults. We could
786: -- have retrieved this data in the populate cache procedure, but
787: -- a subset is only going to retrieve these once, but could be
788: -- used for a long time. That was the reason behind taking the
801: , L_QUOTA
802: , L_QUOTA_RESET
803: , L_STATUS_CODE
804: , L_LOAD_PRIORITY
805: FROM IEC_G_LIST_SUBSETS
806: WHERE LIST_SUBSET_ID = P_SUBSET_ID;
807:
808: EXCEPTION
809: WHEN NO_DATA_FOUND THEN
961:
962: BEGIN
963: SELECT NVL(DEFAULT_SUBSET_FLAG, 'N')
964: INTO l_default_subset_Flag
965: FROM IEC_G_LIST_SUBSETS
966: WHERE LIST_HEADER_ID = P_TARGET_GROUP_ID
967: AND LIST_SUBSET_ID = P_SUBSET_ID;
968: EXCEPTION
969: WHEN OTHERS THEN
1888: BEGIN
1889:
1890: x_default_subset_id := NULL;
1891:
1892: EXECUTE IMMEDIATE 'SELECT LIST_SUBSET_ID FROM IEC_G_LIST_SUBSETS ' ||
1893: 'WHERE LIST_HEADER_ID = :listID AND DEFAULT_SUBSET_FLAG = ''Y'''
1894: INTO X_DEFAULT_SUBSET_ID
1895: USING P_TARGET_GROUP_ID;
1896: