APPS.CS_SR_PREFERRED_LANG_PVT dependencies on CS_SR_PREFERRED_LANG

Line 1: PACKAGE BODY CS_SR_Preferred_Lang_PVT AS

1: PACKAGE BODY CS_SR_Preferred_Lang_PVT AS
2: /* $Header: csvprlb.pls 120.0 2006/03/23 11:28:08 spusegao noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_SR_Preferred_Lang_PVT';
5: G_INITIALIZED CONSTANT VARCHAR2(1) := 'R';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_SR_Preferred_Lang_PVT';

1: PACKAGE BODY CS_SR_Preferred_Lang_PVT AS
2: /* $Header: csvprlb.pls 120.0 2006/03/23 11:28:08 spusegao noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_SR_Preferred_Lang_PVT';
5: G_INITIALIZED CONSTANT VARCHAR2(1) := 'R';
6:
7:
8: --------------------------------------------------------------------------

Line 78: IF jtf_usr_hks.Ok_To_Execute('CS_SR_Preferred_Lang_PVT',

74: -- Make the preprocessing call to the user hooks
75: --
76: -- Pre call to the Customer Type User Hook
77: --
78: IF jtf_usr_hks.Ok_To_Execute('CS_SR_Preferred_Lang_PVT',
79: 'Create_Preferred-Language',
80: 'B', 'C') THEN
81:
82: cs_preferred_language_cuhk.Create_Preferred_Language_Pre(p_preferred_language_rec=>l_preferred_language_rec,

Line 116: IF jtf_usr_hks.Ok_To_Execute('CS_SR_Preferred_Lang_PVT',

112: END IF;
113:
114: -- Pre call to the Vertical Type User Hook
115: --
116: IF jtf_usr_hks.Ok_To_Execute('CS_SR_Preferred_Lang_PVT',
117: 'Create_Preferred_Language',
118: 'B', 'V') THEN
119:
120: cs_preferred_language_vuhk.Create_Preferred_Language_Pre(p_preferred_language_rec=>l_preferred_language_rec,

Line 155: IF jtf_usr_hks.Ok_To_Execute('CS_SR_Preferred_Language_PVT',

151: --
152: --Code to populate the global record type with the passed record type
153: --
154:
155: IF jtf_usr_hks.Ok_To_Execute('CS_SR_Preferred_Language_PVT',
156: 'Create_Preferred_Language',
157: 'B', 'I') THEN
158:
159:

Line 194: select CS_SR_PREFERRED_LANG_S.nextval

190: OR (l_preferred_language_rec.pref_lang_id is null ) THEN
191: DECLARE
192: l_key_val NUMBER;
193: BEGIN
194: select CS_SR_PREFERRED_LANG_S.nextval
195: into l_key_val
196: from dual;
197:
198: l_preferred_language_rec.pref_lang_id := l_key_val;

Line 241: from CS_SR_PREFERRED_LANG

237: DECLARE
238: l_dummy varchar2(1);
239: BEGIN
240: select 'x' into l_dummy
241: from CS_SR_PREFERRED_LANG
242: where language_code = l_preferred_language_rec.language_code;
243:
244: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
245: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);

Line 365: p_desc_flex_name => 'CS_SR_PREFERRED_LANG',

361: OR (l_preferred_language_rec.attribute_category is not null) THEN
362: Validate_Desc_Flex(
363: p_api_name => l_api_name_full,
364: p_application_short_name => 'CS',
365: p_desc_flex_name => 'CS_SR_PREFERRED_LANG',
366: p_desc_segment1 => l_preferred_language_rec.attribute1,
367: p_desc_segment2 => l_preferred_language_rec.attribute2,
368: p_desc_segment3 => l_preferred_language_rec.attribute3,
369: p_desc_segment4 => l_preferred_language_rec.attribute4,

Line 402: CS_SR_PREFERRED_LANG_PKG.INSERT_ROW (

398: --
399: -- Insert into table through the table handlers
400: --
401:
402: CS_SR_PREFERRED_LANG_PKG.INSERT_ROW (
403: X_ROWID => l_preferred_language_rec.row_id,
404: X_PREF_LANG_ID => l_preferred_language_rec.pref_lang_id,
405: X_LANGUAGE_CODE => l_preferred_language_rec.language_code,
406: X_START_DATE_ACTIVE => l_preferred_language_rec.start_date_active,

Line 440: IF jtf_usr_hks.Ok_To_Execute('CS_SR_Preferred_Language_PVT',

436: -- Make the post processing call to the user hooks
437: --
438: -- Post call to the Customer Type User Hook
439: --
440: IF jtf_usr_hks.Ok_To_Execute('CS_SR_Preferred_Language_PVT',
441: 'Create_Preferred_Language',
442: 'A', 'C') THEN
443:
444: cs_preferred_Language_cuhk.Create_Preferred_Language_Post(p_preferred_language_rec=>l_preferred_language_rec,

Line 621: FROM cs_sr_preferred_lang

617:
618:
619: CURSOR l_Preferred_Language_csr(p_id number, p_obj_num number) IS
620: SELECT *
621: FROM cs_sr_preferred_lang
622: WHERE pref_lang_id = p_id
623: AND object_version_number = p_obj_num
624: FOR UPDATE OF pref_lang_id;
625:

Line 847: from CS_SR_PREFERRED_LANG

843: DECLARE
844: l_dummy varchar2(1);
845: BEGIN
846: select 'x' into l_dummy
847: from CS_SR_PREFERRED_LANG
848: where language_code = l_preferred_language_rec.language_code
849: and pref_lang_id <> p_pref_lang_id;
850:
851: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

Line 955: p_desc_flex_name => 'CS_SR_PREFERRED_LANG',

951: OR (l_preferred_language_rec.attribute15 <> l_old_Preferred_Language_rec.attribute15) THEN
952: Validate_Desc_Flex(
953: p_api_name => l_api_name_full,
954: p_application_short_name => 'CS',
955: p_desc_flex_name => 'CS_SR_PREFERRED_LANG',
956: p_desc_segment1 => l_preferred_language_rec.attribute1,
957: p_desc_segment2 => l_preferred_language_rec.attribute2,
958: p_desc_segment3 => l_preferred_language_rec.attribute3,
959: p_desc_segment4 => l_preferred_language_rec.attribute4,

Line 1035: CS_SR_PREFERRED_LANG_PKG.UPDATE_ROW (

1031: --
1032:
1033: --dbms_output.put_line('Before Update');
1034:
1035: CS_SR_PREFERRED_LANG_PKG.UPDATE_ROW (
1036: X_PREF_LANG_ID => l_preferred_language_rec.pref_lang_id,
1037: X_LANGUAGE_CODE => l_preferred_language_rec.language_code,
1038: X_START_DATE_ACTIVE => l_preferred_language_rec.start_date_active,
1039: X_END_DATE_ACTIVE => l_preferred_language_rec.end_date_active,

Line 1464: CS_SR_PREFERRED_LANG_PKG.LOCK_ROW (

1460: )
1461: IS
1462: BEGIN
1463:
1464: CS_SR_PREFERRED_LANG_PKG.LOCK_ROW (
1465: X_PREF_LANG_ID => p_pref_lang_id,
1466: X_LANGUAGE_CODE => p_preferred_language_rec.language_code,
1467: X_START_DATE_ACTIVE => p_preferred_language_rec.start_date_active,
1468: X_END_DATE_ACTIVE => p_preferred_language_rec.end_date_active,

Line 1565: END CS_SR_Preferred_Lang_PVT;

1561:
1562: END Validate_Desc_Flex;
1563:
1564:
1565: END CS_SR_Preferred_Lang_PVT;