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 919: /* ACHANDA: Inserting values to jtf_tty_named_acct_changes table for GTP

915: END IF;
916:
917:
918:
919: /* ACHANDA: Inserting values to jtf_tty_named_acct_changes table for GTP
920: to do an incremental and Total Mode */
921:
922: select jtf_tty_named_acct_changes_s.nextval
923: into l_change_id

Line 922: select jtf_tty_named_acct_changes_s.nextval

918:
919: /* ACHANDA: Inserting values to jtf_tty_named_acct_changes table for GTP
920: to do an incremental and Total Mode */
921:
922: select jtf_tty_named_acct_changes_s.nextval
923: into l_change_id
924: from sys.dual;
925:
926: insert into jtf_tty_named_acct_changes

Line 926: insert into jtf_tty_named_acct_changes

922: select jtf_tty_named_acct_changes_s.nextval
923: into l_change_id
924: from sys.dual;
925:
926: insert into jtf_tty_named_acct_changes
927: ( NAMED_ACCT_CHANGE_ID
928: , OBJECT_VERSION_NUMBER
929: , OBJECT_TYPE
930: , OBJECT_ID