APPS.OTA_AME_ATTRIBUTES dependencies on STANDARD

Line 61: -- |------------------------< get_class_standard_price >-------------------------|

57:
58:
59:
60: -- ------------------------------------------------------------------------
61: -- |------------------------< get_class_standard_price >-------------------------|
62: -- ------------------------------------------------------------------------
63: --
64: -- Description
65: --

Line 66: -- Get the class standard price

62: -- ------------------------------------------------------------------------
63: --
64: -- Description
65: --
66: -- Get the class standard price
67: --
68:
69: function get_class_standard_price
70: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

Line 69: function get_class_standard_price

65: --
66: -- Get the class standard price
67: --
68:
69: function get_class_standard_price
70: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
71: return number is
72: c_class_standard_price ota_events.standard_price%type;
73: c_event_id ota_events.event_id%type;

Line 72: c_class_standard_price ota_events.standard_price%type;

68:
69: function get_class_standard_price
70: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
71: return number is
72: c_class_standard_price ota_events.standard_price%type;
73: c_event_id ota_events.event_id%type;
74: c_item_type varchar2(50);
75: c_item_key varchar2(100);
76:

Line 77: cursor c_get_standard_price is

73: c_event_id ota_events.event_id%type;
74: c_item_type varchar2(50);
75: c_item_key varchar2(100);
76:
77: cursor c_get_standard_price is
78: select standard_price
79: from ota_events
80: where event_id = c_event_id;
81:

Line 78: select standard_price

74: c_item_type varchar2(50);
75: c_item_key varchar2(100);
76:
77: cursor c_get_standard_price is
78: select standard_price
79: from ota_events
80: where event_id = c_event_id;
81:
82: begin

Line 94: c_class_standard_price := null;

90: , ignore_notfound => TRUE);
91:
92: IF c_event_id is null then
93:
94: c_class_standard_price := null;
95:
96: else
97:
98: open c_get_standard_price;

Line 98: open c_get_standard_price;

94: c_class_standard_price := null;
95:
96: else
97:
98: open c_get_standard_price;
99: fetch c_get_standard_price into c_class_standard_price;
100: close c_get_standard_price;
101: end if;
102: return c_class_standard_price;

Line 99: fetch c_get_standard_price into c_class_standard_price;

95:
96: else
97:
98: open c_get_standard_price;
99: fetch c_get_standard_price into c_class_standard_price;
100: close c_get_standard_price;
101: end if;
102: return c_class_standard_price;
103: EXCEPTION

Line 100: close c_get_standard_price;

96: else
97:
98: open c_get_standard_price;
99: fetch c_get_standard_price into c_class_standard_price;
100: close c_get_standard_price;
101: end if;
102: return c_class_standard_price;
103: EXCEPTION
104: WHEN OTHERS THEN

Line 102: return c_class_standard_price;

98: open c_get_standard_price;
99: fetch c_get_standard_price into c_class_standard_price;
100: close c_get_standard_price;
101: end if;
102: return c_class_standard_price;
103: EXCEPTION
104: WHEN OTHERS THEN
105: WF_CORE.CONTEXT(g_package,'get_class_standard_price',c_item_type,c_item_key);
106: RAISE;

Line 105: WF_CORE.CONTEXT(g_package,'get_class_standard_price',c_item_type,c_item_key);

101: end if;
102: return c_class_standard_price;
103: EXCEPTION
104: WHEN OTHERS THEN
105: WF_CORE.CONTEXT(g_package,'get_class_standard_price',c_item_type,c_item_key);
106: RAISE;
107:
108:
109: end get_class_standard_price;

Line 109: end get_class_standard_price;

105: WF_CORE.CONTEXT(g_package,'get_class_standard_price',c_item_type,c_item_key);
106: RAISE;
107:
108:
109: end get_class_standard_price;
110:
111: -- ------------------------------------------------------------------------
112: -- |------------------------< get_Learning_path_name >----------------|
113: -- ------------------------------------------------------------------------