APPS.OT_WORKFLOW_SS dependencies on STANDARD

Line 73: -- |------------------------< Get_event_standard_price >-------------------------|

69:
70:
71:
72: -- ------------------------------------------------------------------------
73: -- |------------------------< Get_event_standard_price >-------------------------|
74: -- ------------------------------------------------------------------------
75: --
76: -- Description
77: --

Line 78: -- Get the event standard price

74: -- ------------------------------------------------------------------------
75: --
76: -- Description
77: --
78: -- Get the event standard price
79: --
80:
81: function get_event_standard_price
82: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)

Line 81: function get_event_standard_price

77: --
78: -- Get the event standard price
79: --
80:
81: function get_event_standard_price
82: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
83: return number is
84: c_event_standard_price ota_events.standard_price%type;
85: c_event_id ota_events.event_id%type;

Line 84: c_event_standard_price ota_events.standard_price%type;

80:
81: function get_event_standard_price
82: (p_transaction_id IN hr_api_transactions.transaction_id%TYPE)
83: return number is
84: c_event_standard_price ota_events.standard_price%type;
85: c_event_id ota_events.event_id%type;
86: c_item_type varchar2(50);
87: c_item_key varchar2(100);
88:

Line 89: cursor c_get_standard_price is

85: c_event_id ota_events.event_id%type;
86: c_item_type varchar2(50);
87: c_item_key varchar2(100);
88:
89: cursor c_get_standard_price is
90: select standard_price
91: from ota_events
92: where event_id = c_event_id;
93:

Line 90: select standard_price

86: c_item_type varchar2(50);
87: c_item_key varchar2(100);
88:
89: cursor c_get_standard_price is
90: select standard_price
91: from ota_events
92: where event_id = c_event_id;
93:
94: begin

Line 104: c_event_standard_price := null;

100: itemkey => c_item_key,
101: aname => 'OTA_EVENT_ID',
102: ignore_notfound => TRUE);
103: if c_event_id is null then
104: c_event_standard_price := null;
105: else
106: open c_get_standard_price;
107: fetch c_get_standard_price into c_event_standard_price;
108: close c_get_standard_price;

Line 106: open c_get_standard_price;

102: ignore_notfound => TRUE);
103: if c_event_id is null then
104: c_event_standard_price := null;
105: else
106: open c_get_standard_price;
107: fetch c_get_standard_price into c_event_standard_price;
108: close c_get_standard_price;
109: end if;
110:

Line 107: fetch c_get_standard_price into c_event_standard_price;

103: if c_event_id is null then
104: c_event_standard_price := null;
105: else
106: open c_get_standard_price;
107: fetch c_get_standard_price into c_event_standard_price;
108: close c_get_standard_price;
109: end if;
110:
111: return c_event_standard_price;

Line 108: close c_get_standard_price;

104: c_event_standard_price := null;
105: else
106: open c_get_standard_price;
107: fetch c_get_standard_price into c_event_standard_price;
108: close c_get_standard_price;
109: end if;
110:
111: return c_event_standard_price;
112:

Line 111: return c_event_standard_price;

107: fetch c_get_standard_price into c_event_standard_price;
108: close c_get_standard_price;
109: end if;
110:
111: return c_event_standard_price;
112:
113: EXCEPTION
114: WHEN OTHERS THEN
115: WF_CORE.CONTEXT(g_package,'get_event_standard_price',c_item_type,c_item_key);

Line 115: WF_CORE.CONTEXT(g_package,'get_event_standard_price',c_item_type,c_item_key);

111: return c_event_standard_price;
112:
113: EXCEPTION
114: WHEN OTHERS THEN
115: WF_CORE.CONTEXT(g_package,'get_event_standard_price',c_item_type,c_item_key);
116: RAISE;
117:
118:
119: end get_event_standard_price;

Line 119: end get_event_standard_price;

115: WF_CORE.CONTEXT(g_package,'get_event_standard_price',c_item_type,c_item_key);
116: RAISE;
117:
118:
119: end get_event_standard_price;
120:
121:
122: -- ------------------------------------------------------------------------
123: -- |------------------------< Get_activity_type >-------------------------|