DBA Data[Home] [Help]

APPS.IEC_DEFAULT_SUBSET_PVT dependencies on IEC_G_LIST_SUBSETS

Line 78: FROM IEC_G_LIST_SUBSETS

74: BEGIN
75:
76: SELECT SUBSET_NAME
77: INTO L_SUBSET_NAME
78: FROM IEC_G_LIST_SUBSETS
79: WHERE LIST_HEADER_ID = P_LIST_ID
80: AND DEFAULT_SUBSET_FLAG = 'Y';
81:
82: EXCEPTION

Line 86: INSERT INTO IEC_G_LIST_SUBSETS

82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN
84: BEGIN
85:
86: INSERT INTO IEC_G_LIST_SUBSETS
87: ( LIST_SUBSET_ID
88: , LIST_HEADER_ID
89: , SUBSET_NAME
90: , QUANTUM

Line 104: ( IEC_G_LIST_SUBSETS_S.NEXTVAL

100: , LAST_UPDATE_DATE
101: , OBJECT_VERSION_NUMBER
102: )
103: VALUES
104: ( IEC_G_LIST_SUBSETS_S.NEXTVAL
105: , P_LIST_ID
106: , l_default_subset_name
107: , 10
108: , 1