APPS.IRC_IPT_UPD dependencies on IRC_POSTING_CONTENTS_TL

Line 66: -- Update the irc_posting_contents_tl Row

62: --
63: --
64: --
65: --
66: -- Update the irc_posting_contents_tl Row
67: --
68: if irc_ipt_shd.g_org_description_upd then
69: update irc_posting_contents_tl
70: set org_description = empty_clob()

Line 69: update irc_posting_contents_tl

65: --
66: -- Update the irc_posting_contents_tl Row
67: --
68: if irc_ipt_shd.g_org_description_upd then
69: update irc_posting_contents_tl
70: set org_description = empty_clob()
71: where posting_content_id = p_rec.posting_content_id
72: and language = p_rec.language;
73: end if;

Line 76: update irc_posting_contents_tl

72: and language = p_rec.language;
73: end if;
74: --
75: if irc_ipt_shd.g_brief_description_upd then
76: update irc_posting_contents_tl
77: set brief_description = empty_clob()
78: where posting_content_id = p_rec.posting_content_id
79: and language = p_rec.language;
80: end if;

Line 83: update irc_posting_contents_tl

79: and language = p_rec.language;
80: end if;
81: --
82: if irc_ipt_shd.g_detailed_description_upd then
83: update irc_posting_contents_tl
84: set detailed_description = empty_clob()
85: where posting_content_id = p_rec.posting_content_id
86: and language = p_rec.language;
87: end if;

Line 90: update irc_posting_contents_tl

86: and language = p_rec.language;
87: end if;
88: --
89: if irc_ipt_shd.g_job_requirements_upd then
90: update irc_posting_contents_tl
91: set job_requirements = empty_clob()
92: where posting_content_id = p_rec.posting_content_id
93: and language = p_rec.language;
94: end if;

Line 97: update irc_posting_contents_tl

93: and language = p_rec.language;
94: end if;
95: --
96: if irc_ipt_shd.g_additional_details_upd then
97: update irc_posting_contents_tl
98: set additional_details = empty_clob()
99: where posting_content_id = p_rec.posting_content_id
100: and language = p_rec.language;
101: end if;

Line 104: update irc_posting_contents_tl

100: and language = p_rec.language;
101: end if;
102: --
103: if irc_ipt_shd.g_how_to_apply_upd then
104: update irc_posting_contents_tl
105: set how_to_apply = empty_clob()
106: where posting_content_id = p_rec.posting_content_id
107: and language = p_rec.language;
108: end if;

Line 111: update irc_posting_contents_tl

107: and language = p_rec.language;
108: end if;
109: --
110: if irc_ipt_shd.g_image_url_upd then
111: update irc_posting_contents_tl
112: set image_url = empty_clob()
113: where posting_content_id = p_rec.posting_content_id
114: and language = p_rec.language;
115: end if;

Line 118: update irc_posting_contents_tl

114: and language = p_rec.language;
115: end if;
116: --
117: if irc_ipt_shd.g_image_url_alt_upd then
118: update irc_posting_contents_tl
119: set image_url_alt = empty_clob()
120: where posting_content_id = p_rec.posting_content_id
121: and language = p_rec.language;
122: end if;

Line 125: update irc_posting_contents_tl

121: and language = p_rec.language;
122: end if;
123: --
124: --
125: update irc_posting_contents_tl
126: set
127: posting_content_id = p_rec.posting_content_id
128: ,language = p_rec.language
129: ,source_language = p_rec.source_language

Line 314: (p_module_name => 'IRC_POSTING_CONTENTS_TL'

310: --
311: when hr_api.cannot_find_prog_unit then
312: --
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'IRC_POSTING_CONTENTS_TL'
315: ,p_hook_type => 'AU');
316: --
317: end;
318: --

Line 582: from irc_posting_contents_tl ipt

578: -- source_lang match the specified language.
579: --
580: cursor csr_upd_langs is
581: select ipt.language
582: from irc_posting_contents_tl ipt
583: where ipt.posting_content_id = p_posting_content_id
584: and p_language_code in (ipt.language
585: ,ipt.source_language);
586: --