[Home] [Help]
1824: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1825: p_api_version_number IN NUMBER,
1826: p_return_status OUT NOCOPY VARCHAR2,
1827: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1828: p_attribute_pk_tbl IN AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type
1829: := AK_ATTRIBUTE_PUB.G_MISS_ATTRIBUTE_PK_TBL,
1830: p_nls_language IN VARCHAR2
1831: ) is
1832: cursor l_get_attribute_1_csr (appl_id_parm number) is
1825: p_api_version_number IN NUMBER,
1826: p_return_status OUT NOCOPY VARCHAR2,
1827: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
1828: p_attribute_pk_tbl IN AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type
1829: := AK_ATTRIBUTE_PUB.G_MISS_ATTRIBUTE_PK_TBL,
1830: p_nls_language IN VARCHAR2
1831: ) is
1832: cursor l_get_attribute_1_csr (appl_id_parm number) is
1833: select *
2145: ) is
2146: l_api_version_number CONSTANT number := 1.0;
2147: l_api_name CONSTANT varchar2(30) := 'Upload_Attribute';
2148: l_attribute_rec ak_attributes%ROWTYPE;
2149: l_attribute_tl_rec AK_ATTRIBUTE_PUB.Attribute_Tl_Rec_Type;
2150: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
2151: l_column varchar2(30);
2152: l_dummy NUMBER;
2153: l_empty_attribute_rec ak_attributes%ROWTYPE;
2150: l_buffer AK_ON_OBJECTS_PUB.Buffer_Type;
2151: l_column varchar2(30);
2152: l_dummy NUMBER;
2153: l_empty_attribute_rec ak_attributes%ROWTYPE;
2154: l_empty_attribute_tl_rec AK_ATTRIBUTE_PUB.Attribute_Tl_Rec_Type;
2155: l_eof_flag VARCHAR2(1);
2156: l_line_num NUMBER;
2157: l_lines_read NUMBER;
2158: l_msg_count NUMBER;
2979: procedure INSERT_ATTRIBUTE_PK_TABLE (
2980: p_return_status OUT NOCOPY VARCHAR2,
2981: p_attribute_application_id IN NUMBER,
2982: p_attribute_code IN VARCHAR2,
2983: p_attribute_pk_tbl IN OUT NOCOPY AK_ATTRIBUTE_PUB.Attribute_PK_Tbl_Type
2984: ) is
2985: l_api_version_number CONSTANT number := 1.0;
2986: l_api_name CONSTANT varchar2(30) := 'Insert_Attribute_PK_Table';
2987: l_index NUMBER;