APPS.JTF_TTY_NA_TERRGP dependencies on FND_GLOBAL

Line 328: p_user_id := fnd_global.user_id;

324: AS
325: p_user_id NUMBER;
326: BEGIN
327:
328: p_user_id := fnd_global.user_id;
329: /* delete from the named acct sum only for affect resources */
330: /*
331: DELETE from jtf_tty_rsc_acct_summ j
332: WHERE j.RESOURCE_ID in (SELECT RESOURCE_ID

Line 441: -- log_event(p_terr_gp_id, 'DELETE', 'Delete Territory Group', 'TG', fnd_global.user_id);

437: DELETE FROM jtf_tty_terr_groups
438: WHERE terr_group_id = p_terr_gp_id;
439:
440: /* GSST decom. by SHLI */
441: -- log_event(p_terr_gp_id, 'DELETE', 'Delete Territory Group', 'TG', fnd_global.user_id);
442: COMMIT;
443: END delete_terrgp;
444:
445: PROCEDURE check_hierarchy(x_hierarchy_status OUT NOCOPY VARCHAR2,

Line 573: p_user_id := Fnd_Global.user_id;

569: */
570:
571: BEGIN
572:
573: p_user_id := Fnd_Global.user_id;
574:
575: NewOwnerRsc := mytabletype();
576: NewOwnerGrp := mytabletype();
577: NewOwnerRole := mytabletypev();

Line 1651: L_USER_ID NUMBER := Fnd_Global.USER_ID();

1647: x_return_status OUT NOCOPY VARCHAR2
1648: , x_error_message OUT NOCOPY VARCHAR2
1649: )
1650: IS
1651: L_USER_ID NUMBER := Fnd_Global.USER_ID();
1652: L_SYSDATE DATE := SYSDATE;
1653: p_user_id NUMBER;
1654: p_overlapping_account_flag NUMBER;
1655: p_owner_user_id NUMBER;

Line 2430: p_user_id := Fnd_Global.user_id;

2426: FROM jtf_rs_group_members
2427: WHERE group_id = x_group_id;
2428:
2429: BEGIN
2430: p_user_id := Fnd_Global.user_id;
2431:
2432: /* delete the existing assignments */
2433: DELETE FROM jtf_tty_named_acct_rsc j
2434: WHERE j.TERR_GROUP_ACCOUNT_ID IN