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 732: * bom_delete_sql_statements table that are valid for given

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

Line 746: FROM BOM_DELETE_SQL_STATEMENTS

742: SELECT SQL_STATEMENT_NAME stmt_name,
743: DELETE_ON_SUCCESS_FLAG delete_on_success_flag,
744: MESSAGE_NAME,
745: SQL_STATEMENT
746: FROM BOM_DELETE_SQL_STATEMENTS
747: WHERE SQL_STATEMENT_TYPE = 1
748: AND ACTIVE_FLAG = 1
749: AND DELETE_ENTITY_TYPE = p_delete_entity_type;
750:

Line 810: FROM BOM_DELETE_SQL_STATEMENTS

806: */
807: stmt_num := 4;
808: SELECT SQL_STATEMENT
809: INTO constraint_stmt
810: FROM BOM_DELETE_SQL_STATEMENTS
811: WHERE SQL_STATEMENT_NAME = cur_rec.stmt_name;
812:
813: constraint_stmt := UPPER(constraint_stmt);
814: if(p_debug = 'Y')then

Line 1163: * bom_delete_sql_statements table that are valid for given

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

Line 1176: FROM BOM_DELETE_SQL_STATEMENTS

1172: CURSOR delete_cursor(p_delete_entity_type NUMBER) IS
1173: SELECT sql_statement stmt, ARCHIVE_TABLE_NAME,
1174: length(ARCHIVE_TABLE_NAME) archive_table_length,
1175: SQL_STATEMENT_NAME stmt_name
1176: FROM BOM_DELETE_SQL_STATEMENTS
1177: WHERE SQL_STATEMENT_TYPE = 2
1178: AND ACTIVE_FLAG = 1
1179: AND DELETE_ENTITY_TYPE = p_delete_entity_type
1180: ORDER BY SEQUENCE_NUMBER;

Line 1278: * bom_delete_sql_statements table that are valid for given

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

Line 1294: FROM BOM_DELETE_SQL_STATEMENTS

1290: IS
1291: SELECT
1292: SQL_STATEMENT stmt,
1293: SQL_STATEMENT_NAME stmt_name
1294: FROM BOM_DELETE_SQL_STATEMENTS
1295: WHERE
1296: SQL_STATEMENT_TYPE = 3
1297: AND ACTIVE_FLAG = 1
1298: AND DELETE_ENTITY_TYPE = p_delete_entity_type