518: --Start of Comments
519: --Name: UDA_SUBMISSION_CHECK
520: --Procedure:
521: -- This procedure would execute ego_user_attrs_data_pub.Get_User_Attrs_Data to get the
522: -- EGO_USER_ATTR_ROW_TABLE and EGO_USER_ATTR_DATA_TABLE to execute all the XSC Uda functions
523: --Parameters:
524: --IN:
525: -- 1. p_pk1_value, p_pk2_value, p_pk3_value, p_pk4_value, p_pk5_value
526: -- The Primary Key values for the UDA Attributes
595:
596: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
597:
598: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
599: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
600: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
601:
602: l_pk_col_name_value_pairs_ind NUMBER;
603: l_attr_name_value_pairs_ind NUMBER;
889: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows :', d_progress);
890: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
891:
892: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
893: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
894: d_progress := 580;
895: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_attributes_row_table, l_attr_name_value_pairs' , d_progress);
896:
897: PO_UDA_DEFAULTING_PKG.DEBUG('x_return_status : ' || x_return_status , d_progress);
1738: IS
1739: d_progress NUMBER := 0;
1740: l_po_uda_usage_object_array PO_UDA_USAGE_OBJECT_ARRAY;
1741:
1742: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
1743: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1744:
1745: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1746:
1883: )IS
1884:
1885: d_progress NUMBER := 0;
1886:
1887: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
1888: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
1889:
1890: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1891:
1952: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
1953:
1954: d_progress := 70;
1955: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
1956: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
1957: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_attributes_row_table, l_attr_name_value_pairs', d_progress);
1958: d_progress := 80;
1959: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
1960: (
2232:
2233: l_attr_group_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
2234:
2235: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
2236: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE;
2237: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2238:
2239: l_pk_col_name_value_pairs_ind NUMBER;
2240: l_attr_name_value_pairs_ind NUMBER;
2501: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows :', d_progress);
2502: PO_UDA_DEFAULTING_PKG.DEBUG(l_pk_column_name_value_pairs, d_progress);
2503:
2504: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();
2505: l_attr_name_value_pairs := EGO_USER_ATTR_DATA_TABLE();
2506: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_attributes_row_table, l_attr_name_value_pairs' , d_progress);
2507:
2508: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
2509: (
3220: END DEBUG;
3221:
3222: PROCEDURE DEBUG
3223: (
3224: p_structure_array IN EGO_USER_ATTR_DATA_TABLE
3225: ,p_progress IN NUMBER
3226: )
3227: IS
3228: l_structure_ind NUMBER;