APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTY_STR_TO_TABLE_GT

Line 1643: FROM jty_str_to_table_gt)

1639: AND(v_active BETWEEN terr.start_date_active
1640: AND terr.end_date_active OR v_active IS NULL) CONNECT BY terr.parent_territory_id = PRIOR terr.terr_id
1641: AND terr.terr_id <> 1 START WITH terr.terr_id IN
1642: (SELECT num_col
1643: FROM jty_str_to_table_gt)
1644: ORDER siblings BY terr.terr_id)
1645: sub
1646: WHERE sub.org_id = hr.organization_id
1647: AND sub.terr_type_id = terr_type.terr_type_id;

Line 1901: --EXECUTE IMMEDIATE ('TRUNCATE TABLE JTY_STR_TO_TABLE_GT');

1897: --p( l_cur_query );
1898:
1899: IF p_terr_id_array IS NOT NULL THEN
1900: BEGIN
1901: --EXECUTE IMMEDIATE ('TRUNCATE TABLE JTY_STR_TO_TABLE_GT');
1902:
1903: DELETE FROM jty_str_to_table_gt;
1904: l_string := p_terr_id_array || ',';
1905: LOOP

Line 1903: DELETE FROM jty_str_to_table_gt;

1899: IF p_terr_id_array IS NOT NULL THEN
1900: BEGIN
1901: --EXECUTE IMMEDIATE ('TRUNCATE TABLE JTY_STR_TO_TABLE_GT');
1902:
1903: DELETE FROM jty_str_to_table_gt;
1904: l_string := p_terr_id_array || ',';
1905: LOOP
1906: EXIT
1907: WHEN l_string IS NULL;

Line 1913: INTO jty_str_to_table_gt(num_col)

1909: l_value := SUBSTR(l_string, 1, l_cnt -1);
1910:
1911: IF l_value IS NOT NULL THEN
1912: INSERT
1913: INTO jty_str_to_table_gt(num_col)
1914: VALUES(l_value);
1915: END IF;
1916:
1917: l_string := SUBSTR(l_string, l_cnt + 1);