APPS.CSC_PLAN_HEADERS_B_PKG dependencies on FND_API

Line 47: -- 11-25-2002 bhroy FND_API default removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK

43: -- INSERT_ROW, UPDATE_ROW and LOAD_ROW.
44: -- Added the dbdrv command.
45: -- 05-23-2002 dejoseph Added checkfile syntax.
46: -- 11-12-2002 bhroy NOCOPY changes made
47: -- 11-25-2002 bhroy FND_API default removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK
48: -- 05-24-2004 bhroy Commetend Application ID update for CSC_PLAN_HEADERS_B table, fixed bug# 3643065
49: -- 19-july-2005 tpalaniv Modified the translate_row and load_row APIs to fetch last_updated_by using FND API
50: --
51: -- NOTE :

Line 49: -- 19-july-2005 tpalaniv Modified the translate_row and load_row APIs to fetch last_updated_by using FND API

45: -- 05-23-2002 dejoseph Added checkfile syntax.
46: -- 11-12-2002 bhroy NOCOPY changes made
47: -- 11-25-2002 bhroy FND_API default removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK
48: -- 05-24-2004 bhroy Commetend Application ID update for CSC_PLAN_HEADERS_B table, fixed bug# 3643065
49: -- 19-july-2005 tpalaniv Modified the translate_row and load_row APIs to fetch last_updated_by using FND API
50: --
51: -- NOTE :
52: -- End of Comments
53:

Line 114: If (px_PLAN_ID IS NULL) OR (px_PLAN_ID = FND_API.G_MISS_NUM) then

110: l_seeded_flag VARCHAR2(3);
111: l_application_id NUMBER;
112:
113: BEGIN
114: If (px_PLAN_ID IS NULL) OR (px_PLAN_ID = FND_API.G_MISS_NUM) then
115: OPEN C2;
116: FETCH C2 INTO px_PLAN_ID;
117: CLOSE C2;
118: End If;

Line 127: if ( p_application_id = fnd_api.g_miss_num ) then

123: else
124: l_seeded_flag := 'N';
125: end if;
126:
127: if ( p_application_id = fnd_api.g_miss_num ) then
128: l_application_id := NULL;
129: else
130: l_application_id := p_application_id;
131: end if;

Line 292: if ( p_application_id = fnd_api.g_miss_num ) then

288: else
289: l_seeded_flag := 'N';
290: end if;
291:
292: if ( p_application_id = fnd_api.g_miss_num ) then
293: l_application_id := NULL;
294: else
295: l_application_id := p_application_id;
296: end if;

Line 491: last_updated_by = fnd_load_util.owner_id(p_owner), /* R12 ATG Project: Removed the decode logic and using FND API*/

487: UPDATE csc_plan_headers_tl
488: SET name = p_name,
489: description = NVL(p_description,description),
490: last_update_date = sysdate,
491: last_updated_by = fnd_load_util.owner_id(p_owner), /* R12 ATG Project: Removed the decode logic and using FND API*/
492: last_update_login = 0,
493: source_lang = userenv('LANG')
494: WHERE plan_id = p_plan_id
495: AND userenv('LANG') IN (language, source_lang) ;