APPS.JTF_TERR_NAMED_ACCOUNT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

PROCEDURE delete_qual(p_acct_qual_map_id IN NUMBER) AS
BEGIN
 delete from jtf_tty_acct_qual_maps
 where ACCOUNT_QUAL_MAP_ID = p_acct_qual_map_id;

Line: 23

END delete_qual;

Line: 25

PROCEDURE insert_customer_qual(p_account_id IN NUMBER)
AS
BEGIN
insert into jtf_tty_acct_qual_maps
(ACCOUNT_QUAL_MAP_ID,
 OBJECT_VERSION_NUMBER ,
NAMED_ACCOUNT_ID       ,
 QUAL_USG_ID  ,
 COMPARISON_OPERATOR ,
 VALUE1_CHAR ,
 VALUE1_NUM
, VALUE2_NUM
, CREATED_BY ,
 CREATION_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_DATE ,
LAST_UPDATE_LOGIN
)
VALUES(2015,
       2,
       p_account_id,
       -1012,
       '=',
       'Betu',
       1,
       94403,
       94400,
       sysdate,
       1,
       sysdate,
       1
);

Line: 59

END insert_customer_qual;

Line: 65

  select count(*) into qual_count
  from   JTF_TTY_ACCT_QUAL_MAPS
  where   NAMED_ACCOUNT_ID = p_account_id
  and QUAL_USG_ID = -1007;

Line: 77

  select count(*) into qual_count
  from   JTF_TTY_ACCT_QUAL_MAPS
  where   NAMED_ACCOUNT_ID = p_account_id
  and QUAL_USG_ID = -1012;

Line: 98

  select 1
  into qual_count
  from jtf_tty_acct_qual_maps
  where ACCOUNT_QUAL_MAP_ID = p_acct_qual_map_id
  and   rownum < 2;

Line: 109

 insert into jtf_tty_acct_qual_maps
(ACCOUNT_QUAL_MAP_ID,
 OBJECT_VERSION_NUMBER ,
 NAMED_ACCOUNT_ID       ,
 QUAL_USG_ID  ,
 COMPARISON_OPERATOR ,
 VALUE1_CHAR ,
 VALUE2_CHAR ,
 VALUE1_NUM
, VALUE2_NUM
, CREATED_BY ,
 CREATION_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_DATE
)
VALUES(p_acct_qual_map_id,
       999,
       p_acct_id,
       p_qual_usg_id,
       p_operator,
       upper(p_value1_char),
       upper(p_value2_char),
       p_value1_num,
       p_value2_num,
       p_user_id,
       sysdate,
       p_user_id,
       sysdate
);

Line: 139

 update jtf_tty_acct_qual_maps
 set    OBJECT_VERSION_NUMBER = 999,
        COMPARISON_OPERATOR   = p_operator,
        VALUE1_CHAR = upper(p_value1_char),
        VALUE2_CHAR = upper(p_value2_char),
        VALUE1_NUM = p_value1_num,
        VALUE2_NUM = p_value2_num,
        LAST_UPDATED_BY = p_user_id,
        LAST_UPDATE_DATE = sysdate
 where ACCOUNT_QUAL_MAP_ID = p_acct_qual_map_id;

Line: 152

PROCEDURE update_mapping(p_account_id IN VARCHAR2,
                         p_flag in VARCHAR2)
AS
BEGIN
 update jtf_tty_named_accts
 set MAPPING_COMPLETE_FLAG = p_flag
 where NAMED_ACCOUNT_ID = p_account_id;

Line: 159

 update jtf_tty_terr_grp_accts
 set DN_JNA_MAPPING_COMPLETE_FLAG = p_flag
 where NAMED_ACCOUNT_ID = p_account_id;

Line: 163

END update_mapping;