APPS.BOM_DELETE_GROUPS_API dependencies on BOM_DELETE_SQL_STATEMENTS

Line 91: * bom_delete_sql_statements table that are valid for given

87: * Parameters IN :token_list-TOKEN_RECORD, delete_seq_id, delete_entity_type
88: * Parameters OUT: err_text
89: * return : 0 -success ,2-error, other - SQL Exception
90: * Purpose : This function checks all the constraints from
91: * bom_delete_sql_statements table that are valid for given
92: * delete entity type
93: ******************************************************************/
94:
95: FUNCTION constraint_checker( token_list IN TOKEN_RECORD,

Line 150: * bom_delete_sql_statements table that are valid for given

146: * archive_flag
147: * Parameters OUT: err_text, action_status(4-delete,3-error)
148: * return : 0 -success , other - SQL Exception
149: * Purpose : This function executes the delete statements from
150: * bom_delete_sql_statements table that are valid for given
151: * delete entity type
152: ******************************************************************/
153:
154: FUNCTION execute_delete(delete_entity_type IN NUMBER,

Line 169: * bom_delete_sql_statements table that are valid for given

165: * Parameters OUT: action_status 4-delete, 3-error
166: * err_text Error message in case of exception
167: * return : 0 -success , other - SQL Exception
168: * Purpose : This function executes the update statements from
169: * bom_delete_sql_statements table that are valid for given
170: * delete entity type
171: ******************************************************************/
172:
173: FUNCTION execute_update (

Line 737: * bom_delete_sql_statements table that are valid for given

733: * Parameters IN :token_list-TOKEN_RECORD, delete_seq_id, delete_entity_type
734: * Parameters OUT: err_text
735: * return : 0 -success ,2-error, other - SQL Exception
736: * Purpose : This function checks all the constraints from
737: * bom_delete_sql_statements table that are valid for given
738: * delete entity type
739: ******************************************************************/
740:
741: FUNCTION constraint_checker( token_list IN Token_Record,

Line 751: FROM BOM_DELETE_SQL_STATEMENTS

747: SELECT SQL_STATEMENT_NAME stmt_name,
748: DELETE_ON_SUCCESS_FLAG delete_on_success_flag,
749: MESSAGE_NAME,
750: SQL_STATEMENT
751: FROM BOM_DELETE_SQL_STATEMENTS
752: WHERE SQL_STATEMENT_TYPE = 1
753: AND ACTIVE_FLAG = 1
754: AND DELETE_ENTITY_TYPE = p_delete_entity_type;
755:

Line 815: FROM BOM_DELETE_SQL_STATEMENTS

811: */
812: stmt_num := 4;
813: SELECT SQL_STATEMENT
814: INTO constraint_stmt
815: FROM BOM_DELETE_SQL_STATEMENTS
816: WHERE SQL_STATEMENT_NAME = cur_rec.stmt_name;
817:
818: constraint_stmt := UPPER(constraint_stmt);
819: if(p_debug = 'Y')then

Line 1168: * bom_delete_sql_statements table that are valid for given

1164: * archive_flag
1165: * Parameters OUT: err_text, action_status(4-delete,3-error)
1166: * return : 0 -success , other - SQL Exception
1167: * Purpose : This function executes the delete statements from
1168: * bom_delete_sql_statements table that are valid for given
1169: * delete entity type
1170: ******************************************************************/
1171: FUNCTION execute_delete(delete_entity_type IN NUMBER,
1172: token_list IN Token_Record,

Line 1181: FROM BOM_DELETE_SQL_STATEMENTS

1177: CURSOR delete_cursor(p_delete_entity_type NUMBER) IS
1178: SELECT sql_statement stmt, ARCHIVE_TABLE_NAME,
1179: length(ARCHIVE_TABLE_NAME) archive_table_length,
1180: SQL_STATEMENT_NAME stmt_name
1181: FROM BOM_DELETE_SQL_STATEMENTS
1182: WHERE SQL_STATEMENT_TYPE = 2
1183: AND ACTIVE_FLAG = 1
1184: AND DELETE_ENTITY_TYPE = p_delete_entity_type
1185: ORDER BY SEQUENCE_NUMBER;

Line 1283: * bom_delete_sql_statements table that are valid for given

1279: * Parameters OUT: action_status 4-delete, 3-error
1280: * err_text Error message in case of exception
1281: * return : 0 -success , other - SQL Exception
1282: * Purpose : This function executes the update statements from
1283: * bom_delete_sql_statements table that are valid for given
1284: * delete entity type
1285: ******************************************************************/
1286:
1287: FUNCTION execute_update (

Line 1299: FROM BOM_DELETE_SQL_STATEMENTS

1295: IS
1296: SELECT
1297: SQL_STATEMENT stmt,
1298: SQL_STATEMENT_NAME stmt_name
1299: FROM BOM_DELETE_SQL_STATEMENTS
1300: WHERE
1301: SQL_STATEMENT_TYPE = 3
1302: AND ACTIVE_FLAG = 1
1303: AND DELETE_ENTITY_TYPE = p_delete_entity_type