APPS.JTF_UM_ROLE_RESP_PKG dependencies on JTF_UM_ROLE_RESP_PKG

Line 1: package body JTF_UM_ROLE_RESP_PKG as

1: package body JTF_UM_ROLE_RESP_PKG as
2: /* $Header: JTFUMRRB.pls 120.3 2005/11/28 08:51:15 vimohan ship $ */
3: procedure INSERT_USERTYPE_ROLE_ROW (
4: x_usertype_id IN NUMBER,
5: x_principal_name IN VARCHAR2,

Line 100: JTF_UM_ROLE_RESP_PKG.UPDATE_USERTYPE_ROLE_ROW (

96: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
97: db_ludate, X_CUSTOM_MODE)) then
98:
99: -- Update row if present
100: JTF_UM_ROLE_RESP_PKG.UPDATE_USERTYPE_ROLE_ROW (
101: x_usertype_id => x_usertype_id,
102: x_principal_name => x_principal_name,
103: x_effective_end_date => x_effective_end_date,
104: x_last_update_date => f_ludate,

Line 115: JTF_UM_ROLE_RESP_PKG.INSERT_USERTYPE_ROLE_ROW (

111: exception
112: when NO_DATA_FOUND then
113:
114: -- Insert a new row
115: JTF_UM_ROLE_RESP_PKG.INSERT_USERTYPE_ROLE_ROW (
116: x_usertype_id => x_usertype_id,
117: x_principal_name => x_principal_name,
118: x_effective_start_date => x_effective_start_date,
119: x_effective_end_date => x_effective_end_date,

Line 236: JTF_UM_ROLE_RESP_PKG.UPDATE_USERTYPE_RESP_ROW (

232: db_ludate, X_CUSTOM_MODE)) then
233:
234:
235: -- Update row if present
236: JTF_UM_ROLE_RESP_PKG.UPDATE_USERTYPE_RESP_ROW (
237: x_usertype_id => x_usertype_id,
238: x_responsibility_key => x_responsibility_key,
239: x_is_default_flag => x_is_default_flag,
240: x_effective_end_date => x_effective_end_date,

Line 252: JTF_UM_ROLE_RESP_PKG.INSERT_USERTYPE_RESP_ROW (

248: exception
249: when NO_DATA_FOUND then
250:
251: -- Insert a new row
252: JTF_UM_ROLE_RESP_PKG.INSERT_USERTYPE_RESP_ROW (
253: x_usertype_id => x_usertype_id,
254: x_responsibility_key => x_responsibility_key,
255: x_is_default_flag => x_is_default_flag,
256: x_effective_start_date => x_effective_start_date,

Line 367: JTF_UM_ROLE_RESP_PKG.UPDATE_SUBSCRIPTION_ROLE_ROW (

363: db_ludate, X_CUSTOM_MODE)) then
364:
365:
366: -- Update row if present
367: JTF_UM_ROLE_RESP_PKG.UPDATE_SUBSCRIPTION_ROLE_ROW (
368: x_subscription_id => x_subscription_id,
369: x_principal_name => x_principal_name,
370: x_effective_end_date => x_effective_end_date,
371: x_last_update_date => f_ludate,

Line 382: JTF_UM_ROLE_RESP_PKG.INSERT_SUBSCRIPTION_ROLE_ROW (

378: exception
379: when NO_DATA_FOUND then
380:
381: -- Insert a new row
382: JTF_UM_ROLE_RESP_PKG.INSERT_SUBSCRIPTION_ROLE_ROW (
383: x_subscription_id => x_subscription_id,
384: x_principal_name => x_principal_name,
385: x_effective_start_date => x_effective_start_date,
386: x_effective_end_date => x_effective_end_date,

Line 500: JTF_UM_ROLE_RESP_PKG.UPDATE_SUBSCRIPTION_RESP_ROW (

496: db_ludate, X_CUSTOM_MODE)) then
497:
498:
499: -- Update row if present
500: JTF_UM_ROLE_RESP_PKG.UPDATE_SUBSCRIPTION_RESP_ROW (
501: x_subscription_id => x_subscription_id,
502: x_responsibility_key => x_responsibility_key,
503: x_effective_end_date => x_effective_end_date,
504: x_last_update_date => f_ludate,

Line 516: JTF_UM_ROLE_RESP_PKG.INSERT_SUBSCRIPTION_RESP_ROW (

512: exception
513: when NO_DATA_FOUND then
514:
515: -- Insert a new row
516: JTF_UM_ROLE_RESP_PKG.INSERT_SUBSCRIPTION_RESP_ROW (
517: x_subscription_id => x_subscription_id,
518: x_responsibility_key => x_responsibility_key,
519: x_effective_start_date => x_effective_start_date,
520: x_effective_end_date => x_effective_end_date,

Line 530: end JTF_UM_ROLE_RESP_PKG;

526: x_application_id => x_application_id
527: );
528: end LOAD_SUBSCRIPTION_RESP_ROW;
529:
530: end JTF_UM_ROLE_RESP_PKG;