APPS.FND_PRODUCT_INITIALIZATION_PKG dependencies on FND_PRODUCT_INIT_DEPENDENCY

Line 130: delete from FND_PRODUCT_INIT_DEPENDENCY

126: x_dependency in varchar2) is
127:
128: begin
129: begin
130: delete from FND_PRODUCT_INIT_DEPENDENCY
131: where APPLICATION_SHORT_NAME = upper(x_apps_name)
132: and PRODUCT_DEPENDENCY = upper(x_dependency);
133:
134: exception

Line 173: from FND_PRODUCT_INIT_DEPENDENCY p1

169: -- Duplidate dependency is taken care by using distinct command.
170: -- And the invoking ordering is taken care by the LEVEL order by.
171: cursor dependency is
172: select distinct PRODUCT_DEPENDENCY, LEVEL
173: from FND_PRODUCT_INIT_DEPENDENCY p1
174: where LEVEL =
175: (select max(LEVEL)
176: from FND_PRODUCT_INIT_DEPENDENCY p2
177: where p2.PRODUCT_DEPENDENCY = p1.PRODUCT_DEPENDENCY

Line 176: from FND_PRODUCT_INIT_DEPENDENCY p2

172: select distinct PRODUCT_DEPENDENCY, LEVEL
173: from FND_PRODUCT_INIT_DEPENDENCY p1
174: where LEVEL =
175: (select max(LEVEL)
176: from FND_PRODUCT_INIT_DEPENDENCY p2
177: where p2.PRODUCT_DEPENDENCY = p1.PRODUCT_DEPENDENCY
178: connect by prior p2.PRODUCT_DEPENDENCY = p2.APPLICATION_SHORT_NAME
179: start with p2.APPLICATION_SHORT_NAME = upper(x_apps_name))
180: connect by prior PRODUCT_DEPENDENCY = APPLICATION_SHORT_NAME

Line 558: insert into FND_PRODUCT_INIT_DEPENDENCY(

554: -- Translate char last_update_date to date
555: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
556:
557: begin
558: insert into FND_PRODUCT_INIT_DEPENDENCY(
559: APPLICATION_SHORT_NAME,
560: PRODUCT_DEPENDENCY,
561: LAST_UPDATED_BY,
562: LAST_UPDATE_DATE,

Line 675: delete from fnd_product_init_dependency

671: -- x_apps_short_name: the application short name
672: --
673: procedure RemoveAll(apps_short_name in varchar2) is
674: begin
675: delete from fnd_product_init_dependency
676: where application_short_name = apps_short_name;
677:
678: delete from fnd_product_init_condition
679: where application_short_name = apps_short_name;