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.CS_KNOWLEDGE_PVT dependencies on CS_KB_NUMBER_TBL_TYPE

Line 123: l_types_tbl cs_kb_number_tbl_type := cs_kb_number_tbl_type();

119: FUNCTION Is_Required_Type_Missing(
120: p_set_type_id in number,
121: p_ele_def_tbl in cs_kb_ele_def_tbl_type
122: ) return varchar2 is
123: l_types_tbl cs_kb_number_tbl_type := cs_kb_number_tbl_type();
124: i1 pls_integer;
125: i2 pls_integer;
126: l_count pls_integer;
127: l_type_id number;

Line 213: p_id_tbl in cs_kb_number_tbl_type,

209: -- Given a table of num 15,
210: -- return a string of the numbers separated by p_separator
211: --
212: FUNCTION Concat_Ids(
213: p_id_tbl in cs_kb_number_tbl_type,
214: p_separator in varchar2
215: ) return varchar2 is
216: l_str varchar2(1990) := null;
217: i1 pls_integer;

Line 402: p_ele_id_tbl in cs_kb_number_tbl_type)

398: --
399:
400: /* New - uses bind variables */
401: FUNCTION Do_Elements_Exist_In_Set (
402: p_ele_id_tbl in cs_kb_number_tbl_type)
403: return varchar2 is
404: l_csr CS_Knowledge_PUB.general_csr_type;
405: l_sid number(15);
406: l_total pls_integer :=0;

Line 571: p_other_id_tbl in cs_kb_number_tbl_type,

567: x_msg_data OUT NOCOPY varchar2,
568: p_usage_code in varchar2,
569: p_id in number,
570: p_object_code in varchar2,
571: p_other_id_tbl in cs_kb_number_tbl_type,
572: p_other_code_tbl in cs_kb_varchar100_tbl_type
573: ) is
574: l_api_name CONSTANT varchar2(30) := 'Add_External_Links';
575: l_api_version CONSTANT number := 1.0;

Line 709: p_link_id_tbl in cs_kb_number_tbl_type,

705: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
706: x_return_status OUT NOCOPY varchar2,
707: x_msg_count OUT NOCOPY number,
708: x_msg_data OUT NOCOPY varchar2,
709: p_link_id_tbl in cs_kb_number_tbl_type,
710: p_ele_type_id_tbl in cs_kb_number_tbl_type
711: )is
712: l_api_name CONSTANT varchar2(30) := 'Change_Ele_Type_Links';
713: l_api_version CONSTANT number := 1.0;

Line 710: p_ele_type_id_tbl in cs_kb_number_tbl_type

706: x_return_status OUT NOCOPY varchar2,
707: x_msg_count OUT NOCOPY number,
708: x_msg_data OUT NOCOPY varchar2,
709: p_link_id_tbl in cs_kb_number_tbl_type,
710: p_ele_type_id_tbl in cs_kb_number_tbl_type
711: )is
712: l_api_name CONSTANT varchar2(30) := 'Change_Ele_Type_Links';
713: l_api_version CONSTANT number := 1.0;
714: l_ele_type_id number;

Line 830: p_link_id_tbl in cs_kb_number_tbl_type,

826: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
827: x_return_status OUT NOCOPY varchar2,
828: x_msg_count OUT NOCOPY number,
829: x_msg_data OUT NOCOPY varchar2,
830: p_link_id_tbl in cs_kb_number_tbl_type,
831: p_set_id_tbl in cs_kb_number_tbl_type
832: )is
833: l_api_name CONSTANT varchar2(30) := 'Change_Set_Links';
834: l_api_version CONSTANT number := 1.0;

Line 831: p_set_id_tbl in cs_kb_number_tbl_type

827: x_return_status OUT NOCOPY varchar2,
828: x_msg_count OUT NOCOPY number,
829: x_msg_data OUT NOCOPY varchar2,
830: p_link_id_tbl in cs_kb_number_tbl_type,
831: p_set_id_tbl in cs_kb_number_tbl_type
832: )is
833: l_api_name CONSTANT varchar2(30) := 'Change_Set_Links';
834: l_api_version CONSTANT number := 1.0;
835: l_set_id number;

Line 948: p_set_id_tbl in cs_kb_number_tbl_type,

944: x_return_status OUT NOCOPY varchar2,
945: x_msg_count OUT NOCOPY number,
946: x_msg_data OUT NOCOPY varchar2,
947: p_element_id in number,
948: p_set_id_tbl in cs_kb_number_tbl_type,
949: p_new_ele_id_tbl in cs_kb_number_tbl_type
950: )is
951: l_api_name CONSTANT varchar2(30) := 'Change_Element_To_Sets';
952: l_api_version CONSTANT number := 1.0;

Line 949: p_new_ele_id_tbl in cs_kb_number_tbl_type

945: x_msg_count OUT NOCOPY number,
946: x_msg_data OUT NOCOPY varchar2,
947: p_element_id in number,
948: p_set_id_tbl in cs_kb_number_tbl_type,
949: p_new_ele_id_tbl in cs_kb_number_tbl_type
950: )is
951: l_api_name CONSTANT varchar2(30) := 'Change_Element_To_Sets';
952: l_api_version CONSTANT number := 1.0;
953: l_element_id number;

Line 1112: p_link_id_tbl in cs_kb_number_tbl_type,

1108: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
1109: x_return_status OUT NOCOPY varchar2,
1110: x_msg_count OUT NOCOPY number,
1111: x_msg_data OUT NOCOPY varchar2,
1112: p_link_id_tbl in cs_kb_number_tbl_type,
1113: p_element_id_tbl in cs_kb_number_tbl_type
1114: )is
1115: l_api_name CONSTANT varchar2(30) := 'Change_Element_Links';
1116: l_api_version CONSTANT number := 1.0;

