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.IRC_IRT_SHD dependencies on IRC_IRT_SHD

Line 1: Package Body irc_irt_shd as

1: Package Body irc_irt_shd as
2: /* $Header: irirtrhi.pkb 120.0 2005/07/26 15:10 mbocutt noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' irc_irt_shd.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' irc_irt_shd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |---------------------------< constraint_error >---------------------------|
12: -- ----------------------------------------------------------------------------

Line 74: = irc_irt_shd.g_old_rec.recruiting_site_id and

70: --
71: l_fct_ret := false;
72: Else
73: If (p_recruiting_site_id
74: = irc_irt_shd.g_old_rec.recruiting_site_id and
75: p_language
76: = irc_irt_shd.g_old_rec.language
77: ) Then
78: --

Line 76: = irc_irt_shd.g_old_rec.language

72: Else
73: If (p_recruiting_site_id
74: = irc_irt_shd.g_old_rec.recruiting_site_id and
75: p_language
76: = irc_irt_shd.g_old_rec.language
77: ) Then
78: --
79: -- The g_old_rec is current therefore we must
80: -- set the returning function to true

Line 88: Fetch C_Sel1 Into irc_irt_shd.g_old_rec;

84: --
85: -- Select the current row into g_old_rec
86: --
87: Open C_Sel1;
88: Fetch C_Sel1 Into irc_irt_shd.g_old_rec;
89: If C_Sel1%notfound Then
90: Close C_Sel1;
91: --
92: -- The primary key is invalid therefore we must error

Line 99: irc_irt_shd.g_old_rec.redirection_url

95: fnd_message.raise_error;
96: End If;
97: Close C_Sel1;
98: --
99: irc_irt_shd.g_old_rec.redirection_url
100: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
101: irc_irt_shd.g_old_rec.posting_url
102: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
103: l_fct_ret := true;

Line 100: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);

96: End If;
97: Close C_Sel1;
98: --
99: irc_irt_shd.g_old_rec.redirection_url
100: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
101: irc_irt_shd.g_old_rec.posting_url
102: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
103: l_fct_ret := true;
104: End If;

Line 101: irc_irt_shd.g_old_rec.posting_url

97: Close C_Sel1;
98: --
99: irc_irt_shd.g_old_rec.redirection_url
100: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
101: irc_irt_shd.g_old_rec.posting_url
102: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
103: l_fct_ret := true;
104: End If;
105: End If;

Line 102: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);

98: --
99: irc_irt_shd.g_old_rec.redirection_url
100: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
101: irc_irt_shd.g_old_rec.posting_url
102: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
103: l_fct_ret := true;
104: End If;
105: End If;
106: Return (l_fct_ret);

Line 153: Fetch C_Sel1 Into irc_irt_shd.g_old_rec;

149: ,p_argument_value => p_language
150: );
151: --
152: Open C_Sel1;
153: Fetch C_Sel1 Into irc_irt_shd.g_old_rec;
154: If C_Sel1%notfound then
155: Close C_Sel1;
156: --
157: -- The primary key is invalid therefore we must error

Line 164: irc_irt_shd.g_old_rec.redirection_url

160: fnd_message.raise_error;
161: End If;
162: Close C_Sel1;
163: --
164: irc_irt_shd.g_old_rec.redirection_url
165: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
166: irc_irt_shd.g_old_rec.posting_url
167: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
168: --

Line 165: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);

161: End If;
162: Close C_Sel1;
163: --
164: irc_irt_shd.g_old_rec.redirection_url
165: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
166: irc_irt_shd.g_old_rec.posting_url
167: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 166: irc_irt_shd.g_old_rec.posting_url

162: Close C_Sel1;
163: --
164: irc_irt_shd.g_old_rec.redirection_url
165: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
166: irc_irt_shd.g_old_rec.posting_url
167: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: --

Line 167: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);

163: --
164: irc_irt_shd.g_old_rec.redirection_url
165: := dbms_lob.substr(irc_irt_shd.g_old_rec.redirection_url_c);
166: irc_irt_shd.g_old_rec.posting_url
167: := dbms_lob.substr(irc_irt_shd.g_old_rec.posting_url_c);
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: --
171: -- We need to trap the ORA LOCK exception

Line 283: end irc_irt_shd;

279: Return(l_rec);
280: --
281: End convert_args;
282: --
283: end irc_irt_shd;