DBA Data[Home] [Help]

APPS.FND_MO_PRODUCT_INIT_PKG dependencies on FND_MO_PRODUCT_INIT

Line 1: package body fnd_mo_product_init_pkg as

1: package body fnd_mo_product_init_pkg as
2: /* $Header: AFMOPINB.pls 115.6 2003/09/26 15:11:21 kmaheswa noship $ */
3:
4: --
5: -- REGISTER_APPLICATION (PUBLIC)

Line 30: delete from FND_MO_PRODUCT_INIT

26: -- p_appl_short_name: application short name
27: procedure remove_application(p_appl_short_name in varchar2) is
28: begin
29: begin
30: delete from FND_MO_PRODUCT_INIT
31: where APPLICATION_SHORT_NAME = upper(p_appl_short_name);
32:
33: exception
34: when others then

Line 88: from FND_MO_PRODUCT_INIT

84: sysdate);
85: begin
86: select LAST_UPDATED_BY, LAST_UPDATE_DATE
87: into db_luby, db_ludate
88: from FND_MO_PRODUCT_INIT
89: where application_short_name = upper(p_appl_short_name);
90: -- Test for customization and version
91: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
92: db_ludate, p_custom_mode)) then

Line 93: update FND_MO_PRODUCT_INIT

89: where application_short_name = upper(p_appl_short_name);
90: -- Test for customization and version
91: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
92: db_ludate, p_custom_mode)) then
93: update FND_MO_PRODUCT_INIT
94: set LAST_UPDATED_BY = f_luby,
95: LAST_UPDATE_DATE = f_ludate,
96: LAST_UPDATE_LOGIN = 0,
97: STATUS = nvl(p_status,'N')

Line 104: insert into FND_MO_PRODUCT_INIT(

100:
101:
102: exception
103: when no_data_found then
104: insert into FND_MO_PRODUCT_INIT(
105: APPLICATION_SHORT_NAME,
106: LAST_UPDATE_DATE,
107: LAST_UPDATED_BY,
108: CREATION_DATE,

Line 131: end fnd_mo_product_init_pkg;

127: end;
128:
129: end register_application;
130:
131: end fnd_mo_product_init_pkg;