APPS.JTF_TTY_GEO_WEBADI_INT_PKG dependencies on JTF_TTY_NAMED_ACCT_CHANGES

Line 24: -- 12/22/2003 ACHANDA Modified to insert record in jtf_tty_named_acct_changes

20: -- This package is publicly available for use
21: --
22: -- HISTORY
23: -- 05/02/2002 SHLI Created
24: -- 12/22/2003 ACHANDA Modified to insert record in jtf_tty_named_acct_changes
25: -- so that GTP can perform increamental processing
26: -- 12/30/2003 SGKUMAR Modified to show data for the active territory
27: -- groups
28: -- 01/02/2004 SGKUMAR Modified update_geo_terr to check if Postal Code

Line 939: /* ACHANDA: Inserting values to jtf_tty_named_acct_changes table for GTP

935: END IF;
936:
937:
938:
939: /* ACHANDA: Inserting values to jtf_tty_named_acct_changes table for GTP
940: to do an incremental and Total Mode */
941:
942: select jtf_tty_named_acct_changes_s.nextval
943: into l_change_id

Line 942: select jtf_tty_named_acct_changes_s.nextval

938:
939: /* ACHANDA: Inserting values to jtf_tty_named_acct_changes table for GTP
940: to do an incremental and Total Mode */
941:
942: select jtf_tty_named_acct_changes_s.nextval
943: into l_change_id
944: from sys.dual;
945:
946: insert into jtf_tty_named_acct_changes

Line 946: insert into jtf_tty_named_acct_changes

942: select jtf_tty_named_acct_changes_s.nextval
943: into l_change_id
944: from sys.dual;
945:
946: insert into jtf_tty_named_acct_changes
947: ( NAMED_ACCT_CHANGE_ID
948: , OBJECT_VERSION_NUMBER
949: , OBJECT_TYPE
950: , OBJECT_ID