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 125: l_types_tbl cs_kb_number_tbl_type := cs_kb_number_tbl_type();

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

Line 215: p_id_tbl in cs_kb_number_tbl_type,

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

Line 404: p_ele_id_tbl in cs_kb_number_tbl_type)

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

Line 573: p_other_id_tbl in cs_kb_number_tbl_type,

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

Line 711: p_link_id_tbl in cs_kb_number_tbl_type,

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

Line 712: p_ele_type_id_tbl in cs_kb_number_tbl_type

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

Line 832: p_link_id_tbl in cs_kb_number_tbl_type,

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

Line 833: p_set_id_tbl in cs_kb_number_tbl_type

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

Line 950: p_set_id_tbl in cs_kb_number_tbl_type,

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

Line 951: p_new_ele_id_tbl in cs_kb_number_tbl_type

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

Line 1114: p_link_id_tbl in cs_kb_number_tbl_type,

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

Line 1115: p_element_id_tbl in cs_kb_number_tbl_type

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

Line 1574: l_element_id_tbl cs_kb_number_tbl_type;

1570: l_set_def_obj cs_kb_set_def_obj_type;
1571: l_ele_def_tbl cs_kb_ele_def_tbl_type;
1572: i1 pls_integer;
1573: i2 pls_integer;
1574: l_element_id_tbl cs_kb_number_tbl_type;
1575: l_ele_assoc_tbl cs_kb_number_tbl_type;
1576: begin
1577:
1578: if(p_ele_def_tbl is not null) then

Line 1575: l_ele_assoc_tbl cs_kb_number_tbl_type;

1571: l_ele_def_tbl cs_kb_ele_def_tbl_type;
1572: i1 pls_integer;
1573: i2 pls_integer;
1574: l_element_id_tbl cs_kb_number_tbl_type;
1575: l_ele_assoc_tbl cs_kb_number_tbl_type;
1576: begin
1577:
1578: if(p_ele_def_tbl is not null) then
1579: l_ele_def_tbl := cs_kb_ele_def_tbl_type();

Line 1651: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

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

Line 1664: l_ele_id_tbl cs_kb_number_tbl_type := cs_kb_number_tbl_type();

1660: l_created_by number;
1661: l_login number;
1662: j pls_integer;
1663: i1 pls_integer;
1664: l_ele_id_tbl cs_kb_number_tbl_type := cs_kb_number_tbl_type();
1665:
1666: begin
1667: --if ele tab valid
1668: --insert elements if any

Line 1766: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

1762: x_msg_data OUT NOCOPY varchar2,
1763: p_set_def_obj in cs_kb_set_def_obj_type,
1764: p_ele_def_tbl in cs_kb_ele_def_tbl_type,
1765: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
1766: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
1767: x_set_id OUT NOCOPY number,
1768: x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type
1769: )
1770: IS

Line 1768: x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type

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

Line 1840: x_element_id_tbl := cs_kb_number_tbl_type();

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

Line 2057: l_ele_id_tbl cs_kb_number_tbl_type

2053: p_ele_id_tbl in CS_Knowledge_PUB.number15_tbl_type,
2054: x_set_id OUT NOCOPY number
2055: ) is
2056: l_set_def_obj cs_kb_set_def_obj_type;
2057: l_ele_id_tbl cs_kb_number_tbl_type
2058: := cs_kb_number_tbl_type();
2059: i1 pls_integer;
2060: begin
2061:

Line 2058: := cs_kb_number_tbl_type();

2054: x_set_id OUT NOCOPY number
2055: ) is
2056: l_set_def_obj cs_kb_set_def_obj_type;
2057: l_ele_id_tbl cs_kb_number_tbl_type
2058: := cs_kb_number_tbl_type();
2059: i1 pls_integer;
2060: begin
2061:
2062: if(p_ele_id_tbl is null ) then

Line 2108: p_ele_id_tbl in cs_kb_number_tbl_type,

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

Line 2109: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

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