[Home] [Help]
2468:
2469: -- Initialize API return status to success
2470: x_return_status := G_RET_STS_SUCCESS;
2471:
2472: INSERT INTO fem_pl_chains (request_id, object_id,
2473: source_created_by_request_id, source_created_by_object_id,
2474: created_by, creation_date, last_updated_by, last_update_date,
2475: last_update_login)
2476: SELECT
4051: -- the input object execution
4052: -- x_chain_exists Flag to indicate if the input object execution
4053: -- has been chained to another execution.
4054: -- Logic
4055: -- Checks fem_pl_chains table to see if the input object execution
4056: -- exists as a source. If yes, then set x_chain_exists to 'T' and also
4057: -- set x_dep_request/object_id parameters with the dependent object
4058: -- execution information. Otherwise, set x_chain_exists to 'F'.
4059: -- =========================================================================
4066: e_unexp EXCEPTION;
4067: --
4068: CURSOR c_chains (p_request_id NUMBER, p_object_id NUMBER) IS
4069: SELECT request_id, object_id
4070: FROM fem_pl_chains
4071: WHERE source_created_by_request_id = p_request_id
4072: AND source_created_by_object_id = p_object_id;
4073: --
4074: BEGIN