APPS.JTF_TTY_GEO_TERRGP dependencies on FND_GLOBAL

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

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

Line 999: p_user_id := fnd_global.user_id;

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

Line 1040: p_user_id := fnd_global.user_id;

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