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_DIAG_SOLUTION_PVT dependencies on CSK_SETUP_UTILITY_PKG

Line 22: l_P_SET_DEF_REC CSK_SETUP_UTILITY_PKG.Soln_rec_type;

18: l_return_status varchar2(1) := '';
19: l_msg_count number := 0;
20: l_msg_data varchar2(4000) := '';
21:
22: l_P_SET_DEF_REC CSK_SETUP_UTILITY_PKG.Soln_rec_type;
23: l_P_ELE_DEF_TBL CSK_SETUP_UTILITY_PKG.Stmt_tbl_type;
24: l_P_CAT_DEF_TBL CSK_SETUP_UTILITY_PKG.Cat_tbl_type;
25: BEGIN
26: FND_GLOBAL.APPS_initialize(1000667,21782,170,null,null);

Line 23: l_P_ELE_DEF_TBL CSK_SETUP_UTILITY_PKG.Stmt_tbl_type;

19: l_msg_count number := 0;
20: l_msg_data varchar2(4000) := '';
21:
22: l_P_SET_DEF_REC CSK_SETUP_UTILITY_PKG.Soln_rec_type;
23: l_P_ELE_DEF_TBL CSK_SETUP_UTILITY_PKG.Stmt_tbl_type;
24: l_P_CAT_DEF_TBL CSK_SETUP_UTILITY_PKG.Cat_tbl_type;
25: BEGIN
26: FND_GLOBAL.APPS_initialize(1000667,21782,170,null,null);
27: CSK_SETUP_UTILITY_PKG.validate_seeded_setups(p_api_version => 1.0,

Line 24: l_P_CAT_DEF_TBL CSK_SETUP_UTILITY_PKG.Cat_tbl_type;

20: l_msg_data varchar2(4000) := '';
21:
22: l_P_SET_DEF_REC CSK_SETUP_UTILITY_PKG.Soln_rec_type;
23: l_P_ELE_DEF_TBL CSK_SETUP_UTILITY_PKG.Stmt_tbl_type;
24: l_P_CAT_DEF_TBL CSK_SETUP_UTILITY_PKG.Cat_tbl_type;
25: BEGIN
26: FND_GLOBAL.APPS_initialize(1000667,21782,170,null,null);
27: CSK_SETUP_UTILITY_PKG.validate_seeded_setups(p_api_version => 1.0,
28: x_return_status => l_return_status,

Line 27: CSK_SETUP_UTILITY_PKG.validate_seeded_setups(p_api_version => 1.0,

23: l_P_ELE_DEF_TBL CSK_SETUP_UTILITY_PKG.Stmt_tbl_type;
24: l_P_CAT_DEF_TBL CSK_SETUP_UTILITY_PKG.Cat_tbl_type;
25: BEGIN
26: FND_GLOBAL.APPS_initialize(1000667,21782,170,null,null);
27: CSK_SETUP_UTILITY_PKG.validate_seeded_setups(p_api_version => 1.0,
28: x_return_status => l_return_status,
29: x_msg_count => l_msg_count,
30: x_msg_data => l_msg_data);
31: --MOVE_SOLUTIONS_TEST

Line 32: g_move_solutions_test_c1ID := CSK_SETUP_UTILITY_PKG.get_next_category_id();

28: x_return_status => l_return_status,
29: x_msg_count => l_msg_count,
30: x_msg_data => l_msg_data);
31: --MOVE_SOLUTIONS_TEST
32: g_move_solutions_test_c1ID := CSK_SETUP_UTILITY_PKG.get_next_category_id();
33: CSK_SETUP_UTILITY_PKG.Create_Category (
34: p_api_version => 1.0,
35: x_return_status => l_return_status,
36: x_msg_count => l_msg_count,

Line 33: CSK_SETUP_UTILITY_PKG.Create_Category (

29: x_msg_count => l_msg_count,
30: x_msg_data => l_msg_data);
31: --MOVE_SOLUTIONS_TEST
32: g_move_solutions_test_c1ID := CSK_SETUP_UTILITY_PKG.get_next_category_id();
33: CSK_SETUP_UTILITY_PKG.Create_Category (
34: p_api_version => 1.0,
35: x_return_status => l_return_status,
36: x_msg_count => l_msg_count,
37: x_msg_data => l_msg_data,

Line 41: P_VISIBILITY_ID => CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST);

37: x_msg_data => l_msg_data,
38: P_PARENT_CATEGORY_ID => 1,
39: P_CATEGORY_ID => g_move_solutions_test_c1ID,
40: P_CATEGORY_NAME => 'Move Solutions Test Category c1',
41: P_VISIBILITY_ID => CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST);
42:
43: g_move_solutions_test_c2ID := CSK_SETUP_UTILITY_PKG.get_next_category_id();
44: CSK_SETUP_UTILITY_PKG.Create_Category (
45: p_api_version => 1.0,

Line 43: g_move_solutions_test_c2ID := CSK_SETUP_UTILITY_PKG.get_next_category_id();

39: P_CATEGORY_ID => g_move_solutions_test_c1ID,
40: P_CATEGORY_NAME => 'Move Solutions Test Category c1',
41: P_VISIBILITY_ID => CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST);
42:
43: g_move_solutions_test_c2ID := CSK_SETUP_UTILITY_PKG.get_next_category_id();
44: CSK_SETUP_UTILITY_PKG.Create_Category (
45: p_api_version => 1.0,
46: x_return_status => l_return_status,
47: x_msg_count => l_msg_count,

Line 44: CSK_SETUP_UTILITY_PKG.Create_Category (

40: P_CATEGORY_NAME => 'Move Solutions Test Category c1',
41: P_VISIBILITY_ID => CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST);
42:
43: g_move_solutions_test_c2ID := CSK_SETUP_UTILITY_PKG.get_next_category_id();
44: CSK_SETUP_UTILITY_PKG.Create_Category (
45: p_api_version => 1.0,
46: x_return_status => l_return_status,
47: x_msg_count => l_msg_count,
48: x_msg_data => l_msg_data,

Line 52: P_VISIBILITY_ID => CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST);

48: x_msg_data => l_msg_data,
49: P_PARENT_CATEGORY_ID => 1,
50: P_CATEGORY_ID => g_move_solutions_test_c2ID,
51: P_CATEGORY_NAME => 'Move Solutions Test Category c2',
52: P_VISIBILITY_ID => CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST);
53:
54:
55: g_move_solutions_test_s1_aID := CSK_SETUP_UTILITY_PKG.get_next_set_id();
56: l_P_SET_DEF_REC.SET_ID := g_move_solutions_test_s1_aID;

Line 55: g_move_solutions_test_s1_aID := CSK_SETUP_UTILITY_PKG.get_next_set_id();

51: P_CATEGORY_NAME => 'Move Solutions Test Category c2',
52: P_VISIBILITY_ID => CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST);
53:
54:
55: g_move_solutions_test_s1_aID := CSK_SETUP_UTILITY_PKG.get_next_set_id();
56: l_P_SET_DEF_REC.SET_ID := g_move_solutions_test_s1_aID;
57: l_P_SET_DEF_REC.SET_NUMBER := CSK_SETUP_UTILITY_PKG.get_next_set_number();
58: l_P_SET_DEF_REC.SET_TYPE_ID := CSK_SETUP_UTILITY_PKG.SOLN_TYPE_FAQ_API_TEST;
59: l_P_SET_DEF_REC.NAME := 'Move Solution Test s1_a';

Line 57: l_P_SET_DEF_REC.SET_NUMBER := CSK_SETUP_UTILITY_PKG.get_next_set_number();

53:
54:
55: g_move_solutions_test_s1_aID := CSK_SETUP_UTILITY_PKG.get_next_set_id();
56: l_P_SET_DEF_REC.SET_ID := g_move_solutions_test_s1_aID;
57: l_P_SET_DEF_REC.SET_NUMBER := CSK_SETUP_UTILITY_PKG.get_next_set_number();
58: l_P_SET_DEF_REC.SET_TYPE_ID := CSK_SETUP_UTILITY_PKG.SOLN_TYPE_FAQ_API_TEST;
59: l_P_SET_DEF_REC.NAME := 'Move Solution Test s1_a';
60: l_P_SET_DEF_REC.visibility_id := CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST;
61:

Line 58: l_P_SET_DEF_REC.SET_TYPE_ID := CSK_SETUP_UTILITY_PKG.SOLN_TYPE_FAQ_API_TEST;

54:
55: g_move_solutions_test_s1_aID := CSK_SETUP_UTILITY_PKG.get_next_set_id();
56: l_P_SET_DEF_REC.SET_ID := g_move_solutions_test_s1_aID;
57: l_P_SET_DEF_REC.SET_NUMBER := CSK_SETUP_UTILITY_PKG.get_next_set_number();
58: l_P_SET_DEF_REC.SET_TYPE_ID := CSK_SETUP_UTILITY_PKG.SOLN_TYPE_FAQ_API_TEST;
59: l_P_SET_DEF_REC.NAME := 'Move Solution Test s1_a';
60: l_P_SET_DEF_REC.visibility_id := CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST;
61:
62: l_P_ELE_DEF_TBL := CSK_SETUP_UTILITY_PKG.Stmt_tbl_type();

Line 60: l_P_SET_DEF_REC.visibility_id := CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST;

56: l_P_SET_DEF_REC.SET_ID := g_move_solutions_test_s1_aID;
57: l_P_SET_DEF_REC.SET_NUMBER := CSK_SETUP_UTILITY_PKG.get_next_set_number();
58: l_P_SET_DEF_REC.SET_TYPE_ID := CSK_SETUP_UTILITY_PKG.SOLN_TYPE_FAQ_API_TEST;
59: l_P_SET_DEF_REC.NAME := 'Move Solution Test s1_a';
60: l_P_SET_DEF_REC.visibility_id := CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST;
61:
62: l_P_ELE_DEF_TBL := CSK_SETUP_UTILITY_PKG.Stmt_tbl_type();
63:
64: l_P_CAT_DEF_TBL := CSK_SETUP_UTILITY_PKG.Cat_tbl_type();

Line 62: l_P_ELE_DEF_TBL := CSK_SETUP_UTILITY_PKG.Stmt_tbl_type();

58: l_P_SET_DEF_REC.SET_TYPE_ID := CSK_SETUP_UTILITY_PKG.SOLN_TYPE_FAQ_API_TEST;
59: l_P_SET_DEF_REC.NAME := 'Move Solution Test s1_a';
60: l_P_SET_DEF_REC.visibility_id := CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST;
61:
62: l_P_ELE_DEF_TBL := CSK_SETUP_UTILITY_PKG.Stmt_tbl_type();
63:
64: l_P_CAT_DEF_TBL := CSK_SETUP_UTILITY_PKG.Cat_tbl_type();
65: l_P_CAT_DEF_TBL.EXTEND;
66: l_P_CAT_DEF_TBL(1) := g_move_solutions_test_c1ID;

Line 64: l_P_CAT_DEF_TBL := CSK_SETUP_UTILITY_PKG.Cat_tbl_type();

60: l_P_SET_DEF_REC.visibility_id := CSK_SETUP_UTILITY_PKG.VISIBILITY_EXTERNAL_API_TEST;
61:
62: l_P_ELE_DEF_TBL := CSK_SETUP_UTILITY_PKG.Stmt_tbl_type();
63:
64: l_P_CAT_DEF_TBL := CSK_SETUP_UTILITY_PKG.Cat_tbl_type();
65: l_P_CAT_DEF_TBL.EXTEND;
66: l_P_CAT_DEF_TBL(1) := g_move_solutions_test_c1ID;
67:
68: CSK_SETUP_UTILITY_PKG.Create_Solution(

Line 68: CSK_SETUP_UTILITY_PKG.Create_Solution(

64: l_P_CAT_DEF_TBL := CSK_SETUP_UTILITY_PKG.Cat_tbl_type();
65: l_P_CAT_DEF_TBL.EXTEND;
66: l_P_CAT_DEF_TBL(1) := g_move_solutions_test_c1ID;
67:
68: CSK_SETUP_UTILITY_PKG.Create_Solution(
69: p_api_version => 1.0,
70: x_return_status => l_return_status,
71: x_msg_count => l_msg_count,
72: x_msg_data => l_msg_data,

Line 78: g_move_solutions_test_s1_bID := CSK_SETUP_UTILITY_PKG.get_next_set_id();

74: ,P_STMT_TBL => l_P_ELE_DEF_TBL
75: ,P_CAT_TBL => l_P_CAT_DEF_TBL
76: ,P_PUBLISH => true );
77:
78: g_move_solutions_test_s1_bID := CSK_SETUP_UTILITY_PKG.get_next_set_id();
79: l_P_SET_DEF_REC.SET_ID := g_move_solutions_test_s1_bID;
80: l_P_SET_DEF_REC.NAME := 'Move Solution Test Solution s1_b';
81: CSK_SETUP_UTILITY_PKG.Create_Solution(
82: p_api_version => 1.0,

Line 81: CSK_SETUP_UTILITY_PKG.Create_Solution(

77:
78: g_move_solutions_test_s1_bID := CSK_SETUP_UTILITY_PKG.get_next_set_id();
79: l_P_SET_DEF_REC.SET_ID := g_move_solutions_test_s1_bID;
80: l_P_SET_DEF_REC.NAME := 'Move Solution Test Solution s1_b';
81: CSK_SETUP_UTILITY_PKG.Create_Solution(
82: p_api_version => 1.0,
83: x_return_status => l_return_status,
84: x_msg_count => l_msg_count,
85: x_msg_data => l_msg_data,

Line 104: CSK_SETUP_UTILITY_PKG.delete_solution(

100: l_msg_count number;
101: l_msg_data varchar2(200);
102: begin
103:
104: CSK_SETUP_UTILITY_PKG.delete_solution(
105: p_api_version => 1.0,
106: x_return_status => l_return_status,
107: x_msg_count => l_msg_count,
108: x_msg_data => l_msg_data,

Line 110: CSK_SETUP_UTILITY_PKG.delete_solution(

106: x_return_status => l_return_status,
107: x_msg_count => l_msg_count,
108: x_msg_data => l_msg_data,
109: P_set_ID => g_move_solutions_test_s1_aID);
110: CSK_SETUP_UTILITY_PKG.delete_solution(
111: p_api_version => 1.0,
112: x_return_status => l_return_status,
113: x_msg_count => l_msg_count,
114: x_msg_data => l_msg_data,

Line 116: CSK_SETUP_UTILITY_PKG.Delete_Category (

112: x_return_status => l_return_status,
113: x_msg_count => l_msg_count,
114: x_msg_data => l_msg_data,
115: P_set_ID => g_move_solutions_test_s1_bID);
116: CSK_SETUP_UTILITY_PKG.Delete_Category (
117: p_api_version => 1.0,
118: x_return_status => l_return_status,
119: x_msg_count => l_msg_count,
120: x_msg_data => l_msg_data,

Line 122: CSK_SETUP_UTILITY_PKG.Delete_Category (

118: x_return_status => l_return_status,
119: x_msg_count => l_msg_count,
120: x_msg_data => l_msg_data,
121: P_CATEGORY_ID => g_move_solutions_test_c1ID);
122: CSK_SETUP_UTILITY_PKG.Delete_Category (
123: p_api_version => 1.0,
124: x_return_status => l_return_status,
125: x_msg_count => l_msg_count,
126: x_msg_data => l_msg_data,

Line 260: l_index_content := CSK_SETUP_UTILITY_PKG.Calculate_Set_Index_Content(g_move_solutions_test_s1_aID);

256: where set_id = g_move_solutions_test_s1_bID and category_id = g_move_solutions_test_c1ID;
257: if l_count_1 = 0 and l_count_2 = 0 then
258: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 30] solutions have been moved out of c1');
259: --step 40
260: l_index_content := CSK_SETUP_UTILITY_PKG.Calculate_Set_Index_Content(g_move_solutions_test_s1_aID);
261: select INSTR(l_index_content,'') into l_end_tag from dual;
262: if (l_end_tag > 0) then
263: select INSTR(l_index_content,'') into l_start_tag from dual;
264: l_categories_section := substr(l_index_content,l_start_tag+12,l_end_tag-l_start_tag-12);