eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_VALIDATE_CURR_DETAILS dependencies on QP_CURRENCY_DETAILS

Line 41: CURSOR CURSOR_OVERLAP_CHECK(in_to_currency_code_s QP_CURRENCY_DETAILS.to_currency_code%TYPE,

37: l_fna_name VARCHAR2(4000);
38: l_fna_desc VARCHAR2(489);
39: l_fna_valid BOOLEAN;
40:
41: CURSOR CURSOR_OVERLAP_CHECK(in_to_currency_code_s QP_CURRENCY_DETAILS.to_currency_code%TYPE,
42: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,
43: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,
44: in_curr_attribute_type QP_CURRENCY_DETAILS.curr_attribute_type%TYPE,
45: in_curr_attribute_context QP_CURRENCY_DETAILS.curr_attribute_context%TYPE,

Line 42: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,

38: l_fna_desc VARCHAR2(489);
39: l_fna_valid BOOLEAN;
40:
41: CURSOR CURSOR_OVERLAP_CHECK(in_to_currency_code_s QP_CURRENCY_DETAILS.to_currency_code%TYPE,
42: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,
43: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,
44: in_curr_attribute_type QP_CURRENCY_DETAILS.curr_attribute_type%TYPE,
45: in_curr_attribute_context QP_CURRENCY_DETAILS.curr_attribute_context%TYPE,
46: in_curr_attribute QP_CURRENCY_DETAILS.curr_attribute%TYPE,

Line 43: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,

39: l_fna_valid BOOLEAN;
40:
41: CURSOR CURSOR_OVERLAP_CHECK(in_to_currency_code_s QP_CURRENCY_DETAILS.to_currency_code%TYPE,
42: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,
43: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,
44: in_curr_attribute_type QP_CURRENCY_DETAILS.curr_attribute_type%TYPE,
45: in_curr_attribute_context QP_CURRENCY_DETAILS.curr_attribute_context%TYPE,
46: in_curr_attribute QP_CURRENCY_DETAILS.curr_attribute%TYPE,
47: in_curr_attribute_value QP_CURRENCY_DETAILS.curr_attribute_value%TYPE

Line 44: in_curr_attribute_type QP_CURRENCY_DETAILS.curr_attribute_type%TYPE,

40:
41: CURSOR CURSOR_OVERLAP_CHECK(in_to_currency_code_s QP_CURRENCY_DETAILS.to_currency_code%TYPE,
42: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,
43: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,
44: in_curr_attribute_type QP_CURRENCY_DETAILS.curr_attribute_type%TYPE,
45: in_curr_attribute_context QP_CURRENCY_DETAILS.curr_attribute_context%TYPE,
46: in_curr_attribute QP_CURRENCY_DETAILS.curr_attribute%TYPE,
47: in_curr_attribute_value QP_CURRENCY_DETAILS.curr_attribute_value%TYPE
48: )

Line 45: in_curr_attribute_context QP_CURRENCY_DETAILS.curr_attribute_context%TYPE,

41: CURSOR CURSOR_OVERLAP_CHECK(in_to_currency_code_s QP_CURRENCY_DETAILS.to_currency_code%TYPE,
42: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,
43: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,
44: in_curr_attribute_type QP_CURRENCY_DETAILS.curr_attribute_type%TYPE,
45: in_curr_attribute_context QP_CURRENCY_DETAILS.curr_attribute_context%TYPE,
46: in_curr_attribute QP_CURRENCY_DETAILS.curr_attribute%TYPE,
47: in_curr_attribute_value QP_CURRENCY_DETAILS.curr_attribute_value%TYPE
48: )
49: is

Line 46: in_curr_attribute QP_CURRENCY_DETAILS.curr_attribute%TYPE,

42: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,
43: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,
44: in_curr_attribute_type QP_CURRENCY_DETAILS.curr_attribute_type%TYPE,
45: in_curr_attribute_context QP_CURRENCY_DETAILS.curr_attribute_context%TYPE,
46: in_curr_attribute QP_CURRENCY_DETAILS.curr_attribute%TYPE,
47: in_curr_attribute_value QP_CURRENCY_DETAILS.curr_attribute_value%TYPE
48: )
49: is
50: SELECT

Line 47: in_curr_attribute_value QP_CURRENCY_DETAILS.curr_attribute_value%TYPE

43: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,
44: in_curr_attribute_type QP_CURRENCY_DETAILS.curr_attribute_type%TYPE,
45: in_curr_attribute_context QP_CURRENCY_DETAILS.curr_attribute_context%TYPE,
46: in_curr_attribute QP_CURRENCY_DETAILS.curr_attribute%TYPE,
47: in_curr_attribute_value QP_CURRENCY_DETAILS.curr_attribute_value%TYPE
48: )
49: is
50: SELECT
51: trunc(start_date_active) start_date_active,

Line 53: FROM QP_CURRENCY_DETAILS

49: is
50: SELECT
51: trunc(start_date_active) start_date_active,
52: trunc(end_date_active) end_date_active
53: FROM QP_CURRENCY_DETAILS
54: WHERE to_currency_code = in_to_currency_code_s and
55: currency_header_id = in_currency_header_id_n and
56: currency_detail_id <> nvl(in_currency_detail_id_n, -99999) and
57: nvl(curr_attribute_type, '~EQUAL~') = nvl(in_curr_attribute_type, '~EQUAL~') and

Line 63: (in_to_currency_code_s QP_CURRENCY_DETAILS.to_currency_code%TYPE,

59: nvl(curr_attribute, '~EQUAL~') = nvl(in_curr_attribute, '~EQUAL~') and
60: nvl(curr_attribute_value, '~EQUAL~') = nvl(in_curr_attribute_value, '~EQUAL~');
61:
62: CURSOR CURSOR_PRECEDENCE_UNIQUENESS
63: (in_to_currency_code_s QP_CURRENCY_DETAILS.to_currency_code%TYPE,
64: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,
65: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,
66: in_precedence QP_CURRENCY_DETAILS.precedence%TYPE
67: )

Line 64: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,

60: nvl(curr_attribute_value, '~EQUAL~') = nvl(in_curr_attribute_value, '~EQUAL~');
61:
62: CURSOR CURSOR_PRECEDENCE_UNIQUENESS
63: (in_to_currency_code_s QP_CURRENCY_DETAILS.to_currency_code%TYPE,
64: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,
65: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,
66: in_precedence QP_CURRENCY_DETAILS.precedence%TYPE
67: )
68: is

Line 65: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,

61:
62: CURSOR CURSOR_PRECEDENCE_UNIQUENESS
63: (in_to_currency_code_s QP_CURRENCY_DETAILS.to_currency_code%TYPE,
64: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,
65: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,
66: in_precedence QP_CURRENCY_DETAILS.precedence%TYPE
67: )
68: is
69: SELECT

Line 66: in_precedence QP_CURRENCY_DETAILS.precedence%TYPE

62: CURSOR CURSOR_PRECEDENCE_UNIQUENESS
63: (in_to_currency_code_s QP_CURRENCY_DETAILS.to_currency_code%TYPE,
64: in_currency_header_id_n QP_CURRENCY_DETAILS.currency_header_id%TYPE,
65: in_currency_detail_id_n QP_CURRENCY_DETAILS.currency_detail_id%TYPE,
66: in_precedence QP_CURRENCY_DETAILS.precedence%TYPE
67: )
68: is
69: SELECT
70: trunc(start_date_active) start_date_active,

Line 72: FROM QP_CURRENCY_DETAILS

68: is
69: SELECT
70: trunc(start_date_active) start_date_active,
71: trunc(end_date_active) end_date_active
72: FROM QP_CURRENCY_DETAILS
73: WHERE to_currency_code = in_to_currency_code_s and
74: currency_header_id = in_currency_header_id_n and
75: currency_detail_id <> nvl(in_currency_detail_id_n, -99999) and
76: nvl(precedence, -1) = in_precedence;