Line 1113: p_element_id_tbl in cs_kb_number_tbl_type

1109: x_return_status OUT NOCOPY varchar2,
1110: x_msg_count OUT NOCOPY number,
1111: x_msg_data OUT NOCOPY varchar2,
1112: p_link_id_tbl in cs_kb_number_tbl_type,
1113: p_element_id_tbl in cs_kb_number_tbl_type
1114: )is
1115: l_api_name CONSTANT varchar2(30) := 'Change_Element_Links';
1116: l_api_version CONSTANT number := 1.0;
1117: l_element_id number;

Line 1570: l_element_id_tbl cs_kb_number_tbl_type;

1566: l_set_def_obj cs_kb_set_def_obj_type;
1567: l_ele_def_tbl cs_kb_ele_def_tbl_type;
1568: i1 pls_integer;
1569: i2 pls_integer;
1570: l_element_id_tbl cs_kb_number_tbl_type;
1571: l_ele_assoc_tbl cs_kb_number_tbl_type;
1572: begin
1573:
1574: if(p_ele_def_tbl is not null) then

Line 1571: l_ele_assoc_tbl cs_kb_number_tbl_type;

1567: l_ele_def_tbl cs_kb_ele_def_tbl_type;
1568: i1 pls_integer;
1569: i2 pls_integer;
1570: l_element_id_tbl cs_kb_number_tbl_type;
1571: l_ele_assoc_tbl cs_kb_number_tbl_type;
1572: begin
1573:
1574: if(p_ele_def_tbl is not null) then
1575: l_ele_def_tbl := cs_kb_ele_def_tbl_type();

Line 1647: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

1643: x_msg_data OUT NOCOPY varchar2,
1644: p_set_def_obj in cs_kb_set_def_obj_type,
1645: p_ele_def_tbl in cs_kb_ele_def_tbl_type,
1646: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
1647: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
1648: x_set_id OUT NOCOPY number
1649: )is
1650: l_api_name CONSTANT varchar2(30) := 'Create_Set_And_Elements';
1651: l_api_version CONSTANT number := 1.0;

Line 1660: l_ele_id_tbl cs_kb_number_tbl_type := cs_kb_number_tbl_type();

1656: l_created_by number;
1657: l_login number;
1658: j pls_integer;
1659: i1 pls_integer;
1660: l_ele_id_tbl cs_kb_number_tbl_type := cs_kb_number_tbl_type();
1661:
1662: begin
1663: --if ele tab valid
1664: --insert elements if any

Line 1762: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

1758: x_msg_data OUT NOCOPY varchar2,
1759: p_set_def_obj in cs_kb_set_def_obj_type,
1760: p_ele_def_tbl in cs_kb_ele_def_tbl_type,
1761: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
1762: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
1763: x_set_id OUT NOCOPY number,
1764: x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type
1765: )
1766: IS

Line 1764: x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type

1760: p_ele_def_tbl in cs_kb_ele_def_tbl_type,
1761: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
1762: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
1763: x_set_id OUT NOCOPY number,
1764: x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type
1765: )
1766: IS
1767: l_api_name CONSTANT varchar2(30) := 'Create_Set_And_Elements';
1768: l_api_version CONSTANT number := 1.0;

Line 1836: x_element_id_tbl := cs_kb_number_tbl_type();

1832:
1833: -- -- -- -- begin my code -- -- -- -- --
1834:
1835: -- Create output element id list
1836: x_element_id_tbl := cs_kb_number_tbl_type();
1837:
1838: -- Check params
1839: if(p_set_def_obj.set_type_id is null or
1840: p_set_def_obj.set_type_id <=0 or

Line 2053: l_ele_id_tbl cs_kb_number_tbl_type

2049: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
2050: x_set_id OUT NOCOPY number
2051: ) is
2052: l_set_def_obj cs_kb_set_def_obj_type;
2053: l_ele_id_tbl cs_kb_number_tbl_type
2054: := cs_kb_number_tbl_type();
2055: i1 pls_integer;
2056: begin
2057:

Line 2054: := cs_kb_number_tbl_type();

2050: x_set_id OUT NOCOPY number
2051: ) is
2052: l_set_def_obj cs_kb_set_def_obj_type;
2053: l_ele_id_tbl cs_kb_number_tbl_type
2054: := cs_kb_number_tbl_type();
2055: i1 pls_integer;
2056: begin
2057:
2058: if(p_ele_id_tbl is null ) then

Line 2104: p_ele_id_tbl in cs_kb_number_tbl_type,

2100: x_return_status OUT NOCOPY varchar2,
2101: x_msg_count OUT NOCOPY number,
2102: x_msg_data OUT NOCOPY varchar2,
2103: p_set_def_obj in cs_kb_set_def_obj_type,
2104: p_ele_id_tbl in cs_kb_number_tbl_type,
2105: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
2106: x_set_id OUT NOCOPY number
2107: ) is
2108: l_api_name CONSTANT varchar2(30) := 'Create_Set';

Line 2105: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

2101: x_msg_count OUT NOCOPY number,
2102: x_msg_data OUT NOCOPY varchar2,
2103: p_set_def_obj in cs_kb_set_def_obj_type,
2104: p_ele_id_tbl in cs_kb_number_tbl_type,
2105: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
2106: x_set_id OUT NOCOPY number
2107: ) is
2108: l_api_name CONSTANT varchar2(30) := 'Create_Set';
2109: l_api_version CONSTANT number := 1.0;