DBA Data[Home] [Help]

APPS.JTF_TTY_NACCT_SALES_PUB dependencies on JTF_TTY_NAMED_ACCT_CHANGES

Line 453: /* JRADHAKR: Inserting values to jtf_tty_named_acct_changes table for GTP

449: --||l_terr_group_account_id || '//lp_user_resource_id:' || lp_user_resource_id);
450: -- Bug: 2726632
451: -- Bug: 2732533
452:
453: /* JRADHAKR: Inserting values to jtf_tty_named_acct_changes table for GTP
454: to do an incremental and Total Mode */
455:
456: select jtf_tty_named_acct_changes_s.nextval
457: into l_change_id

Line 456: select jtf_tty_named_acct_changes_s.nextval

452:
453: /* JRADHAKR: Inserting values to jtf_tty_named_acct_changes table for GTP
454: to do an incremental and Total Mode */
455:
456: select jtf_tty_named_acct_changes_s.nextval
457: into l_change_id
458: from sys.dual;
459:
460: insert into jtf_tty_named_acct_changes

Line 460: insert into jtf_tty_named_acct_changes

456: select jtf_tty_named_acct_changes_s.nextval
457: into l_change_id
458: from sys.dual;
459:
460: insert into jtf_tty_named_acct_changes
461: ( NAMED_ACCT_CHANGE_ID
462: , OBJECT_VERSION_NUMBER
463: , OBJECT_TYPE
464: , OBJECT_ID

Line 520: /* JRADHAKR: Inserting values to jtf_tty_named_acct_changes table for GTP

516:
517: -- each named account exists in context of a territory group for resource
518: l_terr_group_account_id := G_AFFECT_PARTY_TBL(j).terr_group_account_id;
519:
520: /* JRADHAKR: Inserting values to jtf_tty_named_acct_changes table for GTP
521: to do an incremental and Total Mode */
522:
523: select jtf_tty_named_acct_changes_s.nextval
524: into l_change_id

Line 523: select jtf_tty_named_acct_changes_s.nextval

519:
520: /* JRADHAKR: Inserting values to jtf_tty_named_acct_changes table for GTP
521: to do an incremental and Total Mode */
522:
523: select jtf_tty_named_acct_changes_s.nextval
524: into l_change_id
525: from sys.dual;
526:
527: insert into jtf_tty_named_acct_changes

Line 527: insert into jtf_tty_named_acct_changes

523: select jtf_tty_named_acct_changes_s.nextval
524: into l_change_id
525: from sys.dual;
526:
527: insert into jtf_tty_named_acct_changes
528: ( NAMED_ACCT_CHANGE_ID
529: , OBJECT_VERSION_NUMBER
530: , OBJECT_TYPE
531: , OBJECT_ID