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.CSK_SETUP_UTILITY_PKG dependencies on FND_API

Line 211: p_init_msg_list in varchar2 := FND_API.G_FALSE,

207: -- Validate common data setup for: category group, solution type, statement
208: -- type, visibility, authoring flow.
209: PROCEDURE Validate_Seeded_Setups(
210: p_api_version in number,
211: p_init_msg_list in varchar2 := FND_API.G_FALSE,
212: p_commit in varchar2 := FND_API.G_FALSE,
213: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY varchar2,
215: x_msg_count OUT NOCOPY number,

Line 212: p_commit in varchar2 := FND_API.G_FALSE,

208: -- type, visibility, authoring flow.
209: PROCEDURE Validate_Seeded_Setups(
210: p_api_version in number,
211: p_init_msg_list in varchar2 := FND_API.G_FALSE,
212: p_commit in varchar2 := FND_API.G_FALSE,
213: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY varchar2,
215: x_msg_count OUT NOCOPY number,
216: x_msg_data OUT NOCOPY varchar2)

Line 213: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

209: PROCEDURE Validate_Seeded_Setups(
210: p_api_version in number,
211: p_init_msg_list in varchar2 := FND_API.G_FALSE,
212: p_commit in varchar2 := FND_API.G_FALSE,
213: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY varchar2,
215: x_msg_count OUT NOCOPY number,
216: x_msg_data OUT NOCOPY varchar2)
217: IS

Line 354: if fnd_api.to_boolean( p_commit ) then

350: VALUES (-2,FLOW_API_TEST_FLOW,'PUBLISHED',20, 'PUB',100000121, -1351,sysdate,-1351,sysdate,-1351);
351: -------------------------------------------------------------
352: -------------------------------------------------------------
353:
354: if fnd_api.to_boolean( p_commit ) then
355: commit;
356: end if;
357: END Validate_Seeded_Setups;
358:

Line 362: p_init_msg_list in varchar2 := FND_API.G_FALSE,

358:
359: --Create category
360: PROCEDURE Create_Category (
361: p_api_version in number,
362: p_init_msg_list in varchar2 := FND_API.G_FALSE,
363: p_commit in varchar2 := FND_API.G_FALSE,
364: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
365: x_return_status OUT NOCOPY varchar2,
366: x_msg_count OUT NOCOPY number,

Line 363: p_commit in varchar2 := FND_API.G_FALSE,

359: --Create category
360: PROCEDURE Create_Category (
361: p_api_version in number,
362: p_init_msg_list in varchar2 := FND_API.G_FALSE,
363: p_commit in varchar2 := FND_API.G_FALSE,
364: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
365: x_return_status OUT NOCOPY varchar2,
366: x_msg_count OUT NOCOPY number,
367: x_msg_data OUT NOCOPY varchar2,

Line 364: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

360: PROCEDURE Create_Category (
361: p_api_version in number,
362: p_init_msg_list in varchar2 := FND_API.G_FALSE,
363: p_commit in varchar2 := FND_API.G_FALSE,
364: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
365: x_return_status OUT NOCOPY varchar2,
366: x_msg_count OUT NOCOPY number,
367: x_msg_data OUT NOCOPY varchar2,
368: P_PARENT_CATEGORY_ID IN NUMBER,

Line 448: if fnd_api.to_boolean( p_commit ) then

444: SET VISIBILITY_ID = P_VISIBILITY_ID,
445: VISIBILITY_POSITION = l_posn
446: WHERE CHILD_CATEGORY_ID = P_CATEGORY_ID;
447:
448: if fnd_api.to_boolean( p_commit ) then
449: commit;
450: end if;
451: END Create_Category;
452:

Line 456: p_init_msg_list in varchar2 := FND_API.G_FALSE,

452:
453: --Delete category
454: procedure Delete_Category(
455: p_api_version in number,
456: p_init_msg_list in varchar2 := FND_API.G_FALSE,
457: p_commit in varchar2 := FND_API.G_FALSE,
458: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
459: x_return_status OUT NOCOPY varchar2,
460: x_msg_count OUT NOCOPY number,

Line 457: p_commit in varchar2 := FND_API.G_FALSE,

453: --Delete category
454: procedure Delete_Category(
455: p_api_version in number,
456: p_init_msg_list in varchar2 := FND_API.G_FALSE,
457: p_commit in varchar2 := FND_API.G_FALSE,
458: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
459: x_return_status OUT NOCOPY varchar2,
460: x_msg_count OUT NOCOPY number,
461: x_msg_data OUT NOCOPY varchar2,

Line 458: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

454: procedure Delete_Category(
455: p_api_version in number,
456: p_init_msg_list in varchar2 := FND_API.G_FALSE,
457: p_commit in varchar2 := FND_API.G_FALSE,
458: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
459: x_return_status OUT NOCOPY varchar2,
460: x_msg_count OUT NOCOPY number,
461: x_msg_data OUT NOCOPY varchar2,
462: p_category_id in number)

Line 479: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

475: select count( * ) into n_subcatgories
476: from cs_kb_soln_categories_b
477: where parent_category_id = p_category_id;
478:
479: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
480: -- check if the category is deletable
481: -- i.e. it does not contain sub-categories nor PUBlished child solutions
482: if( n_child_solutions <> 0 OR n_subcatgories <> 0 ) then
483: FND_MSG_PUB.initialize;

Line 486: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

482: if( n_child_solutions <> 0 OR n_subcatgories <> 0 ) then
483: FND_MSG_PUB.initialize;
484: FND_MESSAGE.set_name('CS', 'CS_KB_C_CAT_DELETE_FAILED');
485: FND_MSG_PUB.ADD;
486: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
488: p_count => X_MSG_COUNT,
489: p_data => X_MSG_DATA);
490:

Line 487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

483: FND_MSG_PUB.initialize;
484: FND_MESSAGE.set_name('CS', 'CS_KB_C_CAT_DELETE_FAILED');
485: FND_MSG_PUB.ADD;
486: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
488: p_count => X_MSG_COUNT,
489: p_data => X_MSG_DATA);
490:
491: ELSE

Line 511: if fnd_api.to_boolean( p_commit ) then

507: -- Removes Category from Denorm table if the Category Exists
508: DELETE FROM CS_KB_CAT_GROUP_DENORM
509: WHERE Child_Category_Id = P_CATEGORY_ID;
510:
511: if fnd_api.to_boolean( p_commit ) then
512: commit;
513: end if;
514: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
515: end if;

Line 514: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

510:
511: if fnd_api.to_boolean( p_commit ) then
512: commit;
513: end if;
514: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
515: end if;
516: end Delete_Category;
517:
518: --Create solution

Line 522: p_init_msg_list in varchar2 := FND_API.G_FALSE,

518: --Create solution
519: -- !!! Incomplete: missing the way to submit it to a certain flow.
520: PROCEDURE Create_Solution (
521: p_api_version in number,
522: p_init_msg_list in varchar2 := FND_API.G_FALSE,
523: p_commit in varchar2 := FND_API.G_FALSE,
524: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
525: x_return_status OUT NOCOPY varchar2,
526: x_msg_count OUT NOCOPY number,

Line 523: p_commit in varchar2 := FND_API.G_FALSE,

519: -- !!! Incomplete: missing the way to submit it to a certain flow.
520: PROCEDURE Create_Solution (
521: p_api_version in number,
522: p_init_msg_list in varchar2 := FND_API.G_FALSE,
523: p_commit in varchar2 := FND_API.G_FALSE,
524: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
525: x_return_status OUT NOCOPY varchar2,
526: x_msg_count OUT NOCOPY number,
527: x_msg_data OUT NOCOPY varchar2,

Line 524: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

520: PROCEDURE Create_Solution (
521: p_api_version in number,
522: p_init_msg_list in varchar2 := FND_API.G_FALSE,
523: p_commit in varchar2 := FND_API.G_FALSE,
524: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
525: x_return_status OUT NOCOPY varchar2,
526: x_msg_count OUT NOCOPY number,
527: x_msg_data OUT NOCOPY varchar2,
528: P_SOLN_REC IN Soln_rec_type,

Line 743: if fnd_api.to_boolean( p_commit ) then

739: -1351,
740: -1351);
741: i2 := P_CAT_TBL.NEXT(i2);
742: end loop;
743: if fnd_api.to_boolean( p_commit ) then
744: commit;
745: end if;
746: END Create_Solution;
747:

Line 752: p_init_msg_list in varchar2 := FND_API.G_FALSE,

748:
749: --Delete solution
750: PROCEDURE Delete_Solution (
751: p_api_version in number,
752: p_init_msg_list in varchar2 := FND_API.G_FALSE,
753: p_commit in varchar2 := FND_API.G_FALSE,
754: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
755: x_return_status OUT NOCOPY varchar2,
756: x_msg_count OUT NOCOPY number,

Line 753: p_commit in varchar2 := FND_API.G_FALSE,

749: --Delete solution
750: PROCEDURE Delete_Solution (
751: p_api_version in number,
752: p_init_msg_list in varchar2 := FND_API.G_FALSE,
753: p_commit in varchar2 := FND_API.G_FALSE,
754: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
755: x_return_status OUT NOCOPY varchar2,
756: x_msg_count OUT NOCOPY number,
757: x_msg_data OUT NOCOPY varchar2,

Line 754: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

750: PROCEDURE Delete_Solution (
751: p_api_version in number,
752: p_init_msg_list in varchar2 := FND_API.G_FALSE,
753: p_commit in varchar2 := FND_API.G_FALSE,
754: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
755: x_return_status OUT NOCOPY varchar2,
756: x_msg_count OUT NOCOPY number,
757: x_msg_data OUT NOCOPY varchar2,
758: P_SET_ID IN NUMBER)

Line 781: if fnd_api.to_boolean( p_commit ) then

777: DELETE FROM CS_KB_ELEMENTS_TL WHERE ELEMENT_ID = l_element_id;
778: DELETE FROM CS_KB_SET_ELES WHERE SET_ID = P_SET_ID and ELEMENT_ID = l_element_id;
779: END LOOP;
780: CLOSE Get_Elements;
781: if fnd_api.to_boolean( p_commit ) then
782: commit;
783: end if;
784: END Delete_Solution;
785:

Line 789: p_init_msg_list in varchar2 := FND_API.G_FALSE,

785:
786: --Delete solution
787: PROCEDURE Obsolete_Solution (
788: p_api_version in number,
789: p_init_msg_list in varchar2 := FND_API.G_FALSE,
790: p_commit in varchar2 := FND_API.G_FALSE,
791: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
792: x_return_status OUT NOCOPY varchar2,
793: x_msg_count OUT NOCOPY number,

Line 790: p_commit in varchar2 := FND_API.G_FALSE,

786: --Delete solution
787: PROCEDURE Obsolete_Solution (
788: p_api_version in number,
789: p_init_msg_list in varchar2 := FND_API.G_FALSE,
790: p_commit in varchar2 := FND_API.G_FALSE,
791: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
792: x_return_status OUT NOCOPY varchar2,
793: x_msg_count OUT NOCOPY number,
794: x_msg_data OUT NOCOPY varchar2,

Line 791: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

787: PROCEDURE Obsolete_Solution (
788: p_api_version in number,
789: p_init_msg_list in varchar2 := FND_API.G_FALSE,
790: p_commit in varchar2 := FND_API.G_FALSE,
791: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
792: x_return_status OUT NOCOPY varchar2,
793: x_msg_count OUT NOCOPY number,
794: x_msg_data OUT NOCOPY varchar2,
795: P_SET_ID IN NUMBER)