1754: l_intf_type varchar2(1);
1755: l_login_id number;
1756: BEGIN
1757:
1758: l_login_id := fnd_global.login_id;
1759: l_intf_type := p_intf_type;
1760:
1761:
1762: update JTY_WEBADI_OTH_TERR_INTF jwot
11308: l_intf_type varchar2(1) := 'U';
11309: l_row_count number;
11310: l_row_count2 number;
11311: l_sql varchar2(5000);
11312: l_login_id number := fnd_global.login_id;
11313:
11314: l_status varchar2_tbl_type;
11315: l_error_msg varchar2_tbl_type;
11316: l_lay_seq_num number_tbl_type;