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: DELETE FROM jty_webadi_qual_header jwh
40: WHERE NOT EXISTS

Line 39: DELETE FROM jty_webadi_qual_header jwh

35:
36: --DELETE FROM jty_webadi_qual_header
37: --WHERE user_sequence = p_user_sequence;
38:
39: DELETE FROM jty_webadi_qual_header jwh
40: WHERE NOT EXISTS
41: (SELECT 1
42: FROM jty_webadi_oth_terr_intf jwot
43: WHERE jwot.user_sequence = jwh.user_sequence) ;

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

43: WHERE jwot.user_sequence = jwh.user_sequence) ;
44:
45:
46: INSERT
47: INTO jty_webadi_qual_header(qualifier_num, user_sequence, qual_usg_id, qualifier_name, display_type,
48: operator_type, qual_cond_col_name, qual_val1_col_name, qual_val2_col_name, qual_val3_col_name,
49: html_lov_sql1, html_lov_sql2, html_lov_sql3, display_sql1, display_sql2, display_sql3,
50: convert_to_id_flag, comparison_operator)
51: SELECT rownum,

Line 156: FROM jty_webadi_qual_header qgt

152: SELECT qgt.qualifier_num,
153: REPLACE(LTRIM(LTRIM(UPPER(qualifier_name))), ' ', '_') qual_name
154: INTO l_qual_num,
155: l_qual_name
156: FROM jty_webadi_qual_header qgt
157: WHERE qgt.operator_type = 'GEOGRAPHY'
158: AND qgt.user_sequence = p_user_sequence
159: AND qgt.qual_usg_id = p_geo_type;
160:

Line 1180: FROM jty_webadi_qual_header qgt,

1176: qgt.display_sql3, jtva.secondary_interest_code_id, NULL), 'CURRENCY',
1177: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
1178: qgt.display_sql2, jtva.currency_code, NULL), NULL) qual_value3,
1179: NULL qual_value4
1180: FROM jty_webadi_qual_header qgt,
1181: jtf_terr_values_all jtva,
1182: jtf_terr_qual_all jtq
1183: WHERE qgt.qual_usg_id = jtq.qual_usg_id
1184: AND jtq.terr_qual_id = jtva.terr_qual_id --AND qgt.qualifier_num = 1