APPS.IEC_SUBSET_PVT dependencies on IEC_G_LIST_SUBSETS

Line 612: FROM IEC_G_LIST_SUBSETS

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

Line 784: -- from the subset entry on the IEC_G_LIST_SUBSETS table. If

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

Line 805: FROM IEC_G_LIST_SUBSETS

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

Line 965: FROM IEC_G_LIST_SUBSETS

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

Line 1892: EXECUTE IMMEDIATE 'SELECT LIST_SUBSET_ID FROM IEC_G_LIST_SUBSETS ' ||

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: