APPS.JTF_TTY_GEO_TERRGP dependencies on FND_GLOBAL

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

619: delete from jtf_tty_terr_groups
620: where terr_group_id = p_terr_gp_id;
621:
622: /* ACHANDA : added to log the event of territory group delete for GTP to do incremental process */
623: log_event(p_terr_gp_id, 'DELETE', 'Delete Territory Group', 'TG', fnd_global.user_id);
624: commit;
625: END delete_terrgp;
626: /*
627: * Adds the geography to the geo terr group

Line 1001: p_user_id := fnd_global.user_id;

997: p_rsc_role_code IN VARCHAR2)
998: AS
999: p_user_id NUMBER;
1000: BEGIN
1001: p_user_id := fnd_global.user_id;
1002:
1003: /* Assign the top level territory to the geo terr gp owner/sales rep */
1004: insert into jtf_tty_geo_terr_rsc
1005: (geo_terr_resource_id,

Line 1042: p_user_id := fnd_global.user_id;

1038: p_replaced_owner_resource_id IN NUMBER)
1039: AS
1040: p_user_id NUMBER;
1041: BEGIN
1042: p_user_id := fnd_global.user_id;
1043: -- change the owner of all the territories created by replaced owner
1044: -- from this territory (as a parent)
1045:
1046: update jtf_tty_geo_terr