APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTY_WEBADI_QUAL_HEADER

Line 36: DELETE FROM jty_webadi_qual_header

32: PROCEDURE get_qual_header(p_usage_id IN NUMBER, p_org_id IN NUMBER, p_user_sequence IN NUMBER, x_row_count OUT nocopy NUMBER) IS
33:
34: BEGIN
35:
36: DELETE FROM jty_webadi_qual_header
37: WHERE user_sequence = p_user_sequence;
38:
39: INSERT
40: INTO jty_webadi_qual_header(qualifier_num, user_sequence, qual_usg_id, qualifier_name, display_type,

Line 40: INTO jty_webadi_qual_header(qualifier_num, user_sequence, qual_usg_id, qualifier_name, display_type,

36: DELETE FROM jty_webadi_qual_header
37: WHERE user_sequence = p_user_sequence;
38:
39: INSERT
40: INTO jty_webadi_qual_header(qualifier_num, user_sequence, qual_usg_id, qualifier_name, display_type,
41: operator_type, qual_cond_col_name, qual_val1_col_name, qual_val2_col_name, qual_val3_col_name,
42: html_lov_sql1, html_lov_sql2, html_lov_sql3, display_sql1, display_sql2, display_sql3,
43: convert_to_id_flag, comparison_operator)
44: SELECT rownum,

Line 149: FROM jty_webadi_qual_header qgt

145: SELECT qgt.qualifier_num,
146: REPLACE(LTRIM(LTRIM(UPPER(qualifier_name))), ' ', '_') qual_name
147: INTO l_qual_num,
148: l_qual_name
149: FROM jty_webadi_qual_header qgt
150: WHERE qgt.operator_type = 'GEOGRAPHY'
151: AND qgt.user_sequence = p_user_sequence
152: AND qgt.qual_usg_id = p_geo_type;
153:

Line 725: FROM jty_webadi_qual_header qgt,

721: qgt.display_sql3, jtva.secondary_interest_code_id, NULL), 'CURRENCY',
722: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
723: qgt.display_sql2, jtva.currency_code, NULL), NULL) qual_value3,
724: NULL qual_value4
725: FROM jty_webadi_qual_header qgt,
726: jtf_terr_values_all jtva,
727: jtf_terr_qual_all jtq
728: WHERE qgt.qual_usg_id = jtq.qual_usg_id
729: AND jtq.terr_qual_id = jtva.terr_qual_id --AND qgt.qualifier_num = 1