[Home] [Help]
128: -- 11/08/05 mviswana Created
129: -- -----------------------------------------------------------------------------
130: PROCEDURE Log_EGO_Ext_PVT_Parameters(
131: p_ext_attr_grp_tbl IN EGO_USER_ATTR_ROW_TABLE
132: ,p_ext_attr_tbl IN EGO_USER_ATTR_DATA_TABLE) ;
133:
134:
135: -- =============================================================================
136: -- Private Functions
269: ,x_msg_count OUT NOCOPY NUMBER
270: ,x_msg_data OUT NOCOPY VARCHAR2
271: )IS
272:
273: l_user_attr_data_table EGO_USER_ATTR_DATA_TABLE;
274: l_user_attr_row_table EGO_USER_ATTR_ROW_TABLE;
275: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;
276: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
277: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
1120: END IF; -- end if of l_application_id IS NULL ..
1121: END IF; -- end if of IF p_ext_attr_grp_tbl(i).mapping_req = 'Y'
1122:
1123: --Get the attributes relevant to the attribute group and prepare to pass it to PLM
1124: -- Instanciate a new EGO_USER_ATTR_DATA_TABLE or clear out the existing one --
1125: IF p_ext_attr_grp_tbl(i).context <> l_old_context AND
1126: l_old_context IS NOT NULL THEN
1127: IF (l_user_attr_data_table IS NULL) THEN
1128: l_user_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
1124: -- Instanciate a new EGO_USER_ATTR_DATA_TABLE or clear out the existing one --
1125: IF p_ext_attr_grp_tbl(i).context <> l_old_context AND
1126: l_old_context IS NOT NULL THEN
1127: IF (l_user_attr_data_table IS NULL) THEN
1128: l_user_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
1129: ELSE
1130: l_user_attr_data_table.DELETE();
1131: END IF;
1132: ELSE
1130: l_user_attr_data_table.DELETE();
1131: END IF;
1132: ELSE
1133: IF (l_user_attr_data_table IS NULL) THEN
1134: l_user_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
1135: END IF;
1136: END IF;
1137:
1138: FOR j IN l_ext_attr_tbl.FIRST .. l_ext_attr_tbl.LAST LOOP
1146:
1147: --DBMS_OUTPUT.PUT_LINE('l_user_attr_data_table.COUNT'||l_user_attr_data_table.COUNT);
1148:
1149: ELSE
1150: l_user_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
1151: END IF; -- count > 1
1152:
1153: --set the old context
1154: l_old_context := p_ext_attr_grp_tbl(i).context;
1314: NULL,NULL,NULL,'GENERIC_LEVEL', NULL, NULL,NULL,NULL,NULL, EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE);
1315:
1316: END LOOP;
1317: -- Instantiate the attribute table once
1318: l_user_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
1319:
1320: --DBMS_OUTPUT.PUT_LINE('Calling to delete data, user attr row table count:'|| l_user_attr_row_table.count);
1321:
1322: --Call PLM for deleting the old data
1823: END IF; -- end if of IF p_ext_attr_grp_tbl(i).mapping_req = 'Y'
1824:
1825:
1826: --Get the attributes relevant to the attribute group and prepare to pass it to PLM
1827: -- Instanciate a new EGO_USER_ATTR_DATA_TABLE or clear out the existing one --
1828: IF p_ext_attr_grp_tbl(i).context <> l_old_context AND
1829: l_old_context IS NOT NULL THEN
1830: IF (l_user_attr_data_table IS NULL) THEN
1831: l_user_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
1827: -- Instanciate a new EGO_USER_ATTR_DATA_TABLE or clear out the existing one --
1828: IF p_ext_attr_grp_tbl(i).context <> l_old_context AND
1829: l_old_context IS NOT NULL THEN
1830: IF (l_user_attr_data_table IS NULL) THEN
1831: l_user_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
1832: ELSE
1833: l_user_attr_data_table.DELETE();
1834: END IF;
1835: ELSE
1833: l_user_attr_data_table.DELETE();
1834: END IF;
1835: ELSE
1836: IF (l_user_attr_data_table IS NULL) THEN
1837: l_user_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
1838: END IF;
1839: END IF;
1840:
1841: --DBMS_OUTPUT.PUT_LINE('Instanciated AAttr object');
3966:
3967: l_pk_col_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;
3968: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
3969: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
3970: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
3971: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
3972: l_return_status VARCHAR2(1);
3973: l_errorcode NUMBER;
3974: l_msg_count NUMBER;
6449: -- 11/08/05 mviswana Created
6450: -- -----------------------------------------------------------------------------
6451: PROCEDURE Log_EGO_Ext_PVT_Parameters(
6452: p_ext_attr_grp_tbl IN EGO_USER_ATTR_ROW_TABLE
6453: ,p_ext_attr_tbl IN EGO_USER_ATTR_DATA_TABLE)
6454:
6455: IS
6456:
6457: l_api_name CONSTANT VARCHAR2(30) := 'Get_SR_Ext_Attrs';
6766: --
6767: l_pk_name_value_pair EGO_COL_NAME_VALUE_PAIR_ARRAY;
6768: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
6769: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
6770: l_user_attr_data_table EGO_USER_ATTR_DATA_TABLE;
6771: l_user_attr_row_table EGO_USER_ATTR_ROW_TABLE;
6772: l_count NUMBER;
6773: --
6774: CURSOR c_get_old_context_value
6839: l_user_attr_row_table(l_user_attr_row_table.LAST) := EGO_USER_ATTRS_DATA_PUB.Build_Attr_Group_Row_Object(l_count, v_get_old_context_value.attr_group_id,
6840: NULL,NULL,NULL,'GENERIC_LEVEL', NULL, NULL,NULL,NULL,NULL, EGO_USER_ATTRS_DATA_PVT.G_DELETE_MODE);
6841: END LOOP;
6842: -- Instantiate the attribute table once
6843: l_user_attr_data_table := EGO_USER_ATTR_DATA_TABLE();
6844:
6845: --DBMS_OUTPUT.PUT_LINE('Calling to delete data, user attr row table count:'|| l_user_attr_row_table.count);
6846:
6847: --Call PLM for deleting the old data