APPS.IEM_ROUTE_PVT dependencies on IEM_ROUTE_PVT

Line 1: PACKAGE BODY IEM_ROUTE_PVT AS

1: PACKAGE BODY IEM_ROUTE_PVT AS
2: /* $Header: iemvroub.pls 120.0 2005/06/02 13:41:41 appldev noship $ */
3:
4: --
5: --

Line 21: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ROUTE_PVT ';

17: -- Liang Xia 12/06/2004 Changed for 115.11 schema: iem_mstemail_account
18: -- --------- ------ ------------------------------------------
19:
20: -- Enter procedure, function bodies as shown below
21: G_PKG_NAME CONSTANT varchar2(30) :='IEM_ROUTE_PVT ';
22: G_ROUTE_ID varchar2(30) ;
23: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
24:
25: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID') ) ;

Line 295: if fnd_log.test(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PVT.CREATE_ITEM_WRAP.START') then

291: --API Body
292: /*
293: FND_LOG_REPOSITORY.init(null,null);
294:
295: if fnd_log.test(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PVT.CREATE_ITEM_WRAP.START') then
296: logMessage := '[create item is called!]';
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PVT.CREATE_ITEM_WRAP.START', logMessage);
298: end if;
299: */

Line 297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PVT.CREATE_ITEM_WRAP.START', logMessage);

293: FND_LOG_REPOSITORY.init(null,null);
294:
295: if fnd_log.test(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PVT.CREATE_ITEM_WRAP.START') then
296: logMessage := '[create item is called!]';
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PVT.CREATE_ITEM_WRAP.START', logMessage);
298: end if;
299: */
300: --Now call the create_item() to create the acccount
301: if ( p_route_boolean_type_code = 'DYNAMIC' ) then

Line 307: iem_route_pvt.create_item_routes (

303: else
304: l_return_type := FND_API.G_MISS_CHAR;
305: end if;
306:
307: iem_route_pvt.create_item_routes (
308: p_api_version_number=>p_api_version_number,
309: p_init_msg_list => p_init_msg_list,
310: p_commit => FND_API.G_FALSE,
311: p_name => p_route_name,

Line 336: iem_route_pvt.create_item_route_rules (

332:
333: if p_rule_key_typecode_tbl.count > 0 then
334: FOR i IN p_rule_key_typecode_tbl.FIRST..p_rule_key_typecode_tbl.LAST loop
335:
336: iem_route_pvt.create_item_route_rules (
337:
338:
339: p_api_version_number=>p_api_version_number,
340: p_init_msg_list => p_init_msg_list,

Line 1138: iem_route_pvt.update_item_route(

1134: l_description := null;
1135: else
1136: l_description := p_description;
1137: end if;
1138: iem_route_pvt.update_item_route(
1139: p_api_version_number => l_api_version_number,
1140: p_init_msg_list => FND_API.G_FALSE,
1141: p_commit => FND_API.G_FALSE,
1142: p_route_id => p_route_id,

Line 1163: iem_route_pvt.update_item_rule(p_api_version_number => l_api_version_number,

1159: --update iem_route_rules table
1160: if ( p_update_rule_ids_tbl.count <>0 ) then
1161:
1162: FOR i IN p_update_rule_ids_tbl.FIRST..p_update_rule_ids_tbl.LAST loop
1163: iem_route_pvt.update_item_rule(p_api_version_number => l_api_version_number,
1164: p_init_msg_list => FND_API.G_FALSE,
1165: p_commit => FND_API.G_FALSE,
1166: p_route_rule_id => p_update_rule_ids_tbl(i),
1167: p_key_type_code =>p_update_rule_keys_tbl(i),

Line 1196: iem_route_pvt.create_item_route_rules (p_api_version_number=>p_api_version_number,

1192: end if;
1193:
1194: if ( p_new_rule_keys_tbl.count <> 0 ) then
1195: FOR i IN p_new_rule_keys_tbl.FIRST..p_new_rule_keys_tbl.LAST LOOP
1196: iem_route_pvt.create_item_route_rules (p_api_version_number=>p_api_version_number,
1197: p_init_msg_list => p_init_msg_list,
1198: p_commit => p_commit,
1199: p_route_id => p_route_id,
1200: p_key_type_code => p_new_rule_keys_tbl(i),

Line 1695: iem_route_pvt.create_item_account_routes(

1691: end if;
1692:
1693:
1694:
1695: iem_route_pvt.create_item_account_routes(
1696: p_api_version_number =>p_api_version_number,
1697: p_init_msg_list => p_init_msg_list,
1698: p_commit => p_commit,
1699:

Line 2119: iem_route_pvt.update_account_routes (p_api_version_number =>p_api_version_number,

2115:
2116: if ( p_route_ids_tbl.count <> 0 ) then
2117: FOR i IN p_route_ids_tbl.FIRST..p_route_ids_tbl.LAST LOOP
2118:
2119: iem_route_pvt.update_account_routes (p_api_version_number =>p_api_version_number,
2120: p_init_msg_list => FND_API.G_FALSE,
2121: p_commit => FND_API.G_TRUE,
2122:
2123:

Line 2147: iem_route_pvt.delete_acct_route_batch

2143:
2144: if ( p_route_ids_tbl.count <> 0 ) then
2145:
2146: -- FOR i IN p_route_ids_tbl.FIRST..p_route_ids_tbl.LAST LOOP
2147: iem_route_pvt.delete_acct_route_batch
2148: (p_api_version_number => p_api_version_number,
2149: P_init_msg_list => FND_API.G_FALSE,
2150:
2151: p_commit => FND_API.G_TRUE,

Line 2240: END IEM_ROUTE_PVT; -- Package Body IEM_ROUTE_PVT

2236:
2237: END update_wrap_account_routes;
2238: -- Enter further code below as specified in the Package spec.
2239:
2240: END IEM_ROUTE_PVT; -- Package Body IEM_ROUTE_PVT